Use Thingworx API to store data in InfluxDB

[Lo_ry96]

hello,

I have Thingworx platform in my work place that uses Kepserver layer to collect data from machines , store it in MSSQL DB and then use Thingworx web application to visualize data. 

I have the idea of using Grafana as visualization tool instead thingworx mash ups (more convenient to business) . What is the architecture suited to this need? I'm thinking about using API calls to populate an influxDB and then querry this DB in Grafana. 

Any ideas on this ? 

Thanks 

[VladimirN]

Take a look:

• "ThingWorx Performance Monitoring with Grafana": https://community.ptc.com/t5/IoT-Tips/ThingWorx-Performance-Monitoring-with-Grafana/ta-p/818800 
• "ThingWorx Monitoring and Alerting: Using Prometheus and Grafana, Part 1": https://community.ptc.com/t5/IoT-Tips/ThingWorx-Monitoring-and-Alerting-Using-Prometheus-and-Grafana/ta-p/845804 
• "ThingWorx Monitoring and Alerting: Using Prometheus and Grafana, Part 2": https://community.ptc.com/t5/IoT-Tips/ThingWorx-Monitoring-and-Alerting-Using-Prometheus-and-Grafana/ta-p/845847 
• "ThingWorx Performance Monitoring": https://www.youtube.com/playlist?list=PL69Ma82gzaTx2JnbrRY8qOQsCZaQUGOgl 

[Lo_ry96]

Hi thanks for shared info. Any ressources/ides on how to perform GET requests to fetch data from Thingworx? i'm turning around since a while as i'm starter to Thingworx platform so any guidance is appreciated 

Many thanks 

[VladimirN]

Some tips:

• "Use REST API to Access ThingWorx Part 1": https://community.ptc.com/t5/IoT-Tips/Use-REST-API-to-Access-ThingWorx-Part-1/ta-p/825305 
• "Use REST API to Access ThingWorx Part 2": https://community.ptc.com/t5/IoT-Tips/Use-REST-API-to-Access-ThingWorx-Part-2/ta-p/825684 
• "Use REST API to Access ThingWorx Part 3": https://community.ptc.com/t5/IoT-Tips/Use-REST-API-to-Access-ThingWorx-Part-3/ta-p/826227 
• "How to use REST API on ThingWorx Platform": https://www.ptc.com/en/support/article/CS329281 
• "Use Thingworx Service as REST API": https://community.ptc.com/t5/ThingWorx-Developers/Use-Thingworx-Service-as-REST-API/td-p/931464 

[vnamboodheri]

Hello @Lo_ry96, 

It looks like you have a response from a community member. If any of these replies helped you solve your question please mark the reply as the Accepted Solution. 

Of course, if you have more to share on your issue, please let the Community know so other community members can continue to help you.

Thanks,
Community Moderation Team.

[pshashipreetham · Accepted solution]

Hi @Lo_ry96,

I have done this before for another use case. Below are the steps:

1. Add Influx as the Secondary Persistence Provider in Thingworx
2. Create a value stream, while the creation of a Value stream selects the Secondary Persistence Provider instead of "ThingworxPersistenceProvider":
   
3. Then assign the value stream you have created to a Thing
4. Create the Properties and check the log while creating the Property
5. Once the Log is checked, when data comes to the property it gets stored in the Influx DB

Thanks,