IDO REST API

I'm struggling with the IDO REST API's. I'm hoping someone can point me in the right direction. We are on the cloud version of Mongoose. What I want to do is load data into a Mongoose table from data in our on-premise SQL Server database.

I started by using the REST API Wizard form. I see the API's it created in Infor IONAPI. I can successfully run a Load Collection API from inside of IONAPI. It returns data. I can call this URL from a C# console app and it returns data.

Where I'm getting confused is on an Update Collection. I created an Insert using the REST API Wizard. In IONAPI, this method shows as a Get. I thought this would be a Post. There are only two parameters: Authorization and X-InforMongooseConfig. Page 142 of the "Infor Mongoose Integrating IDO's with External Applications" document shows setting the update properties. I did that and set the X-InforMongooseConfig to the update properties. When I run the service, I get a response that says that the first property cannot be null. So I must not be passing the update properties correctly. Does anyone know how to pass the update properties to an IDO REST API created with the wizard?

I don't have to use IONAPI. The "Infor Mongoose Integrating IDO's with External Applications" document has examples that don't use ION API. That document says that all endpoints are accessible using HTTP(S) and are located at this URL. http://<serverName>/IDORequestService/ido

What I don't know is what the server name should be. I can enter this into my browser and see swagger: https://mguseastws.mtmgf.mongoosepaas.io/IDORequestService/ido/api-docs/

But I assume that I'm going to have to tell it my tenant. Can someone tell me how I add my tenant into that address? Also, I that all IDO's are available to the REST service and I don't have to use the REST API Wizard. Is that correct?

I appreciate any help anyone can give me. Do you recommend using the ION API's or the REST API's that are not exposed to ION API?

Find more posts tagged with

Accepted answers

All comments

Legacy Contributor

I've done a WinForms POC using VB.net using the REST v2 API. After loading a grid from an IDO, the user clicks the row in the gridview that they want to update and they are prompted to enter a description and UM. I chose to update 2 fields using the routine below. I then use the code below to create update properties with that information and do the update.

note:

1. xxxxx in the request URL should be your unique URL

2. The m_Token is the token retrieved earlier

Private Sub btnUpdateTwoFieldsInRecord_Click(sender As Object, e As EventArgs) Handles btnUpdateTwoFieldsInRecord.Click
'// Get the selected row index and retrieve the values from the cells in the row
Dim row As Int32 = DataGridView1.CurrentCell.RowIndex
Dim Desc As String = DataGridView1.Rows(row).Cells(1).Value
Dim UM As String = DataGridView1.Rows(row).Cells(2).Value
Dim ItemID As String = DataGridView1.Rows(row).Cells("ItemID").Value

'// Get input from user for the description and UOM to update
Dim updDesc As String = InputBox("Update the description from this row", "Update Description", Desc)
Dim updUM As String = InputBox("Update the UOM field from this row", "Update UM", UM)

'// Make sure both description and UOM are not blank
If updDesc.Trim.Length > 0 And updUM.Trim.Length > 0 Then
Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
Application.DoEvents()

Dim json As String = String.Empty

Using client = New HttpClient()
Dim ido As String = IDOName.SelectedItem
Dim requestUrl As String = "">xxxxxxxxxxx/.../" & ido & "?refresh=true"

'// provide token in the Authorization header
client.DefaultRequestHeaders.TryAddWithoutValidation("Authorization", m_Token)

'// Set the properties to update back to CSI
Dim strDesc As UpdateProperty = New UpdateProperty With {
.Name = "Description",
.Value = updDesc,
.IsNull = False,
.Modified = True
}
Dim UOM As UpdateProperty = New UpdateProperty With {
.Name = "UM",
.Value = updUM,
.IsNull = False,
.Modified = True
}

'// Create the IDOITEM object to contain the properties (fields) we are updating
Dim idoItem As IDOUpdateItem = New IDOUpdateItem With {
.Action = UpdateAction.Update,
.Properties = {strDesc, UOM},
.ItemId = ItemID
}

'// Build the request object that contains the IDOITEM object to update
Dim request As UpdateCollectionRequest = New UpdateCollectionRequest With {.Changes = {idoItem}}

'// Serialize the request object into JSON
Dim contentStr As String = JsonConvert.SerializeObject(request)

'// Call the API with the JSON string
Dim response As HttpResponseMessage = client.PostAsync(requestUrl.ToString(), New StringContent(contentStr, Encoding.UTF8, "application/json")).Result

'// Evaluate the response from the API Call
Using content As HttpContent = response.Content
Dim result As Task(Of String) = content.ReadAsStringAsync()
json = result.Result
End Using

Me.Cursor = System.Windows.Forms.Cursors.Default

If InStr(1, json.ToLower, "success") > 0 Then
MsgBox("Updated Successfully")
Else
MsgBox(json) '// display errors during update
End If
End Using
Else
MsgBox("Please specify both the new description and UOM to update")
End If
End Sub

tdickens

I should have mentioned in my post that I have studied both of your posts on REST API. Those were very helpful and lead me to finding the 'Integrating IDOs with External Applications' document. Before finding that document, I thought we had to call the REST API's through ION API.

In that document it says all endpoints are located at this URL. http://<serverName>/IDORequestService/ido

What I don't understand is what that URL is for me. We are on cloud based Mongoose. I know this is our Mongoose server.

https://mguseastap.mtmgf.mongoosepaas.io

I thought I needed to include our tenant in this URL. But now, I'm not so sure I need to include our tenant in the URL. It appears that I include my configuration when I get the token. And once I have a token then I don't need to include the configuration in the URL. Is that correct?

The example for getting the token shows setting the password as String.Empty. Are you doing that? When I set the password as empty, then I get an "Invalid Credentials" message. If I set the config to XXXX instead of our company name then I get an "Invalid Configuration" message. So I think I'm on the correct path. I just need to know if I'm getting the token correctly.

Here's how I'm getting the token. Is this how your getting the token?

Legacy Contributor

Example call to get Token for Rest V2:

mguseastap.mtmgf.mongoosepaas.io/.../Pass

Make sure you create a non SSO user to use. I just gave mine SuperUser, so I didn't have to manage their module assignments.

Your server URL depends on which farm your app is hosted from. But it looks like you have the right one for PaaS US East.

Legacy Contributor

Here is my security token code. You have to go into CSI users form and make sure the user id you are using for your token has the password set. Normally if you go through Mingle you dont need to set the password in CSI but I had to in order to get the API call to work. Then you have to pass the user id and password like how I did it below. In my case I had 2 textboxes on the screen where I entered it. I've heard that the best way is to use the OAUTH2 method but it takes more set up and I havent gotten to that point yet so this way was simpler.

For the servername in the URL, our Infor consultant told me what it was so someone should be able to get that for you.

Private Function GetTokenV2API() As String
Try

Using client = New System.Net.WebClient()
Dim requestUrl As String = "">xxxxxxxxx/.../" & cboConfig.SelectedItem & "/" & txtUserID.Text & "/" & txtPassword.Text
Dim result As String = client.DownloadString(requestUrl)
Dim tokenJson = JsonConvert.SerializeObject(result)
Dim jsonResult = JsonConvert.DeserializeObject(Of Dictionary(Of String, Object))(result)
m_Token = jsonResult.Item("Token")

If m_Token Is Nothing Then
MsgBox(result)
End If

Return m_Token
End Using

Catch ex As Exception
Throw
End Try
End Function

Legacy Contributor

Yes this looks like you are getting the token correctly.
Go ahead and set your user as super user, or assign automation modules, to avoid permissions issues.

Legacy Contributor

To get the URL, log into the Mongoose Application via a web browser. When you click/hover over Form -> Open... in the menu bar, look at the status bar in your web browser. It will show the server farm you are connecting to.

The tenant is embedded in the token you receive with the /token endpoint. In the /token endpoint call, you are specifying the Mongoose Application configuration in the tenant that your are connecting to.

You re-specify that configuration with each call, by way of the X-Infor-MongooseConfig request parameter.

If you change configurations, you have to re-get the token before you make the call to the new configuration.

The configuration has to be specified exactly as it is shown in the drop-down box when you log into the application.

Legacy Contributor

Thanks Tim. I wondered how to get this.

tdickens

Thank you to everyone who helped me with this. I was able to get a token and do a Load Collection and also an Insert using the Mongoose REST APIs. I wouldn't have been able to do that without the help I received on this forum. I really appreciate it.

Copyright © 2025 Infor. All rights reserved.