JSON to Infotable

Here are the two links that might be helpful:

• Convert JSON to an InfoTable
• Convert XML into an InfoTable or DataTable

You might also like to try out this extension from the Marketplace which will translate JSON objects into InfoTables:

https://marketplace.thingworx.com/tools/Parsley_Extension

There is also another way you can do this purely within a JavaScript service if you have a datashape and you have an array of objects that matches that datashape. Here is how you can create a JSON representation of an InfoTable and then use the FromJSON snippet to transform it into a native InfoTable type:

//How to create an infotable from pure JSON
//create the JSON object to represent your infotable
var json = new Object();
//add the datashape definition
//this needs to be the correct datashape for your rows, in my example this is just a datahsape with a single string field called id
json.dataShape = DataShapes["DataShapeName"].GetDataShapeMetadataAsJSON();
   
//create a rows array
json.rows = [];
//add each row as an object
var row = new Object();
row.id = "idValue";
json.rows.push(row);
// result: INFOTABLE
var result = Resources["InfoTableFunctions"].FromJSON({json: json});