AnsweredAssumed Answered

What is the best tool to get data from REST server with "dynamic" query string and JSON answer.

Question asked by CesarA on Aug 1, 2018
Latest reply on Aug 1, 2018 by jyi

I need to integrate a REST API to load data on PI Data Archive. The source provide a URI, but the query string change all the time because it has start and end date / time, and site ID parameters. It is not weather related but a third party operator. The answer is JSON formatted in the body.

 

A request may look like this:

https://www.sourcesite.com/siteID/1/power?startTime=2018-07-30%2007:00:00&endTime=2018-07-31%2008:00:00&key=123456789ASDF

RED changes

 

What is the best tool to download and move the data into PI for this case?

Outcomes