Configure the interface for WEBAPI

1. Select Tools > Edit Interface Info to add the interface. Select New to add new interfaces.

   

2. Build your SQL query in the SQL Editor Window by clicking the Query SQL box. Check that the query is working.

   

   For example, in the screenshot below, see the XML file and the SQL query in AVEVA Production Accounting.

   

   This query will fetch the name and price from the XML file. We can write similar queries, as required.

Configure the SQL Query as described in the procedure for building your SQL query in the SQL Query Editor Window in the topic Edit Interface Info.