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
• Part 1: Pull Data from WazirX to Sheets
• Part 2: Create a Custom API Request
• Part 3: API Documentation

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
   
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.
   
3. Choose a destination sheet, name your request, and hit Run
   

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.

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