Convert API Json Reponse (Dynamic) into key value pair

[Priyankaa]

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.

[Jane]

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.

[Priyankaa]

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.

[Jane]

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.

[Priyankaa]

Hi Seema,

Thank you for your valuable response. Please check below error screenshot as received JSON response is dynamic and couldn’t fix format/response for each row.

Kindly let me know the solution for the same.

Regards,
Priyanka V. Chaudhari