I created several Table value functions in PI SQL Commander. These are the Transpose Functions. Are they exposed through the PI Web API? if so, what controller?
These tables are not exposed through PI Web API.
If you are using the 'old' PI SQL Data Access (PI SQL DAS) server against PI OLEDB Enterprise, the TFS you create are available in PI OLEDB Enterprise plus those PI SQL Clients connecting against the 'old' PI SQL DAS such as PI JDBC Driver and PI ODBC Driver.
Please note there is a new generation of PI SQL DAS available which does not depend on PI OLEDB (Classic) or PI OLEDB Enterpirse like the 'OLD' PI SQL DAS does. This new query engine is referred to as PI SQL DAS (RTQP Engine) and its setup kit is included with the recent PI Server setup kit like PI Web API. PI SQL Client refers the clients to the RTQP Engine and there is currently only support for the OLEDB standard but ODBC and JDBC is in the works.
Retrieving data ...