cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X

JsonToInfotable(service).

ds-21
7-Bedrock

JsonToInfotable(service).

What is InfoTable ?


An InfoTable is zero indexed, ordered array of javaScript objects which expose  sameproperties. Since an InfoTable is an Array of Objects, it can also be thought of as a table where the array entries are rows and the object properties of each object in the array are the columns.

For example :


var people = [

      {

          "name": "dinesh",

            "age" : 21  ,

          "mobileno" : 025514855

      },

      {

          "name": "senthilkumar",

            "age" : 55  ,

          "mobileno" : 622488596

      }

];

As you can see InfoTables only contains the same type of object.This is achieved using another ThingWorx specific mechanism called Data Shape



Service For Json Format to  DataShape:


var people = [

      {

           "name": "dinesh",

            "age" : 21   ,

          "mobileno" : 025514855

      },

      {

          "name": "senthilkumar",

            "age" : 55   ,

          "mobileno" : 622488596

      }

];

var params = { dataShapeName: "SampleDataShape" /* DATASHAPENAME */,

              infoTableName: "alertService1" /* STRING */ };

var result = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params);

var len=people.length;         // finding the length of the JSON

for( var i=0;i<len;i++){     

                    // TRAVERSE  the json

json.png

    var row = new Object();         // create the row  for every records.

    row.Name=people.name;

    row.age=people.age;

    row.mobileNo=people.mobileno;

    result.AddRow(row);           // it will add the records in the datashape.

}

  

Result of the service:


result.png

​Then  select the datashape  for Mashup Loading:

1) edit the Service(you created).

2) click input/output bar.

3) add datashape(you created)

4) check the output should be Infotable.



service.png


2 REPLIES 2
kraj1
1-Visitor
(To:ds-21)

this is helpful for me. thank you dinesh

dsenthil
2-Explorer
(To:ds-21)

i am new to thingworx this was very helpfull. thanks

Announcements
Top Tags