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

Name Description
JSON <%=@answers['Employees']%>
Path requesters/phone
Unique 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.


Related Handlers

Name Generator
Generates a simple name like: frosty-tree-15.
Utility CSV To XML
Converts a CSV string to an XML string
Utility JSON To CSV
This handler converts a JSON string into a CSV string.
Utility JSON To HTML
This handler converts a JSON string into a HTML table.
Utility JSON to Results
Converts JSON to XML result.
Utility JSON To XML
This handler converts a JSON string into an XML string.
Utility Random Password Generate
Generates a human readable random password - intended to be immediately changed once used.