Welcome to AggreGate Community

tableFromJSON function

Discussion of AggreGate Digital Enterprise Platform

tableFromJSON function

Postby erol.basak&enautomation.com » Sun Nov 07, 2021 9:56 pm

Hello,
I want to read data from mqtt device. I want to use the tableFromJSON function. But I am getting this error message. Can you support?

Error evaluating expression 'tableFromJSON(
cell(
cell({env/value},'message'),
'textMessage')
)':Error resolving reference
'env/value':Environment variable not found:value

thx

json data is :
I need to read just Score value from json. I can see the json string in the "Monitor Related Events" in TextMessage.

{"result":1,"ErrMsg":"OK","returnObject":"[{\"Score\":0.9719595,\"SubjectId\":\"cf459523-8186-4cc5-8712-18f7ff74f5d5\",\"SubjectPhotoId\":\"98d0014a-7db5-4b0f-be0c-3d98465ab58f\",\"PersonId\":0}]","SubjectId":"cf459523-8186-4cc5-8712-18f7ff74f5d5","Score":0.9719595,"Name":"EROL","LastName":"BASAK"}
erol.basak&enautomation.com
 
Posts: 11
Joined: Thu Mar 15, 2018 10:18 am

Re: tableFromJSON function

Postby moskons&gmail.com » Tue Nov 23, 2021 9:07 am

Hi.
On this issue, I would recommend ordering a professional service in Tibbo Systems.
moskons&gmail.com
 
Posts: 21
Joined: Mon Sep 20, 2021 3:41 pm


Return to IoT/IIoT Application Enablement

Who is online

Users browsing this forum: No registered users and 4 guests