Search API Connector Documentation

Print

Import CryptingUp Data to Google Sheets

In this guide, we’ll walk through how to pull data from the CryptingUp API directly into Google Sheets, using the API Connector add-on for Sheets.

This is a free and open API so we don't need any API keys or other authorization. Let's jump right in!

Contents

Before You Begin

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

Part 1: Pull Data from CryptingUp to Sheets

The easiest way to get started with the CryptingUp API is through API Connector’s built-in integration.

  1. In Sheets, open API Connector and create a new request (Extensions > API Connector > Open > Create request)
  2. Select CryptingUp from the drop-down list of applications
    cryptingup-application
  3. Select an endpoint.  These endpoints are all open so you don’t need an API key. For this example we’ll choose the /assets endpoint, which gets the current market data for all supported cryptocurrencies.
  4. Choose a destination sheet, name your request, and hit Run. A moment later you’ll see the response data in your sheet.
    cryptingup-response

Part 2: Create a Custom Request

Alternatively, you can run your own custom requests instead of using API Connector’s pre-built integration, using any of the API URLs shown in the API documentation. Here's an example request setup:

  • ApplicationCustom
  • MethodGET
  • Request URLhttps://www.cryptingup.com/api/assets?size=100
    cryptingup-custom

Part 3: Handle Pagination

Note that the CryptingUp API limits the number of records returned in each request. By default, only 100 records will be returned unless you use the size and start parameters as shown in their documentation:
cryptingup-pagination

With API Connector, you can set up pagination handling to cycle through pages automatically, like this:

  • Pagination: cursor
  • Next token parameter: start
  • Next token path: next
  • Run until: choose when the request should stop running
    cryptingup-pagination-cursor

Part 4: API Documentation

Official API documentation: https://www.cryptingup.com/apidoc/

2 thoughts on “Import CryptingUp Data to Google Sheets”

Leave a Comment