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.
