Looping through parsed JSON to get key and value

[moxiego]

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?

[gary1 · Accepted solution]

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
			}
		]
	}
}

[Prachi_chakke]

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

[moxiego]

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