In celigo , From Pitney Bows provide the data in XML format .We need to convert this data to JSON format to store NetSuite. If HTTP Response like : <response><products> We store “response/products ” in the ‘Path to records in HTTP response body’ of Non Standard API response patterns tab. Select XML in the ‘Override… Continue reading Convert XML data of HTTP response to JSON format in Celigo
Tag: xml
Code for replacing special characters in an URL while passing the URL to an XML file.
URL may contain special characters like &, coma, etc but some special characters will not support on XML. the below code can be used for replacing special characters in the URL.
Extract data from XML body
Solution Below given a sample XML body From this, we can extract data using the below sample code var fileContent = fileObj.getContents(); //if xml data is in file //Parse XML to a variable var xmlObj = xmlMod.Parser.fromString({ text: fileContent }); //Getting values from 945 XML file //Traverse to each node var orderheader = xmlMod.XPath.select ({… Continue reading Extract data from XML body
Convert XML to JSON in Netsuite
This code will help us to convert XML files to JSON. Using this script snippet You can easily convert XML data to JSON format. This will apply in SOAP-based integration(XML based response converting to JSON)