Skip to main content
V
vsharma-211-Visitor
1-Visitor
August 17, 2017
Question

How to retrieve data for JSON

  • August 17, 2017
  • 1 reply
  • 6349 views

Hi,

I need to retrieve data from JSON and store in datatable. JSON is having a multiple tags. Please refer a below JSON data. Please let me know if anyone have a solution for it. Thanks in advance.

{"PhoneLocationList": {"PhoneLocation": [{

   "PhoneNo": "1234567890",

   "Status": "Success",

   "Location":    {

      "latitude": 50.3,

      "longitude": 20.2,

      "altitude": 3000,

      "accuracy": 60,

      "timestamp": "2013-06-24T10:50:57.000+0530"

   }

}]}}

Thanks and Regards,

Vaibhav Sharma

1 reply

S
supandey5-Regular Member
5-Regular Member
August 17, 2017

Hi Vaibhav, if i understand your use case right here you can follow this knowledge base article How to convert a "Json input" to an "Infotable" in a ThingWorx service

Could you check this and let us know if you still have an issue.

Thanks,

V
vsharma-211-VisitorAuthor
1-Visitor
August 18, 2017

I already tried this example and it is working fine but my JSON is different due to which i am facing problem. Please refer above JSON format.

B
BruceHulse5-Regular Member
5-Regular Member
December 8, 2017

Your data must be reformatted into an InfoTable format which looks like this for a table containing name and email columns:

(Text widget won't preserve the formatting from JSON Lint - you can see it structured if you use that tool)

{

"rows": [{

"name": "Abab",

"email": "example1@ptc.com"

},

{

"name": "Qaqa",

"email": "example2@ptc.com"

}

],

"dataShape": {

"fieldDefinitions": {

"name": {

"name": "name",

"aspects": {},

"description": "user name",

"baseType": "STRING",

"ordinal": 0

},

"email": {

"name": "email",

"aspects": {},

"description": "email address",

"baseType": "STRING",

"ordinal": 0

}

}

}

}

The point is that to be an InfoTable , you have two requirements: an array named 'rows' and a datashape describing the properties in each element of the 'rows' array. Your JSON structure is not flat so it can't just be turned into an InfoTable . You will either need to:

- flatten your structure by taking the child properties of Location and restating them as Loc.lattitude, Loc.longitude, ... so they fit into the above format.

- turn Location into a complete infotable (rows array plus dataShape) and make that the content of one of the properties in your top-level table.

If you want to easily see all the data fields in a grid in a mashup (columns in a grid will not render the value of an InfoTable column), you should flatten the JSON structure. If you want to carry Location in the table so you can use it as a data source for another table (say in a popup mashup), then the embedded InfoTable would be the easier approach.

    Terms & ConditionsCookie settingsAccessibility statement