Get Data From Json and Save Into a Variable

Question

Hi All,

I was able to get the data from external System with a!httpQuery and using a!fromJson() I could able to get the data in the below format.
[{"EMP_ID":1,"EMP_NAME":"ABC","ORG":"VPC","MANAGER_CONTACT_NAME":"My Name"}],
So could someone help me how to save this single text value, into a CDT or basically what I want is the Values for those respective properties.
TIA :)

Dave Lewis · Answer

First, create interface, just leave blank for now. 
 Make a!localVariables, make a local variable to save JSON data. Use the fromJson() to convert a JSON document you downloaded into a dictionary. 
 Now, create a text field, set it to read-only, set the value to the localVariable you made, local!jsonStorage or whatever you named it. Now your interface should be displaying the whole dictionary that came from your JSON. 
 Make a new text field, set it readOnly and set it's value to index(local!jsonStorage, "fieldOne", ""), now see output of that. Since you're starting out, it's going to be little by little, but soon you should have all the fields displaying the data from the JSON exactly how you want. 
 Then try to figure out how to get the users to edit them, then possibly cast that dictionary as a CDT. Maybe even use toJSON() to output json depending on your