Extract data of System Explorer>Library> Tables into Sql Commander lite

Hello,

It is not possible to access AF Tables via PI SQL Commander Lite (actually PI OLEDB Enterprise or PI SQL Client). As an alternative, I would suggest using PI Web API and its Table controller.

Hi Piotr,

Thank you so much for reply.

is it possible to share the steps to the extract reference table data using PI WebAPI.

Thanks,

Kajal

Hi Kajal,

This task actually boils down to sending Table GetData request to your PI Web API including a WebID of a table. Of course you need to repeat it for all tables. Exact steps depend on kind of client you are going to use to send those request plus there are system-specific parameters like your PI Web API URL and WebIDs.

Hi Kajal,

This task actually boils down to sending Table GetData request to your PI Web API including a WebID of a table. Of course you need to repeat it for all tables. Exact steps depend on kind of client you are going to use to send those request plus there are system-specific parameters like your PI Web API URL and WebIDs.