2 Replies Latest reply on Jun 26, 2017 12:08 PM by mfoerster

PI WEB API REST query

TerenceA Jun 26, 2017 4:59 AM

Hello PI Gurus,

I am curios to know whether I can query the pi database to extract all elements and it's attributes with their corresponding values in a single call.

My aim is to automate this process to insert values to another database. I understand that I can use individual "webid" and get the result. This require me to know the "webid's" before hand and make multiple single queries. Appreciate your help.

Thanks,

Re: PI WEB API REST query

Kenji Hashimoto Jun 26, 2017 8:08 AM (in response to TerenceA)

You can use Batch request to get webID and get value etc....
Aaron Rosenthal wrote great blog posts.
PI Web API: Getting multiple attributes with batch requests
PI Web API: Bulk streaming with batch requests
You can start from checking these blog posts.
Like Show 0 Likes(0)

Actions
Re: PI WEB API REST query

mfoerster Jun 26, 2017 12:08 PM (in response to TerenceA)

Hello Terence,

There is no explicit function to do that. Please also refer to the PI Web API reference
If you want still want to use PI Web API for it, you would have to go the way (see Kenji) of PI Web API: Getting multiple attributes with batch requests
I suggest you are referring to the PI AF Database. This database is stored in your SQL Server and called PIFD database.

What other database would you like to insert the values into? Can you please explain the use case for that?

Attributes if they are not static are references to results of calculations of PI Points or PI Points themselves. Therefore exporting the PIFD database would not bring these along.

Kind regards,

Moritz
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions

Go to original post