1.  employeeDetail = "{\"response\" : {\"employee\": {\"id\" : \"EMP-001\", \"role\" : \"Developer\"}}}";   
2.  info employeeDetail.getJSON("response").getJSON("employee").getJSON("id");  // returns EMP-001

1.  resp = {"data" : [{"Id":1, "firstname":"John", "lastName":"Day"},  {"Id":2, "firstname":"Patricia","lastname":"Boyle"}]}";
2.  data = resp.getJson("data");
3.  employeeList = data.toJSONList();
4.  idList = Collection();
5.  for each employee in employeeList
6.  {
7.    idList.insert(employee.getJson("Id"));
8.  }
9.  info idList;   //returns 1,2

1. resp={"data":[{"Id":{"mobileID":1001,"laptopID":2002},"firstname":"John","lastName":"Day"},{"Id":{"mobileID":3003,"laptopID":4004},"firstname":"Patricia","lastname":"Boyle"}]};
2.  data=resp.getJson("data");
3.  employeeList=data.toJSONList();
4.  idList=Collection();
5.  for eachemployeeinemployeeList
6.  {
7.      idList.insert(employee.getJson("Id").get("mobileID"));
8.  }
9.  infoidList;   //returns 1001, 3003​​

1. mapVar = {"Product":"Creator","Company":"Zoho"};
2.  boolVal = mapVar.get("creator");   //returns null
3.  newBoolVal=mapVar.get("Product");   //returns "Creator"

1. listVar={"Creator","CRM",{"Projects","Reports"}};
2.  elementValue=listVar.get(2);   //returns {"Projects", "Reports"}

1. resp =zoho.crm.getRecords("Leads");
2. It retrieves records from Zoho CRM in the following LIST format.
3. {
4.    "Owner":{
5.       "name":"Dinesh",
6.       "id":"4504261000000512001",
7.       "email":"dinesh@zylker.com"
8.    },
9.    "Company":"Rangoni Of Florence",
10.    "Email":"christopher-maclead@zylker.com",
11.    "Description":null,
12.    "$currency_symbol":"$",
13.    "Rating":null,
14.    "$review_process":{
15.       "approve":false,
16.       "reject":false,
17.       "resubmit":false
18.    },
19.    "Website":"http://www.zylker.com",
20.    "Twitter":"@zylker",
21.    "Salutation":"Mr.",
22.    "Last_Activity_Time":"2020-06-12T18:05:43+05:30",
23.    "First_Name":"Christopher",
24.    "Full_Name":"Mr. Christopher Maclead (Sample)",
25.    "Lead_Status":"Lost Lead",
26.    "Industry":"Service Provider",
27.    "Record_Image":"b5be64b25cdb3bbca08d2e2ebd46390d2e00641ea87f7d5083a00acd8094cf3a2ed1da5eea5f2f355bdbd506ed82998e0ceb37fb40086177ec0aac5c1b5e6ebf2b8781a945c03a316fc094ba132f7666",
28.    "Modified_By":{
29.       "name":"Dinesh",
30.       "id":"4504261000000512001",
31.       "email":"dinesh@zylker.com"
32.    },
33.    "$review":null,
34.    "$state":"save",
35.    "Skype_ID":"christopher-maclead",
36.    "$converted":false,
37.    "$process_flow":false,
38.    "Phone":"555-555-5555",
39.    "Street":"375 St Rt",
40.    "Zip_Code":"11953",
41.    "id":"4504261000000200722",
42.    "Email_Opt_Out":false,
43.    "$approved":true,
44.    "Designation":"VP Accounting",
45.    "$approval":{
46.       "delegate":false,
47.       "approve":false,
48.       "reject":false,
49.       "resubmit":false
50.    },
51.    "Modified_Time":"2020-05-27T12:49:08+05:30",
52.    "Created_Time":"2020-05-27T12:48:31+05:30",
53.    "$converted_detail":{
54. 
    
55.    },
56.    "$editable":true,
57.    "City":"Middle Island",
58.    "No_of_Employees":null,
59.    "Mobile":"555-555-5555",
60.    "$orchestration":false,
61.    "Last_Name":"Maclead (Sample)",
62.    "$in_merge":false,
63.    "State":"NY",
64.    "Lead_Source":"Cold Call",
65.    "Country":"United States",
66.    "Tag":[
67. 
    
68.    ],
69.    "Created_By":{
70.       "name":"Dinesh Dinesh",
71.       "id":"4504261000000512001",
72.       "email":"dinesh@zylker.com"
73.    },
74.    "Fax":null,
75.    "Annual_Revenue":850000,
76.    "Secondary_Email":null
77. }

1. for each rec in resp 
2.   {
3.    info rec.get("Owner").get("name");
4.   }

Return Type

Syntax

Examples

The below example retrieves the ID of an employee from a JSON.

1.  employeeDetail="{\"response\" : {\"employee\": {\"id\" : \"EMP-001\", \"role\" : \"Developer\"}}}";   
2.  info employeeDetail.getJSON("response").getJSON("employee").getJSON("id");// returns EMP-001

The below example retrieves the IDs of all employees in a form of a Collection from a JSON.

1. resp="{\"data\" : [{\"Id\":1, \"firstname\":\"John\", \"lastName\":\"Day\"},  {\"Id\":2, \"firstname\":\"Patricia\",\"lastname\":\"Boyle\"}]}";
2. employeeList=resp.getJson("data");
3.  idList=Collection();
4.  for each employee in employeeList
5.  {
6.    idList.insert(employee.getJson("Id"));
7.  }
8.  info idList;//returns 1,2

toJSONList

The toJSONList function takes a text JSON array as an argument, and returns it as a list.

Return Type

LIST

Syntax

1. <variable>=<json_text>.toJSONList();

where,

Examples

The example below retrieves a value inside Collection from a JSON.

1.  json_text = "{Name:'Lia Shelton', OrderNo:[343,443,577]}";
2.  orderNo = json_text.getJSON("OrderNo");
3.  info orderNo.toJSONList(); // Returns 343,443,577

The example below retrieves IDs of all employees in the form of a Collection from a JSON.

1.  response = "{\"data\" : [{\"id\":1, \"firstname\":\"John\", \"lastName\":\"Day\"},  {\"id\":2, \"firstname\":\"Patricia\",\"lastname\":\"Boyle\"}]}";
2.  data=response.getJSON("data");
3.  json_list = data.toJSONList();
4.  id_list = List();
5.  for each item in json_list
6.  {
7.     id_list.add(item.getJSON("id"));
8.  }
9.  info id_list;// Returns 1,2

toMap

The toMap function takes a JSON formatted text as an argument, and returns a key-value pair.

Return Type

KEY-VALUE

Syntax

1. <variable>=<json_text>.toMap();

where,

Examples

1.  products = "{company:Zoho, product:Creator}";
2.  info products.toMap(); // Returns the key-value pair {"product":"Creator","company":"Zoho"}

1.  xmlResponse=invokeurl
2.  [
3.      url:"https://www.w3schools.com/xml/cd_catalog.xml"
4.      type:GET
5.  ]; // gets an XML response
6.  info xmlResponse.executexpath("/CATALOG/CD").toXmlList();// converts the elements in the given node into a list