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

NameDescription
JSONThe JSON structure to be parsed
PathThe Path to the data that should be returned
UniqueIf set to Yes, the list of items with contain no duplicates

Sample Configuration

NameDescription
JSON<%=@answers['Employees']%>
Pathrequesters/phone
UniqueYes

Results

NameSample Result
ItemsAn XML String that was parsed from the given JSON.

Changelog

No Changelog Available.