How to connect to a REST API site using the ODBC

ODBC PowerPack API Driver
1

Introduction

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

Prerequisites

Steps

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).

    Create new System DSN for ZappySys ODBC Driver
    Create new System DSN for ZappySys ODBC Driver614×505 47 KB

  3. Use a JSON driver with a sample URL like https://jsonplaceholder.typicode.com/todos/ for a JSON example. Apply any necessary select filters and test the connection.

    ODBC JSON driver example
    ODBC JSON driver example804×704 50.9 KB

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

    ODBC JSON driver example preview
    ODBC JSON driver example preview804×639 37.3 KB

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

Conclusion

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.

References