Hello Team,
Kindly help me on below problem statement of AE PS use case.
How can I parse or convert API Json response (dynamic) into the key value pair for further process?
I used Advanced Rest Client plugin to get the API json response which is dynamic.
Hi! Priyanka,
I will showcase an example. Here is a partial snapshot of a workflow to get the list incidents from ServiceNow.
In the Advanced REST Client the response body is captured in the field - Result.
You can capture the keys in fields using the JSON Input step as seen below.
On the file tab, I have selected Result as the field containing JSON data.
On the Fields tab I have mentioned the keys to fetch by proving the key path and a field name to store the key values.
Thank you @Jane for the answer.
I want to capture 110 fields/key approximately and json response is also dynamic, I couldn’t use the static/fixed path to get the key.
Kindly suggest me, if you know the another approach for it.
Hi! Priyanka,
If your JSON is dynamic, you can check the - Ignore Missing Path option as seen below, so that you do not get any errors.
|
