Utility Json Parse Version 1

Below are some examples of JSON input strings and the corresponding XML output generated by this handler.

JSON: { 'parameters' => { 'path' => "requesters/phone", 'unique' => 'Yes', 'json' => '{"requesters":[{"action":"delete","fname":"Allen Allbrook","lname":"Allen Allbrook","phone":"612-555-1212","startdate":"Start Date here","title":"Title here","manager":"Manager here","dept":"Dept here","location":"Location here","corpid":"Allen","sysa":"SYSA here"},{"action":"delete","fname":"Kathy Villani","lname":"Kathy Villani","phone":"301-555-1212","startdate":"Start Date here","title":"Title here","manager":"Manager here","dept":"Dept here","location":"Location here","corpid":"Kathy","sysa":"SYSA here"}]}' } }

Parsed Path's XML: <items> <item>612-555-1212</item> <item>301-555-1212</item> </items>

JSON: { 'parameters' => { 'path' => "requesters/action", 'unique' => 'No', 'json' => '{"requesters":[{"action":"delete","fname":"Allen Allbrook","lname":"Allen Allbrook","phone":"612-555-1212","startdate":"Start Date here","title":"Title here","manager":"Manager here","dept":"Dept here","location":"Location here","corpid":"Allen","sysa":"SYSA here"},{"action":"delete","fname":"Kathy Villani","lname":"Kathy Villani","phone":"301-555-1212","startdate":"Start Date here","title":"Title here","manager":"Manager here","dept":"Dept here","location":"Location here","corpid":"Kathy","sysa":"SYSA here"}]}' } }

Parsed Path's XML: <items> <item>delete</item> <item>delete</item> </items>

JSON: { 'parameters' => { 'path' => "requesters/action", 'unique' => 'Yes', 'json' => '{"requesters":[{"action":"delete","fname":"Allen Allbrook","lname":"Allen Allbrook","phone":"612-555-1212","startdate":"Start Date here","title":"Title here","manager":"Manager here","dept":"Dept here","location":"Location here","corpid":"Allen","sysa":"SYSA here"},{"action":"delete","fname":"Kathy Villani","lname":"Kathy Villani","phone":"301-555-1212","startdate":"Start Date here","title":"Title here","manager":"Manager here","dept":"Dept here","location":"Location here","corpid":"Kathy","sysa":"SYSA here"}]}' } }

Parsed Path's XML: <items> <item>delete</item> </items>

Parameters

Name	Description
JSON	The JSON structure to be parsed
Path	The Path to the data that should be returned
Unique	If set to Yes, the list of items with contain no duplicates

Sample Configration

Name	Description
JSON	<%=@answers['Employees']%>
Path	requesters/phone
Unique	Yes

Results

Name	Description
Items	An XML String that was parsed from the given JSON.

Looking for a workflow engine?

Learn more about the Kinetic Data Enterprise Workflow Platform

Check it out