![]() ![]() 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. Now go to SQL served and execute that query and it will make the API call using store procedure and provide you the response.Ĭreate Custom Virtual Table in ZappySys Driver Go to Code Generator Tab, select language as SQL Server and click on Generate button the generate the code.Īs we already created the linked server for this Data Source, in that you just need to copy the Select Query and need to use the linked server name which we have apply on the place of placeholder. Let's generate the SQL Server Query Code to make the API call using store procedure. In this example it will extract the orders from the date : 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 * from OPENQUERY(ZOHO CRM_LINKED_SERVER,'SELECT * FROM Customers')Ĭreate Custom Store Procedure in ZappySys Driver Enter your server name and any database nameĬlick on Advanced and enter query like below (we are assuming you have created JSON Data Source in Data Gateway and defined linked server (Change name below).Click Get Data in Power BI, select SQL Server Database.Once linked server is configured we are ready to issue API query in Power BI.First read this article carefully, How to query Zoho CRM API in SQL Server.Step-By-Step - How to query Zoho CRM API in SQL Server We will then use Linked Server in SQL Server to Link API Service and then we will issue OPENROWSET queries from Power BI to SQL Server and it will then call REST API via ZappySys Data Gateway. See below step by step instructions to enable DirectQuery mode in Power BI for REST API data.īasically we will use ZappySys Data Gateway its part of ODBC PowerPack. Out of the box ZappySys Drivers wont work in ODBC Connection Mode so you have to use SQL Server Connection rather than ODBC if you wish to use Live data using DirectQuery option. ![]() In this section we will explore how to use DirectQuery along with ZappySys Drivers. Power BI Offers very useful feature for this scenario. So far we have seen how to Import REST API data into Power BI but what if you have too much data and you dont want to import but link it. Using DirectQuery Option rather than Import ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |