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,
TF
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
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.