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: Create Your API Request URL

For our first request, we’ll get 24 hr price change statistics for all tickers.

  • API Base URL: https://api.wazirx.com
  • Endpoint: /sapi/v1/tickers/24hr

Putting it together, we get the full API Request URL:

https://api.wazirx.com/sapi/v1/tickers/24hr

Part 2: Pull WazirX API Data into Google Sheets

We can now enter those values into API Connector.

  1. Open up Google Sheets and click Extensions > API Connector > Open.
  2. In the Create screen, enter the Request URL we just created
    wazirx-url
  3. We don’t need OAuth authentication so just leave that set to None. We don’t need to enter any headers either so just skip that section.
  4. Create a new tab and click Set current to use that tab as your data destination.
  5. Name your request and click Run. A minute or two later you’ll see a list of coins and related stats populate your sheet:
    wazirx-results

Part 3: More WazirX API Examples

You can check the documentation for the full set of endpoints and parameters, but if you just want to check it out, try the following examples:

  • Price change statistics for a specific currency pair
    https://api.wazirx.com/sapi/v1/ticker/24hr?symbol=wrxinr
  • Get recent trades
    https://api.wazirx.com/sapi/v1/trades?symbol=wrxinr&limit=10
  • Get exchange info
    https://api.wazirx.com/sapi/v1/exchangeInfo

Part 4: 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