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

[Richard Hine]

Shivani,

Ankur is partly correct, by default the endpoint expects a JSON payload not XML, so this would be the source of your problem currently.

To fix this you can either

• Tell your middleware team that the endpoint expects JSON not XML and they may be able to make a configuration change to handle this for you

or

• Ask them to add a Content-Type header with value 'application/xml' to the request and this should sort the issue.

Hope this helps,

Richard

[Shivani29]

Thanks @Ankur Bawiskar and @Richard Hine :

Will talk to the middleware team and let you  guys know the status.

Regards,
Shivani

[Shivani29 · Accepted solution]

Thanks everyone for helping. The issue was with number of sql queries which can run at a time in servicenow. Increased the number and it started working.

Regards,
Shivani

[Ankur Bawiskar]

Can you share what exact configuration change was done?

[Shivani29]

Hi Ankur,

In sysrule_quota table, i increased the maximum SQL queries run at a time. Below is the snapshot for the same:

Regards,
Shivani