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

Sample Configuration

Results

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 JSON

This handler converts a CSV string into a JSON string.

Utility CSV To XML

Converts a CSV string to an XML string

Utility Determine Next Occurrence

This handler determines the next occurence based on a provided start time and other recurrence information

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.