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.

Create Custom Store Procedure in ZappySys Driver

Ms access crm template