Back to Utilities Integrations
Handler · Version 1

Utility Json Parse

Download GitHub

About

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: 612-555-1212 301-555-1212

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: delete delete

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: delete

Parameters
Name Description Sample
JSON The JSON structure to be parsed <%=@answers['Employees']%>
Path The Path to the data that should be returned requesters/phone
Unique If set to Yes, the list of items with contain no duplicates Yes
Results
Name Description
Items An XML String that was parsed from the given JSON.
Changelog

Utility Json Parse (2011-08-18)

  • Initial version. See README for details.
Download GitHub

On This Page

Looking for a workflow engine? Learn more about the Kinetic Data Enterprise Workflow Platform. Check it out
Return to Top