Request Succeeds However No Data is Inserted

Rebecca Cinnamond

Hello,

I have been working on integrating an external application with Infor Syteline. I created a custom API to pull data from the external application as a JSON and I am passing it to the infor/CSI/IDORequestService/ido/update/{ido} endpoint.

I have added my API as an authorised application, and I am able to retrieve authentication tokens successfully. When testing the application in postman, I received a success message however the refresh items are null.

 I am also seeing successes in the Infor ION monitoring. Despite this, data is not entered into the IDO tables. When I test the endpoint through ION it is successful.

Any suggestions or things to check would be much appreciated. Thanks.

Rebecca Cinnamond

I have now solved this issue. This primary table in the IDO was a custom table I had created. I had added a primary key to the table in the "sql tables" form and this was preventing the insert. After removing the PK, insert was successful.