Skip to main content
14-Alexandrite
Feb 17, 2023 10:14 AM UTC
Solved

How can I run InfluxQL in ThingWorx to query data?

Dear all,

I am having an issue that the Thing's QueryPropertyHistory function does not return data if no data in the specified time period. But InfluxDB itself has the fill(previous) which can find the most recent value. So to resolve my issue, I have to run the InfluxDB to query data to ThingWorx. May I know if anyone know how to run InfluxQL in ThingWorx?

 

 

 

19-Tanzanite
Feb 17, 2023 12:40 PM UTC

In short, you will need to query data separately via the ContentLoader snippets (POST etc) to be able to construct a custom HTTP request that's using the fill parameter.

It's a simple task and the InfluxDB query capabilities are listed here: https://docs.influxdata.com/influxdb/v1.8/guides/query_data/

 

2 replies

19-Tanzanite
Feb 17, 2023 12:40 PM UTC

In short, you will need to query data separately via the ContentLoader snippets (POST etc) to be able to construct a custom HTTP request that's using the fill parameter.

It's a simple task and the InfluxDB query capabilities are listed here: https://docs.influxdata.com/influxdb/v1.8/guides/query_data/

 

Translate
eyli14-AlexandriteAuthor
14-Alexandrite
Feb 18, 2023 11:32 AM UTC

Thanks a lot for your help.

Translate