

That's it now go to Preview Tab and Execute your custom virtual table query.

Here is an example SQL query for ZappySys Driver. Select the created table, Select Text Type AS SQL and write the your desired SQL Query and Save it and it will create the custom table in the ZappySys Driver: Go to Custom Objects Tab and Click on Add button and Select Add Table:Įnter the desired Table name and click on OK:Īnd it will open the New Query Window Click on Cancel to close that window and go to Custom Objects Tab. If you have 50 URLs with slight variations you can create virtual tables with just URL as Parameter setting. You can create many Virtual Tables on the same Data Source (e.g. In such case Virtual Table is very useful. Many applications like MS Access, Informatica Designer wont give you option to specify custom SQL when you import Objects. However not every application support supplying custom SQL to driver so you can only select Table from list returned from driver. This way you don't have to create multiple Data Sources if you like to read data from multiple EndPoints. ZappySys API Drivers support flexible Query language so you can override Default Properties you configured on Data Source such as URL, Body. In this example it will extract the orders from the date :Ĭreate Custom Virtual Table in ZappySys Driver That's it now go to Preview Tab and Execute your Store Procedure using Exec Command. SELECT * FROM Orders where OrderDate >= '' You can insert Placeholders anywhere inside Procedure Body. Here is an example stored procedure for ZappySys Driver. Select the created Store Procedure and write the your desired store procedure and Save it and it will create the custom store procedure in the ZappySys Driver: Go to Custom Objects Tab and Click on Add button and Select Add Procedure:Įnter the desired Procedure name and click on OK: Steps to create Custom Store Procedure in ZappySys Driver. You can create procedures to encapsulate custom logic and then only pass handful parameters rather than long SQL to execute your API call. Select one and load the data!įinally, use data extracted from JSON API in an Excel worksheet:Ĭreate Custom Store Procedure in ZappySys Driver Finally, you will be asked to select a table or view to get data from.
