JSFiddle - React, Tailwind, and code Playground

by houssamk

HTML

<div id="test_payload">
</div>

JavaScript

// var payload = mc.getPayloadJSON;  
  var payload = {"Assets":{"Asset":[{"Id":"AAFOqvAEQAABNUHAAM","OrderNo":"1534494","PurchaseOrderNo":"4500348118","ItemNo":"5890-47ZC-00A0","SerialNo":"X012GW02A0065","AccountCode":"4588933","PtoModelNo":"SRS-LYNC-M-DUAL","ShippedDate":"2015-06-05-06:00","WarrantyEndDate":null,"OrderedQuantity":"1","OrderDate":"2015-05-28-06:00"},{"Id":"AAFOqvAEQAABNUHAAN","OrderNo":"1534494","PurchaseOrderNo":"4500348118","ItemNo":"5890-47ZC-00A0","SerialNo":"X012GW14A0044","AccountCode":"4588933","PtoModelNo":"SRS-LYNC-M-DUAL","ShippedDate":"2015-06-05-06:00","WarrantyEndDate":null,"OrderedQuantity":"1","OrderDate":"2015-05-28-06:00"}]}}


// 2018-01-15-07:00	
		//define the start and end -- PtoModelNo
		var soqlQueryStart = "SELECT Id,ProductCode FROM Product2 WHERE ProductCode IN (";
		var soqlQueryEnd = ") and Product_Type__c = 'Finshed Good'" ;
    // define the variable which we use to build the IN clause
    var soqlQueryClause = "";
   
    payload.Assets.Asset.forEach(function(el, idx){
    	soqlQueryClause += "'" + el.PtoModelNo + "'";
     	if (idx < payload.Assets.Asset.length-1)
      	soqlQueryClause += ",";
    });
    var soqlQuery = soqlQueryStart + soqlQueryClause + soqlQueryEnd;

    $('#test_payload').text(soqlQuery);