Skip to main content
1-Visitor
July 6, 2017
Question

How to read json file form Thingworx repository?

  • July 6, 2017
  • 1 reply
  • 1738 views

Hi,

We have json file need to read the file into thingworx infotable. Find below is the format of json file

   "DeviceID":"12345677887656",

   "command":"location",

   "state":"PER",

   "params":{ 

      "lat":"12.387",

      "lng":"77.86745",

      "Speed":"20.3",

      "Heading":"234",

      "time":"072034",

      "date":"250317",

      "SqNmbr":"123",

      "dist":"13.2",

      "GPSValid":"1",

      "History":"1",

      "ign":"1",

    "command":"Accelerometer",

    "params":{ 

         "X":"74",

         "Y":"102",

         "Z":"64"

      }

   }

}

we could load the json but not able to bind to info table getting in string format result.

could anyone suggest how can we do that?

Regards,

Anil Kesana

    1 reply

    20-Turquoise
    July 6, 2017

    Please refer to the following article. Note that you need to create a corresponding datashape:

    https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS232916&lang=en_US