API Connector Documentation

Print

Import Dr Chrono Data to Google Sheets

Last Updated On
byAna
< Knowledge Base

In this guide, we’ll walk through how to import Dr Chrono data directly into Google Sheets, using the API Connector add-on for Sheets. We'll set up a custom OAuth connection and connect to their API.

Contents

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Get your Dr Chrono OAuth Credentials

  1. Log in to Dr Chrono and click API in the dropdown menu (or navigate to https://drchrono.com/api-management/ directly)
    drchrono-api
  2. You can name your app anything, but make sure to use the redirect URL provided in this article on configuring custom OAuth. Click Save Changes
    drchrono-createapp
  3. Copy the Client ID and Client Secret, we'll need them shortly.
    drchrono-credentials

Part 2: Connect Dr Chrono to API Connector

  1. Open up Google Sheets and click Extensions > API Connector > Manage Connections
  2. Scroll to the bottom of the sidebar and click Add Custom OAuth
  3. Fill in the Custom OAuth modal as follows:
    • OAuth Grant Type: Authorization Code
    • Name: Custom Dr Chrono
    • Authorization Base URL: https://drchrono.com/o/authorize/ (This will allow all available scopes; if you would like to limit them, attach them to the end of the authorization base URL, e.g. https://drchrono.com/o/authorize/?scope=patients:summary:read calendar:read clinical:read)
    • Token URL: https://drchrono.com/o/token/
    • Client ID: provided by Dr Chrono
    • Client Secret: provided by Dr Chrono
  4. Click Save
    drchrono-customoauth
  5. Click Manage Connections to return to the list of connections
  6. Scroll down until you find your new custom connection. Click Connect
    drchrono-connect
  7. You'll be prompted to give access to the new app you created above. Click Authorize
    drchrono-authorize
  8. You'll be returned to your sheet and can verify that the new connection is now active.

Part 3: Get Dr Chrono Data in Sheets

To create a request, include your full request URL in the request URL field, and select your custom Dr Chrono connection from the dropdown OAuth menu.

You can see the full list of available endpoint and parameters in the API documentation. For example, to get a list of patient allergies, run a request like this:

  • Application: Custom
  • Method: GET
  • Request URL: https://app.drchrono.com/api/allergies
  • OAuth: Custom Dr Chrono
drchrono-response

Part 4: Handle Pagination

By default, Dr Chrono will limit the number of records returned at one time (usually to 250 records per page). To fetch more records, use pagination handling.

  • Pagination type: next page URL
  • Next page path: next
  • Run until: choose when to stop fetching data
    drchrono-pagination

Part 5: API Documentation

Official API documentation: https://drchrono.com/api-docs/#section/Introduction

Leave a Comment

Jump To