Skip to main content
K
KN_97740471-Visitor
1-Visitor
February 11, 2021
Question

How do I remove datashape field from below JSON output?

  • February 11, 2021
  • 1 reply
  • 2371 views

{
"data": [
{
"usageId": "50030540014333322800000050",
"assetFound": true,
"compartments": {
"rows": [
{
"compartmentId": "50030540014333322800000052",
"observableProperties": {
"gatewayLocationDescription": "Ireland",
"temperature": 6,
"timestamp": 1612393200000
},
"compartmentUsage": {
"compartmentState": "Inuse",
"minTemperatureThreshold": 2.2
}
},
{
"compartmentId": "50030540014333322800000051",
"observableProperties": {
"gatewayLocationDescription": "Belgium",
"temperature": 2,
"timestamp": 1612220400000
},
"compartmentUsage": {
"compartmentState": "Idle"
}
}
],
"dataShape": {
"fieldDefinitions": {
"compartmentId": {
"name": "compartmentId",
"aspects": {
"isPrimaryKey": false
},
"description": "",
"baseType": "STRING",
"ordinal": 1
},
"observableProperties": {
"name": "observableProperties",
"aspects": {
"isPrimaryKey": false
},
"description": "",
"baseType": "JSON",
"ordinal": 3
},
"compartmentUsage": {
"name": "compartmentUsage",
"aspects": {
"isPrimaryKey": false
},
"description": "",
"baseType": "JSON",
"ordinal": 2
}
}
}
}
}
],
"message": "Information found",
"status": "Success"
}

1 reply

S
suverma14-Alexandrite
14-Alexandrite
February 11, 2021

Hi @KN_9774047 

 

You can refer to below link to get rid of datashape fields coming along in your JSON output:

 

Remove DataShapes from JSON Output 

 

Do revert for more queries.

 

Regards,

Sudeepta

K
KN_97740471-VisitorAuthor
1-Visitor
February 11, 2021

Tried that way in Thingworx 9.0.3 but not working out.

 

datShape field is still showing up in the output

S
suverma14-Alexandrite
14-Alexandrite
February 11, 2021

Hi @KN_9774047 

 

I gave the code a try in 9.0.3 and able to get output without datashape. Sharing my script for reference:

 

 

Spoiler

var params = {
infoTableName: undefined /* STRING */,
dataShapeName: "DS" /* DATASHAPENAME */
};

// result: INFOTABLE
var result1= Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params);

var newEntry = new Object();
newEntry.name = "test1"; // STRING - isPrimaryKey = true
newEntry.value = "test 1"; // STRING - isPrimaryKey = true
result1.AddRow(newEntry);

newEntry.name = "test2"; // STRING - isPrimaryKey = true
newEntry.value = "test 2"; // STRING - isPrimaryKey = true
result1.AddRow(newEntry);

newEntry.name = "test3"; // STRING - isPrimaryKey = true
newEntry.value = "test 3"; // STRING - isPrimaryKey = true
result1.AddRow(newEntry);

var param = {
table: result1 /* INFOTABLE */
};
var result = Resources["InfoTableFunctions"].ToJSON(param);
result.array = result.rows;
delete result.rows;
delete result.dataShape;

 

Spoiler
JSON Output:
{
"array": [
{
"name": "test1",
"value": "test 1"
},
{
"name": "test2",
"value": "test 2"
},
{
"name": "test3",
"value": "test 3"
}
]
}

Could you attach your service code here if still not getting output without DataShape.

    Terms & ConditionsAccessibility statement