Skip to content

Instantly share code, notes, and snippets.

@jquerygeek

jquerygeek/index.html

Created March 13, 2019 20:59
Show Gist options
  • Save jquerygeek/e69a2d80ad79acf99b107e9bafc9aca8 to your computer and use it in GitHub Desktop.
Save jquerygeek/e69a2d80ad79acf99b107e9bafc9aca8 to your computer and use it in GitHub Desktop.
Download ZIP
JS Bin // source https://jsbin.com/pihapozeyo
Raw
index.html
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width">
<title>JS Bin</title>
</head>
<body>
<script id="jsbin-javascript">
var jsonStr = "{ \"Data\" : [ { \"Customer\" : [ { \"Id\" : \"0011b00000cuqdsAAA\", \"Name\" : \"Streamline\", \"Email__c\" : \"\", \"Customer_Viewed__c\" : \"\", \"Phone\" : \"\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-11T11:41:04.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-11T11:41:04.000Z\" }, { \"Id\" : \"0011b00000cvGwXAAU\", \"Name\" : \"Down Hill Marvel Ltd\", \"Email__c\" : \"tgaskins@asag.net\", \"Customer_Viewed__c\" : \"\", \"Phone\" : \"3333232232\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T06:39:17.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-12T06:39:17.000Z\" }, { \"Id\" : \"0011b00000cvHDDAA2\", \"Name\" : \"Allen Samuels Direct\", \"Email__c\" : \"tgaskins@asag.net\", \"Customer_Viewed__c\" : \"\", \"Phone\" : \"\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T06:56:08.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-12T06:57:37.000Z\" }, { \"Id\" : \"0011b00000cvGwhAAE\", \"Name\" : \"Direct\", \"Email__c\" : \"tgaskins@asag.net\", \"Customer_Viewed__c\" : \"\", \"Phone\" : \"\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T06:39:18.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-12T06:39:18.000Z\" }, { \"Id\" : \"0011b00000cvGwiAAE\", \"Name\" : \"Allen\", \"Email__c\" : \"tgaskins@asag.net\", \"Customer_Viewed__c\" : \"\", \"Phone\" : \"\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T06:39:18.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-12T06:39:18.000Z\" }, { \"Id\" : \"0011b00000cvGwcAAE\", \"Name\" : \"Samuels Direct\", \"Email__c\" : \"info@dhm.io\", \"Customer_Viewed__c\" : \"downhill.marvel@gmail.com\", \"Phone\" : \"\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T06:39:17.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-12T06:40:15.000Z\" }, { \"Id\" : \"0011b00000cvGwdAAE\", \"Name\" : \"Samuels\", \"Email__c\" : \"tgaskins@asag.net\", \"Customer_Viewed__c\" : \"\", \"Phone\" : \"\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T06:39:19.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-12T06:39:19.000Z\" }, { \"Id\" : \"0011b00000cvGweAAE\", \"Name\" : \"Samuels Direct\", \"Email__c\" : \"tgaskins@asag.net\", \"Customer_Viewed__c\" : \"\", \"Phone\" : \"\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T06:39:21.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-12T06:39:21.000Z\" } ], \"Employee\" : [ { \"Id\" : \"0031b00000UZbhiAAD\", \"AccountId\" : \"0011b00000cuqdsAAA\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T08:07:26.000Z\", \"FirstName\" : \"Faizul\", \"LastName\" : \"Employee\", \"LastModifiedDate\" : \"2019-03-12T08:07:26.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Phone\" : \"\", \"Password__c\" : \"1111\", \"Pin__c\" : \"\" }, { \"Id\" : \"0031b00000UZbh2AAD\", \"AccountId\" : \"0011b00000cuqdsAAA\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T08:06:01.000Z\", \"FirstName\" : \"Antonio\", \"LastName\" : \"Alvarado\", \"LastModifiedDate\" : \"2019-03-12T08:06:01.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Phone\" : \"\", \"Password__c\" : \"1111\", \"Pin__c\" : \"\" }, { \"Id\" : \"0031b00000UZbfvAAD\", \"AccountId\" : \"0011b00000cuqdsAAA\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T08:05:11.000Z\", \"FirstName\" : \"Miguel\", \"LastName\" : \"Alonzo\", \"LastModifiedDate\" : \"2019-03-12T08:05:11.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Phone\" : \"\", \"Password__c\" : \"1111\", \"Pin__c\" : \"\" }, { \"Id\" : \"0031b00000UZbhTAAT\", \"AccountId\" : \"0011b00000cuqdsAAA\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T08:06:41.000Z\", \"FirstName\" : \"Marina\", \"LastName\" : \"Alvarado\", \"LastModifiedDate\" : \"2019-03-12T08:06:41.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Phone\" : \"\", \"Password__c\" : \"1111\", \"Pin__c\" : \"\" } ], \"Customer Contacts\" : [ { \"Id\" : \"0031b00000UZbm9AAD\", \"AccountId\" : \"0011b00000cvGwcAAE\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T08:32:00.000Z\", \"FirstName\" : \"Jane\", \"LastName\" : \"long\", \"LastModifiedDate\" : \"2019-03-12T08:32:00.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Phone\" : \"22123123312\", \"MailingStreet\" : \"Address 1,Address 2\", \"MailingCity\" : \"New City\", \"MailingState\" : \"Texas\", \"MailingPostalCode\" : \"75101\", \"MailingCountry\" : \"USA\" }, { \"Id\" : \"0031b00000UZbigAAD\", \"AccountId\" : \"0011b00000cvGwXAAU\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T08:20:06.000Z\", \"FirstName\" : \"John\", \"LastName\" : \"Doe\", \"LastModifiedDate\" : \"2019-03-12T08:20:06.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Phone\" : \"22123123312\", \"MailingStreet\" : \"Address 1,Address 2\", \"MailingCity\" : \"New City\", \"MailingState\" : \"Texas\", \"MailingPostalCode\" : \"75101\", \"MailingCountry\" : \"USA\" }, { \"Id\" : \"0031b00000UZbjFAAT\", \"AccountId\" : \"0011b00000cvGwXAAU\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T08:24:58.000Z\", \"FirstName\" : \"David\", \"LastName\" : \"Lui\", \"LastModifiedDate\" : \"2019-03-12T08:24:58.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Phone\" : \"22123123312\", \"MailingStreet\" : \"Address 1,Address 2\", \"MailingCity\" : \"New City\", \"MailingState\" : \"Texas\", \"MailingPostalCode\" : \"75101\", \"MailingCountry\" : \"USA\" } ], \"Plan Services\" : [ { \"Id\" : \"a0A1b000000m6xZEAQ\", \"Name\" : \"PDR\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:14:16.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:14:16.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 4.00, \"Cost__c \" : 0.00, \"Plan_Service__c \" : \"a091b000004NbcrAAC\" }, { \"Id\" : \"a0A1b000000m6xeEAA\", \"Name\" : \"Dealer Warp Package - Paint\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:20:27.000Z\", \"Service_Type__c \" : \"Bundle\", \"LastModifiedDate\" : \"2019-03-12T07:58:01.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 20.00, \"Cost__c \" : 15.00, \"Plan_Service__c \" : \"a091b000004NbcwAAC\" }, { \"Id\" : \"a0A1b000000m6xPEAQ\", \"Name\" : \"Dealer Warp Package - Car Wash\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:14:15.000Z\", \"Service_Type__c \" : \"Bundle\", \"LastModifiedDate\" : \"2019-03-12T07:57:56.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 28.00, \"Cost__c \" : 20.00, \"Plan_Service__c \" : \"a091b000004NbcwAAC\" }, { \"Id\" : \"a0A1b000000m6xQEAQ\", \"Name\" : \"Courtesy Service wash\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:14:16.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:14:16.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 2.00, \"Cost__c \" : 0.00, \"Plan_Service__c \" : \"a091b000004Nbd1AAC\" }, { \"Id\" : \"a0A1b000000m6xUEAQ\", \"Name\" : \"Lot Wash\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:14:16.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:14:16.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 3.00, \"Cost__c \" : 0.00, \"Plan_Service__c \" : \"a091b000004NbcmAAC\" }, { \"Id\" : \"a0A1b000000m6xVEAQ\", \"Name\" : \"Paint\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:14:17.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:14:17.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 5.00, \"Cost__c \" : 0.00, \"Plan_Service__c \" : \"a091b000004Nbd6AAC\" }, { \"Id\" : \"a0A1b000000m6xWEAQ\", \"Name\" : \"Used Car\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:14:17.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:14:17.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 8.00, \"Cost__c \" : 0.00, \"Plan_Service__c \" : \"a091b000004NbdBAAS\" }, { \"Id\" : \"a0A1b000000m6pnEAA\", \"Name\" : \"a0A1b000000m6pn\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-11T11:48:34.000Z\", \"Service_Type__c \" : \"Bundle\", \"LastModifiedDate\" : \"2019-03-11T11:48:34.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 0.00, \"Cost__c \" : 0.00, \"Plan_Service__c \" : \"a091b000004Mk12AAC\" } ], \"Services\" : [ { \"Id\" : \"a091b000004NbdBAAS\", \"Name\" : \"Used Car Plan Service\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:11:42.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:11:42.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 8.00, \"Cost__c \" : 0.00, \"Account__c \" : \"0011b00000cvHDDAA2\" }, { \"Id\" : \"a091b000004NbcwAAC\", \"Name\" : \"Dealer Warp Package Plan Service\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:10:08.000Z\", \"Service_Type__c \" : \"Bundle\", \"LastModifiedDate\" : \"2019-03-12T07:58:01.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 48.00, \"Cost__c \" : 35.00, \"Account__c \" : \"0011b00000cvHDDAA2\" }, { \"Id\" : \"a091b000004Nbd6AAC\", \"Name\" : \"Paint Plan Service\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:11:16.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:11:16.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 5.00, \"Cost__c \" : 0.00, \"Account__c \" : \"0011b00000cvHDDAA2\" }, { \"Id\" : \"a091b000004NbcrAAC\", \"Name\" : \"PDR Plan Service\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:04:07.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:04:07.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 4.00, \"Cost__c \" : 0.00, \"Account__c \" : \"0011b00000cvHDDAA2\" }, { \"Id\" : \"a091b000004Nbd1AAC\", \"Name\" : \"Courtesy Service wash Plan Service\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:10:41.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:10:41.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 2.00, \"Cost__c \" : 0.00, \"Account__c \" : \"0011b00000cvHDDAA2\" }, { \"Id\" : \"a091b000004NbcmAAC\", \"Name\" : \"Lot wash plan service\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:02:02.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:02:02.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 3.00, \"Cost__c \" : 0.00, \"Account__c \" : \"0011b00000cvHDDAA2\" }, { \"Id\" : \"a091b000004Mk12AAC\", \"Name\" : \"Standard Recondition\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-11T11:47:20.000Z\", \"Service_Type__c \" : \"Bundle\", \"LastModifiedDate\" : \"2019-03-11T11:47:20.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 250.00, \"Cost__c \" : 0.00, \"Account__c \" : \"0011b00000cuqdsAAA\" } ] } ]}";
var jsonObj = JSON.parse(jsonStr.replace(/\s/g, ''));
var customerArr = jsonObj.Data[0].Customer;
// iterate over customer items
customerArr.forEach(function(customer, index) {
// console.log(customer.Email__c);
console.log(customer['Email__c']);
// Now build the Db quesry string with data set from customer and run it
})
var serviceArr = jsonObj.Data[0].Services;
// iterate over service items
serviceArr.forEach(function(service, index) {
// console.log(service.Service_Type__c);
console.log(service['Service_Type__c']);
console.log(service['Price__c'])
// Now build the Db quesry string with data set from service and run it
})
</script>
<script id="jsbin-source-javascript" type="text/javascript">var jsonStr = "{ \"Data\" : [ { \"Customer\" : [ { \"Id\" : \"0011b00000cuqdsAAA\", \"Name\" : \"Streamline\", \"Email__c\" : \"\", \"Customer_Viewed__c\" : \"\", \"Phone\" : \"\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-11T11:41:04.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-11T11:41:04.000Z\" }, { \"Id\" : \"0011b00000cvGwXAAU\", \"Name\" : \"Down Hill Marvel Ltd\", \"Email__c\" : \"tgaskins@asag.net\", \"Customer_Viewed__c\" : \"\", \"Phone\" : \"3333232232\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T06:39:17.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-12T06:39:17.000Z\" }, { \"Id\" : \"0011b00000cvHDDAA2\", \"Name\" : \"Allen Samuels Direct\", \"Email__c\" : \"tgaskins@asag.net\", \"Customer_Viewed__c\" : \"\", \"Phone\" : \"\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T06:56:08.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-12T06:57:37.000Z\" }, { \"Id\" : \"0011b00000cvGwhAAE\", \"Name\" : \"Direct\", \"Email__c\" : \"tgaskins@asag.net\", \"Customer_Viewed__c\" : \"\", \"Phone\" : \"\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T06:39:18.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-12T06:39:18.000Z\" }, { \"Id\" : \"0011b00000cvGwiAAE\", \"Name\" : \"Allen\", \"Email__c\" : \"tgaskins@asag.net\", \"Customer_Viewed__c\" : \"\", \"Phone\" : \"\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T06:39:18.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-12T06:39:18.000Z\" }, { \"Id\" : \"0011b00000cvGwcAAE\", \"Name\" : \"Samuels Direct\", \"Email__c\" : \"info@dhm.io\", \"Customer_Viewed__c\" : \"downhill.marvel@gmail.com\", \"Phone\" : \"\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T06:39:17.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-12T06:40:15.000Z\" }, { \"Id\" : \"0011b00000cvGwdAAE\", \"Name\" : \"Samuels\", \"Email__c\" : \"tgaskins@asag.net\", \"Customer_Viewed__c\" : \"\", \"Phone\" : \"\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T06:39:19.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-12T06:39:19.000Z\" }, { \"Id\" : \"0011b00000cvGweAAE\", \"Name\" : \"Samuels Direct\", \"Email__c\" : \"tgaskins@asag.net\", \"Customer_Viewed__c\" : \"\", \"Phone\" : \"\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T06:39:21.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-12T06:39:21.000Z\" } ], \"Employee\" : [ { \"Id\" : \"0031b00000UZbhiAAD\", \"AccountId\" : \"0011b00000cuqdsAAA\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T08:07:26.000Z\", \"FirstName\" : \"Faizul\", \"LastName\" : \"Employee\", \"LastModifiedDate\" : \"2019-03-12T08:07:26.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Phone\" : \"\", \"Password__c\" : \"1111\", \"Pin__c\" : \"\" }, { \"Id\" : \"0031b00000UZbh2AAD\", \"AccountId\" : \"0011b00000cuqdsAAA\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T08:06:01.000Z\", \"FirstName\" : \"Antonio\", \"LastName\" : \"Alvarado\", \"LastModifiedDate\" : \"2019-03-12T08:06:01.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Phone\" : \"\", \"Password__c\" : \"1111\", \"Pin__c\" : \"\" }, { \"Id\" : \"0031b00000UZbfvAAD\", \"AccountId\" : \"0011b00000cuqdsAAA\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T08:05:11.000Z\", \"FirstName\" : \"Miguel\", \"LastName\" : \"Alonzo\", \"LastModifiedDate\" : \"2019-03-12T08:05:11.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Phone\" : \"\", \"Password__c\" : \"1111\", \"Pin__c\" : \"\" }, { \"Id\" : \"0031b00000UZbhTAAT\", \"AccountId\" : \"0011b00000cuqdsAAA\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T08:06:41.000Z\", \"FirstName\" : \"Marina\", \"LastName\" : \"Alvarado\", \"LastModifiedDate\" : \"2019-03-12T08:06:41.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Phone\" : \"\", \"Password__c\" : \"1111\", \"Pin__c\" : \"\" } ], \"Customer Contacts\" : [ { \"Id\" : \"0031b00000UZbm9AAD\", \"AccountId\" : \"0011b00000cvGwcAAE\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T08:32:00.000Z\", \"FirstName\" : \"Jane\", \"LastName\" : \"long\", \"LastModifiedDate\" : \"2019-03-12T08:32:00.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Phone\" : \"22123123312\", \"MailingStreet\" : \"Address 1,Address 2\", \"MailingCity\" : \"New City\", \"MailingState\" : \"Texas\", \"MailingPostalCode\" : \"75101\", \"MailingCountry\" : \"USA\" }, { \"Id\" : \"0031b00000UZbigAAD\", \"AccountId\" : \"0011b00000cvGwXAAU\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T08:20:06.000Z\", \"FirstName\" : \"John\", \"LastName\" : \"Doe\", \"LastModifiedDate\" : \"2019-03-12T08:20:06.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Phone\" : \"22123123312\", \"MailingStreet\" : \"Address 1,Address 2\", \"MailingCity\" : \"New City\", \"MailingState\" : \"Texas\", \"MailingPostalCode\" : \"75101\", \"MailingCountry\" : \"USA\" }, { \"Id\" : \"0031b00000UZbjFAAT\", \"AccountId\" : \"0011b00000cvGwXAAU\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T08:24:58.000Z\", \"FirstName\" : \"David\", \"LastName\" : \"Lui\", \"LastModifiedDate\" : \"2019-03-12T08:24:58.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Phone\" : \"22123123312\", \"MailingStreet\" : \"Address 1,Address 2\", \"MailingCity\" : \"New City\", \"MailingState\" : \"Texas\", \"MailingPostalCode\" : \"75101\", \"MailingCountry\" : \"USA\" } ], \"Plan Services\" : [ { \"Id\" : \"a0A1b000000m6xZEAQ\", \"Name\" : \"PDR\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:14:16.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:14:16.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 4.00, \"Cost__c \" : 0.00, \"Plan_Service__c \" : \"a091b000004NbcrAAC\" }, { \"Id\" : \"a0A1b000000m6xeEAA\", \"Name\" : \"Dealer Warp Package - Paint\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:20:27.000Z\", \"Service_Type__c \" : \"Bundle\", \"LastModifiedDate\" : \"2019-03-12T07:58:01.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 20.00, \"Cost__c \" : 15.00, \"Plan_Service__c \" : \"a091b000004NbcwAAC\" }, { \"Id\" : \"a0A1b000000m6xPEAQ\", \"Name\" : \"Dealer Warp Package - Car Wash\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:14:15.000Z\", \"Service_Type__c \" : \"Bundle\", \"LastModifiedDate\" : \"2019-03-12T07:57:56.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 28.00, \"Cost__c \" : 20.00, \"Plan_Service__c \" : \"a091b000004NbcwAAC\" }, { \"Id\" : \"a0A1b000000m6xQEAQ\", \"Name\" : \"Courtesy Service wash\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:14:16.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:14:16.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 2.00, \"Cost__c \" : 0.00, \"Plan_Service__c \" : \"a091b000004Nbd1AAC\" }, { \"Id\" : \"a0A1b000000m6xUEAQ\", \"Name\" : \"Lot Wash\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:14:16.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:14:16.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 3.00, \"Cost__c \" : 0.00, \"Plan_Service__c \" : \"a091b000004NbcmAAC\" }, { \"Id\" : \"a0A1b000000m6xVEAQ\", \"Name\" : \"Paint\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:14:17.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:14:17.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 5.00, \"Cost__c \" : 0.00, \"Plan_Service__c \" : \"a091b000004Nbd6AAC\" }, { \"Id\" : \"a0A1b000000m6xWEAQ\", \"Name\" : \"Used Car\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:14:17.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:14:17.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 8.00, \"Cost__c \" : 0.00, \"Plan_Service__c \" : \"a091b000004NbdBAAS\" }, { \"Id\" : \"a0A1b000000m6pnEAA\", \"Name\" : \"a0A1b000000m6pn\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-11T11:48:34.000Z\", \"Service_Type__c \" : \"Bundle\", \"LastModifiedDate\" : \"2019-03-11T11:48:34.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 0.00, \"Cost__c \" : 0.00, \"Plan_Service__c \" : \"a091b000004Mk12AAC\" } ], \"Services\" : [ { \"Id\" : \"a091b000004NbdBAAS\", \"Name\" : \"Used Car Plan Service\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:11:42.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:11:42.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 8.00, \"Cost__c \" : 0.00, \"Account__c \" : \"0011b00000cvHDDAA2\" }, { \"Id\" : \"a091b000004NbcwAAC\", \"Name\" : \"Dealer Warp Package Plan Service\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:10:08.000Z\", \"Service_Type__c \" : \"Bundle\", \"LastModifiedDate\" : \"2019-03-12T07:58:01.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 48.00, \"Cost__c \" : 35.00, \"Account__c \" : \"0011b00000cvHDDAA2\" }, { \"Id\" : \"a091b000004Nbd6AAC\", \"Name\" : \"Paint Plan Service\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:11:16.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:11:16.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 5.00, \"Cost__c \" : 0.00, \"Account__c \" : \"0011b00000cvHDDAA2\" }, { \"Id\" : \"a091b000004NbcrAAC\", \"Name\" : \"PDR Plan Service\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:04:07.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:04:07.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 4.00, \"Cost__c \" : 0.00, \"Account__c \" : \"0011b00000cvHDDAA2\" }, { \"Id\" : \"a091b000004Nbd1AAC\", \"Name\" : \"Courtesy Service wash Plan Service\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:10:41.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:10:41.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 2.00, \"Cost__c \" : 0.00, \"Account__c \" : \"0011b00000cvHDDAA2\" }, { \"Id\" : \"a091b000004NbcmAAC\", \"Name\" : \"Lot wash plan service\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:02:02.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:02:02.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 3.00, \"Cost__c \" : 0.00, \"Account__c \" : \"0011b00000cvHDDAA2\" }, { \"Id\" : \"a091b000004Mk12AAC\", \"Name\" : \"Standard Recondition\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-11T11:47:20.000Z\", \"Service_Type__c \" : \"Bundle\", \"LastModifiedDate\" : \"2019-03-11T11:47:20.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 250.00, \"Cost__c \" : 0.00, \"Account__c \" : \"0011b00000cuqdsAAA\" } ] } ]}";
var jsonObj = JSON.parse(jsonStr.replace(/\s/g, ''));
var customerArr = jsonObj.Data[0].Customer;
// iterate over customer items
customerArr.forEach(function(customer, index) {
// console.log(customer.Email__c);
console.log(customer['Email__c']);
// Now build the Db quesry string with data set from customer and run it
})
var serviceArr = jsonObj.Data[0].Services;
// iterate over service items
serviceArr.forEach(function(service, index) {
// console.log(service.Service_Type__c);
console.log(service['Service_Type__c']);
console.log(service['Price__c'])
// Now build the Db quesry string with data set from service and run it
})</script></body>
</html>
Raw
jsbin.pihapozeyo.js
var jsonStr = "{ \"Data\" : [ { \"Customer\" : [ { \"Id\" : \"0011b00000cuqdsAAA\", \"Name\" : \"Streamline\", \"Email__c\" : \"\", \"Customer_Viewed__c\" : \"\", \"Phone\" : \"\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-11T11:41:04.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-11T11:41:04.000Z\" }, { \"Id\" : \"0011b00000cvGwXAAU\", \"Name\" : \"Down Hill Marvel Ltd\", \"Email__c\" : \"tgaskins@asag.net\", \"Customer_Viewed__c\" : \"\", \"Phone\" : \"3333232232\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T06:39:17.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-12T06:39:17.000Z\" }, { \"Id\" : \"0011b00000cvHDDAA2\", \"Name\" : \"Allen Samuels Direct\", \"Email__c\" : \"tgaskins@asag.net\", \"Customer_Viewed__c\" : \"\", \"Phone\" : \"\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T06:56:08.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-12T06:57:37.000Z\" }, { \"Id\" : \"0011b00000cvGwhAAE\", \"Name\" : \"Direct\", \"Email__c\" : \"tgaskins@asag.net\", \"Customer_Viewed__c\" : \"\", \"Phone\" : \"\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T06:39:18.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-12T06:39:18.000Z\" }, { \"Id\" : \"0011b00000cvGwiAAE\", \"Name\" : \"Allen\", \"Email__c\" : \"tgaskins@asag.net\", \"Customer_Viewed__c\" : \"\", \"Phone\" : \"\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T06:39:18.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-12T06:39:18.000Z\" }, { \"Id\" : \"0011b00000cvGwcAAE\", \"Name\" : \"Samuels Direct\", \"Email__c\" : \"info@dhm.io\", \"Customer_Viewed__c\" : \"downhill.marvel@gmail.com\", \"Phone\" : \"\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T06:39:17.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-12T06:40:15.000Z\" }, { \"Id\" : \"0011b00000cvGwdAAE\", \"Name\" : \"Samuels\", \"Email__c\" : \"tgaskins@asag.net\", \"Customer_Viewed__c\" : \"\", \"Phone\" : \"\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T06:39:19.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-12T06:39:19.000Z\" }, { \"Id\" : \"0011b00000cvGweAAE\", \"Name\" : \"Samuels Direct\", \"Email__c\" : \"tgaskins@asag.net\", \"Customer_Viewed__c\" : \"\", \"Phone\" : \"\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T06:39:21.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"LastModifiedDate\" : \"2019-03-12T06:39:21.000Z\" } ], \"Employee\" : [ { \"Id\" : \"0031b00000UZbhiAAD\", \"AccountId\" : \"0011b00000cuqdsAAA\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T08:07:26.000Z\", \"FirstName\" : \"Faizul\", \"LastName\" : \"Employee\", \"LastModifiedDate\" : \"2019-03-12T08:07:26.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Phone\" : \"\", \"Password__c\" : \"1111\", \"Pin__c\" : \"\" }, { \"Id\" : \"0031b00000UZbh2AAD\", \"AccountId\" : \"0011b00000cuqdsAAA\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T08:06:01.000Z\", \"FirstName\" : \"Antonio\", \"LastName\" : \"Alvarado\", \"LastModifiedDate\" : \"2019-03-12T08:06:01.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Phone\" : \"\", \"Password__c\" : \"1111\", \"Pin__c\" : \"\" }, { \"Id\" : \"0031b00000UZbfvAAD\", \"AccountId\" : \"0011b00000cuqdsAAA\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T08:05:11.000Z\", \"FirstName\" : \"Miguel\", \"LastName\" : \"Alonzo\", \"LastModifiedDate\" : \"2019-03-12T08:05:11.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Phone\" : \"\", \"Password__c\" : \"1111\", \"Pin__c\" : \"\" }, { \"Id\" : \"0031b00000UZbhTAAT\", \"AccountId\" : \"0011b00000cuqdsAAA\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T08:06:41.000Z\", \"FirstName\" : \"Marina\", \"LastName\" : \"Alvarado\", \"LastModifiedDate\" : \"2019-03-12T08:06:41.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Phone\" : \"\", \"Password__c\" : \"1111\", \"Pin__c\" : \"\" } ], \"Customer Contacts\" : [ { \"Id\" : \"0031b00000UZbm9AAD\", \"AccountId\" : \"0011b00000cvGwcAAE\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T08:32:00.000Z\", \"FirstName\" : \"Jane\", \"LastName\" : \"long\", \"LastModifiedDate\" : \"2019-03-12T08:32:00.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Phone\" : \"22123123312\", \"MailingStreet\" : \"Address 1,Address 2\", \"MailingCity\" : \"New City\", \"MailingState\" : \"Texas\", \"MailingPostalCode\" : \"75101\", \"MailingCountry\" : \"USA\" }, { \"Id\" : \"0031b00000UZbigAAD\", \"AccountId\" : \"0011b00000cvGwXAAU\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T08:20:06.000Z\", \"FirstName\" : \"John\", \"LastName\" : \"Doe\", \"LastModifiedDate\" : \"2019-03-12T08:20:06.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Phone\" : \"22123123312\", \"MailingStreet\" : \"Address 1,Address 2\", \"MailingCity\" : \"New City\", \"MailingState\" : \"Texas\", \"MailingPostalCode\" : \"75101\", \"MailingCountry\" : \"USA\" }, { \"Id\" : \"0031b00000UZbjFAAT\", \"AccountId\" : \"0011b00000cvGwXAAU\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T08:24:58.000Z\", \"FirstName\" : \"David\", \"LastName\" : \"Lui\", \"LastModifiedDate\" : \"2019-03-12T08:24:58.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Phone\" : \"22123123312\", \"MailingStreet\" : \"Address 1,Address 2\", \"MailingCity\" : \"New City\", \"MailingState\" : \"Texas\", \"MailingPostalCode\" : \"75101\", \"MailingCountry\" : \"USA\" } ], \"Plan Services\" : [ { \"Id\" : \"a0A1b000000m6xZEAQ\", \"Name\" : \"PDR\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:14:16.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:14:16.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 4.00, \"Cost__c \" : 0.00, \"Plan_Service__c \" : \"a091b000004NbcrAAC\" }, { \"Id\" : \"a0A1b000000m6xeEAA\", \"Name\" : \"Dealer Warp Package - Paint\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:20:27.000Z\", \"Service_Type__c \" : \"Bundle\", \"LastModifiedDate\" : \"2019-03-12T07:58:01.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 20.00, \"Cost__c \" : 15.00, \"Plan_Service__c \" : \"a091b000004NbcwAAC\" }, { \"Id\" : \"a0A1b000000m6xPEAQ\", \"Name\" : \"Dealer Warp Package - Car Wash\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:14:15.000Z\", \"Service_Type__c \" : \"Bundle\", \"LastModifiedDate\" : \"2019-03-12T07:57:56.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 28.00, \"Cost__c \" : 20.00, \"Plan_Service__c \" : \"a091b000004NbcwAAC\" }, { \"Id\" : \"a0A1b000000m6xQEAQ\", \"Name\" : \"Courtesy Service wash\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:14:16.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:14:16.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 2.00, \"Cost__c \" : 0.00, \"Plan_Service__c \" : \"a091b000004Nbd1AAC\" }, { \"Id\" : \"a0A1b000000m6xUEAQ\", \"Name\" : \"Lot Wash\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:14:16.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:14:16.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 3.00, \"Cost__c \" : 0.00, \"Plan_Service__c \" : \"a091b000004NbcmAAC\" }, { \"Id\" : \"a0A1b000000m6xVEAQ\", \"Name\" : \"Paint\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:14:17.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:14:17.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 5.00, \"Cost__c \" : 0.00, \"Plan_Service__c \" : \"a091b000004Nbd6AAC\" }, { \"Id\" : \"a0A1b000000m6xWEAQ\", \"Name\" : \"Used Car\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:14:17.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:14:17.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 8.00, \"Cost__c \" : 0.00, \"Plan_Service__c \" : \"a091b000004NbdBAAS\" }, { \"Id\" : \"a0A1b000000m6pnEAA\", \"Name\" : \"a0A1b000000m6pn\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-11T11:48:34.000Z\", \"Service_Type__c \" : \"Bundle\", \"LastModifiedDate\" : \"2019-03-11T11:48:34.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 0.00, \"Cost__c \" : 0.00, \"Plan_Service__c \" : \"a091b000004Mk12AAC\" } ], \"Services\" : [ { \"Id\" : \"a091b000004NbdBAAS\", \"Name\" : \"Used Car Plan Service\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:11:42.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:11:42.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 8.00, \"Cost__c \" : 0.00, \"Account__c \" : \"0011b00000cvHDDAA2\" }, { \"Id\" : \"a091b000004NbcwAAC\", \"Name\" : \"Dealer Warp Package Plan Service\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:10:08.000Z\", \"Service_Type__c \" : \"Bundle\", \"LastModifiedDate\" : \"2019-03-12T07:58:01.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 48.00, \"Cost__c \" : 35.00, \"Account__c \" : \"0011b00000cvHDDAA2\" }, { \"Id\" : \"a091b000004Nbd6AAC\", \"Name\" : \"Paint Plan Service\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:11:16.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:11:16.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 5.00, \"Cost__c \" : 0.00, \"Account__c \" : \"0011b00000cvHDDAA2\" }, { \"Id\" : \"a091b000004NbcrAAC\", \"Name\" : \"PDR Plan Service\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:04:07.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:04:07.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 4.00, \"Cost__c \" : 0.00, \"Account__c \" : \"0011b00000cvHDDAA2\" }, { \"Id\" : \"a091b000004Nbd1AAC\", \"Name\" : \"Courtesy Service wash Plan Service\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:10:41.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:10:41.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 2.00, \"Cost__c \" : 0.00, \"Account__c \" : \"0011b00000cvHDDAA2\" }, { \"Id\" : \"a091b000004NbcmAAC\", \"Name\" : \"Lot wash plan service\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-12T07:02:02.000Z\", \"Service_Type__c \" : \"Service\", \"LastModifiedDate\" : \"2019-03-12T07:02:02.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 3.00, \"Cost__c \" : 0.00, \"Account__c \" : \"0011b00000cvHDDAA2\" }, { \"Id\" : \"a091b000004Mk12AAC\", \"Name\" : \"Standard Recondition\", \"CreatedById\" : \"0051U000001eOq8QAE\", \"CreatedDate\" : \"2019-03-11T11:47:20.000Z\", \"Service_Type__c \" : \"Bundle\", \"LastModifiedDate\" : \"2019-03-11T11:47:20.000Z\", \"LastModifiedById\" : \"0051U000001eOq8QAE\", \"Price__c \" : 250.00, \"Cost__c \" : 0.00, \"Account__c \" : \"0011b00000cuqdsAAA\" } ] } ]}";
var jsonObj = JSON.parse(jsonStr.replace(/\s/g, ''));
var customerArr = jsonObj.Data[0].Customer;
// iterate over customer items
customerArr.forEach(function(customer, index) {
// console.log(customer.Email__c);
console.log(customer['Email__c']);
// Now build the Db quesry string with data set from customer and run it
})
var serviceArr = jsonObj.Data[0].Services;
// iterate over service items
serviceArr.forEach(function(service, index) {
// console.log(service.Service_Type__c);
console.log(service['Service_Type__c']);
console.log(service['Price__c'])
// Now build the Db quesry string with data set from service and run it
})
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment