Obtaining response from JSON Post command
Hi
I have a pipeline which takes data from a SQL select command and posts to a Service Now API to create a task. Service Now responds with the ID’s of the tasks which I want to post back to the SQ...
Forum Discussion
Super thank very much. That fixed it!
The data is returned in the following format;
"response": {statusLine:{, ...}, entity:{"result":{"status":"success","message":"Requested Item created: RITM1234569","record":"RITM1234569","sysid":"fb7f51d1dbaaaaaaa"}}, header...}
"original": {AutomationId:571, VersionNumber:2, Name:Get My Account, ShortDescription:Your account needs to be updated, SubmittedDate:{, ...}, url:Testurl2, type:Bot, Author:sveluswarm002, Inci...}
{response:{, ...}, original:{, ...}}
{response:{, ...}, original:{, ...}}
In order to extract the Record and sysid in mapper I use the following:
Record = $response.entity.slice($response.entity.search("record")+9,$response.entity.search("record")+20)
Sysid = $response.entity.slice($response.entity.search("sysid")+9,$response.entity.search("}}")-1)
Is that the best way to extract the data from the string?
Thanks for all your help today!
Hello @peter
You can use JSON Path to get the Record and sysid in the mapper. Write the path to the sysid location, try this in the mapper jsonPath($, “$entity.result.sysid”).
Best Regards
Dimche Saveski
