Skip to main content
MR_104041026-Contributor
6-Contributor
March 2, 2023
Solved

Finding data in json from an infotable.

Hello,

 

Can somebody help me to write a service in thingworx where infotable data value is checked if it is found in a json data.

 

Thanks.

 

Sathishkumar_CAnswer
17-Peridot
March 2, 2023
  • Iterate the infotable
  • Compare values with JSON from infotable
  • if found, get the required values
var info = [INFOTABLE];
for( var i = 0; i < info.length; i++){
 //Get the infotable row values
 //Search in JSON
 if(isFound == true){
 //Get the required value
 }
}

If possible share the sample dataset.

View in thread

3 replies

Sathishkumar_C17-Peridot
17-Peridot
March 2, 2023

Can you please explain bit more about your use case?

Translate
MR_104041026-ContributorAuthor
6-Contributor
March 2, 2023

I have a json data which has multiple json arrays. I have an infotable which has data which can be compared to the json data. If at all i find the value in the json then i have to get certain key value pairs of that object. 

Translate
Sathishkumar_C17-PeridotAnswer
17-Peridot
March 2, 2023
  • Iterate the infotable
  • Compare values with JSON from infotable
  • if found, get the required values
var info = [INFOTABLE];
for( var i = 0; i < info.length; i++){
 //Get the infotable row values
 //Search in JSON
 if(isFound == true){
 //Get the required value
 }
}

If possible share the sample dataset.

Translate
Terms & ConditionsAccessibility statement