Search API Connector Documentation

Print

Import WazirX Data to Google Sheets

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

We’ll only be using their public endpoints so we don’t need any API keys or other authorization for the examples in this article.

Contents

Before You Begin

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

Part 1: Pull Data from WazirX to Sheets

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

  1. Select WazirX from the drop-down list of applications
    wazirx-application
  2. Select an endpoint.  These endpoints are all open so you don’t need an API key. For this example we’ll choose the /tickers/24hr endpoint, which provides 24 hour price change stats for all tickers.
    wazirx-endpoints
  3. Choose a destination sheet, name your request, and hit Run
    wazirx-response

Part 2: Create a Custom API Request

Alternatively, you can run your own custom requests instead of using API Connector’s pre-built integration. To create a custom request, add the complete URL into the request URL field.
wazirx-results

To easily convert from a preset request to a custom API URL, tick the Add request URL box before running your preset request (under Output options). This will print out your complete API URL, which you can then copy/paste into the request URL field.

Part 3: API Documentation

Official API documentation: https://docs.wazirx.com/#public-rest-api-for-wazirx

Previous Import Visual Website Optimizer (VWO) Data to Google Sheets
Next Import Weatherstack Data to Google Sheets

Leave a Comment

Table of Contents