Rest API receiving data but not sending success back

[Shivani29]

Hi All,

I provided rest api explorer url and third party is sending data to middleware and middleware sending the data to servicenow. I am receiving the data in ServiceNow but middleware is not receiving any success from my side. It is shaowing waiting at middleware end so it is trying again after 10 min and in servicenow we are getting multiple entries for same data. They are getting error: Server returned code: 500. Attached is the snapshot for the error and information which middleware received.

Kindly help!

Regards,
Shivani

[Ankur Bawiskar]

Hi,

Did you try to test the endpoint via Postman?

Regards
Ankur

[Ankur Bawiskar]

Hi,

are they sending the data in JSON format?

Does the API user have create access on that table?

what type of authentication you are using?

If it works fine with the api user, correct credentials, correct JSON request body from Postman then it should work fine from their middle ware as well

Regards
Ankur

[Shivani29]

Hi Ankur,

I am getting data correctly in ServiceNow from middleware. The problem is middleware is not receiving success from ServiceNow.

Regards,
Shivani

[Ankur Bawiskar]

Hi,

So did you test it out in Postman by sending data to ServiceNow

what response you get?

Regards
Ankur

[Vijay Balotia1]

Hi,

From the provided error screen sort I can understand that middleware is hitting the api provided by you but seems that data is not inserted in u_new_join_fieldglass table. Check write access for this table and add that role in Integration User which you are using for integration or can try by deactivating write ACL on that table. Also recommending you to check any data dictionary is created on that table to enforce mandatory field.

Regards,

Vj