How to connect to a REST API site using the ODBC


This article provides step-by-step guidance on connecting to a REST API using ODBC.



Create an ODBC Source Driver:

  1. Open the ODBC Data Source by typing “ODBC” in the search box and launching it.
    Open ODBC

  2. Create a User Data Source (User DSN) and select the ODBC driver you want (JSON driver, XML driver, or CSV driver).

  3. Use a JSON driver with a sample URL like for a JSON example. Apply any necessary select filters and test the connection.

  4. Navigate to the Preview tab and preview the data.

  5. ZappySys offers an API connector that enables connections to various services such as Google Drive, Google Sheets, Azure Ops, SharePoint, Jira, and more.


You are now successfully connected to a REST API service. This process works similarly with XML and CSV drivers if you’re using these formats. For any issues or further assistance, please get in touch with our support team via chat on our website.