topic Looping through parsed JSON to get key and value in Workato Pros Discussion Board

Looping through parsed JSON to get key and value

moxiego — Wed, 20 Sep 2023 13:30:41 GMT

I have a GET command that returns a JSON response.The next step is Parse JSON. From there, I want to loop through the "key" and "value". The Parsed JSON turns the fields into datapills, which I can pull the value, but I can't get the "key" (label). Is this possible?

Re: Looping through parsed JSON to get key and value

gary1 — Wed, 20 Sep 2023 16:22:27 GMT

Create a Ruby action and use the following code. Create an input called "obj" and use the object data pill. It will output an array of objects with key/value keys that are easier to loop through in a traditional Workato loop.

Ruby code:

obj = input["obj"] array = [] input["obj"].keys.each { | k | array.push({"key": k, "value": obj[k]}) } {output: array}

Example input object:

{"one": 1, "two": 2, "three": 3}

Output:

{ "output": { "output": [ { "key": "one", "value": 1 }, { "key": "two", "value": 2 }, { "key": "three", "value": 3 } ] } }

Re: Looping through parsed JSON to get key and value

moxiego — Thu, 21 Sep 2023 13:53:37 GMT

Thank you! I was able to turn it into python code that worked for me.

def main(input):
data = input.get("jsondata", [])
output_list = []

for item in data:
custom_fields = item.get("custom_fields", {})
for key, value in custom_fields.items():
output_list.append({"key": key, "value": value})

return {'output_q' : output_list}

Re: Looping through parsed JSON to get key and value

dcornwell — Thu, 21 Sep 2023 14:04:06 GMT

This is such a useful and common requirement that I really hope Workato can build it into a standard function. I had to ask for help to do this with Ruby years ago. Surely many customers come across this requirement/shortfall in functionality all the time.

Re: Looping through parsed JSON to get key and value

gary1 — Thu, 21 Sep 2023 15:00:31 GMT

It's a tough choice between this or fixing the "triple click list" bug!

Re: Looping through parsed JSON to get key and value

Prachi_chakke — Thu, 29 Feb 2024 03:45:24 GMT

would mind to answer how can I map these key value to data model?

Re: Looping through parsed JSON to get key and value

moxiego — Fri, 01 Mar 2024 15:46:19 GMT

Step 10: In the above code, we get the output_q as the key/value list.

Step 11: "for each item in output_q (prev step) repeat the following steps"

Then I update previously declared variables

Primary Supervisor: KeyStep11.match?(/primary_supervisor/).present?? ValueStep11 : skip