SSIS tip: How to connect Zocdoc API with Zappysys SSIS

SSIS Tips
,
1

Introduction

Connecting to external APIs, such as Zocdoc, in SSIS enables seamless integration of healthcare appointment and provider data into your ETL processes for reporting, analytics, and operational workflows. Zocdoc provides APIs for doctors, appointments, and related resources. This tutorial walks you through the steps to configure a connection to the Zocdoc API using ZappySys components to securely fetch data into SSIS.

Prerequisites

  • Download and install the ZappySys SSIS PowerPack.
  • A valid Zocdoc API client ID and client secret.

Steps

  1. Add a Data Flow Task to your SSIS package.

  2. Drag and drop a JSON Source component into the Data Flow.

  3. Check Use credentials and create a new OAuth connection.

  4. In the OAuth version, select OAuth2.

  5. In the OAuth Grant type, select Client Credentials Grant.

  6. Enter your Client ID and Client Secret.

  7. In Access Token URL, use:

    https://auth.zocdoc.com/oauth/token

  8. Insert the required scopes. For example:

    external.appointment.read external.appointment.write

    OAuth configuration
    OAuth configuration737×602 27.1 KB

  9. Go to the Advanced tab and use the extra attribute for token request to add additional data to the request body:

    audience=https://api-developer.zocdoc.com/

  10. Set Content Type to application/json and click OK to save the configuration.

    Advanced OAuth settings
    Advanced OAuth settings722×722 37.1 KB

  11. In the JSON Source, enter the API endpoint you want to use. For example:

    https://api.zocdoc.com/v1/doctors

  12. Preview the data to ensure that the connection and query are working correctly.

Conclusion

Using the JSON Source component in ZappySys SSIS PowerPack, you can securely retrieve and manage data from Zocdoc. By properly configuring the OAuth2 Client Credentials grant and setting the correct scopes and request parameters, you can automate data extraction for appointments, doctors, and other resources.

Explore our SSIS PowerPack for more information and download and install it to start building smarter, faster, and more scalable solutions.

References

Contact us

If you encounter any issues or have specific questions, reach out to our support team via live chat or support ticket using our email support@zappysys.com.