Search API Connector Documentation

Print

Quick Start

For this quick start, we’ll walk through how to use the API Connector add-on for Google Sheets, using an example request from API Connector’s API request library.

SUPER QUICK START>>To get started immediately, just copy and paste the following example URL into the API URL Path, set an output sheet and click Run:

https://itunes.apple.com/search?term=radiohead

That’s it! But if you’d like more detail, read on for step by step instructions.

Contents

Before You Begin

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

Step 1: Open the Sidebar

After installing the plugin in Google Sheets, click Extensions > API Connector > Open

Step 2: Add a New Request

Once the sidebar opens, click Create request to start a new request.

quickstart-create-request

Step 3: Choose an API Request URL

If you already have an API URL in mind you can paste that in, otherwise let’s search the built-in API library for open APIs.

Open the application menu and choose any API marked with a green “unlock” icon. These open APIs don’t require any kind of authentication so they’re good to start with.

quickstart-unlocked

Step 4: Choose a Destination Sheet

Set where you’d like to send the response data. Type in a sheet name or click Set current to set the destination to your currently focused cell.

quickstart-img3

Step 5: Name and Run

Give your request a name and click Run. You should see the response data from your API request in your sheet.

Step 6: Customize Your Request

Now, go forth and enter in your own API requests! Experiment with different preset APIs, or follow the documentation to:

Questions?

Please leave a comment below, contact support, or leave a message in the API Connector user community. You’ll receive a response shortly.

Previous Print Timestamp
Next Set Data Destination

30 thoughts on “Quick Start”

  1. hello there.
    I’m using an API in a site called Bling. I’m trying to get all my products on google sheets.
    The resquest runs without any error, but it only gets the first 100 products (1st page on the system website)
    There is something I can do about it?

    Thanks!

    Reply
    • Hi Urian, API Connector displays all records returned from the API. Most likely your API limits the number of records in a single response (this is called “pagination”). There’s some info on this in the troubleshooting documentation, but basically you need to check Bling’s API documentation for how to receive additional records. There’s probably some query string you need to adjust to receive the next 100.

      Reply
    • When you work with GraphQL APIs, you add parameters to a “query” query string (documentation). For example if we’re pulling from the Countries GraphQL API, the graphQL query looks like this:

      { country(code: "BR") {
          name
          native
          emoji
          currency
          languages {
            code
            name
          }  } }

      You can run this in API Connector like this:
      1) Add that whole block into your sheet, say cell A1 of sheet called Input
      2) Now in cell A2, add the following formula: =ENCODEURL(A1). This will encode the whole query so we can add it to the end of the URL.
      3) Now in API Connector, enter the following API Request URL: https://countries.trevorblades.com/?query=+++Input!A2+++
      4) Click Run and you’ll see the results populate your sheet.

      Reply
  2. Thank you for this, this was so useful.
    When I run my request, no matter the configuration, it only produces maximum 26 rows of data – significantly less than there actually are in Facebook. Could you please help? Thank you!

    Reply
  3. At the moment my Google Sheet has columns “data » actions » 1 » action_type” and “data » actions » 1 » value”. This makes linking to Google Data Studio quite difficult because it doesn’t simply say “ad_name – 3 link_clicks” for example.

    Is there a way to update the output so there is a designated column for each “action_type” e.g. “link_clicks”, and then the value, as is the case with “data » impressions”?

    I appreciate any help.

    Reply
      • ah thanks, U are right. I found the problem. This Url is not outgoing, must be opened by myself with the account.

        How can i import the Api which is private.

        [{"id": 6229102, "datetime": "2022-02-22T12:45:25.827083+00:00", "searchCost": 27832, "resources": [{"amount": 3, "price": 86851, "kind": {"name": "\u8c6a\u534e\u98de\u673a", "image": "images/resources/private-jet.png", "db_letter": 96, "transportation": 1000, "retailable": true, "research": false}}, {"amount": 1, "price": 61265, "kind": {"name": "\u4eba\u9020\u536b\u661f", "image": "images/resources/satellite.png", "db_letter": 99, "transportation": 10, "retailable": true, "research": false}}], "qualityBonus": 1.78, "speedBonus": 0}, {"id": 6229104, "datetime": "2022-02-22T12:45:26.188100+00:00", "searchCost": 27832, "resources": [{"amount": 2, "price": 229334, "kind": {"name": "\u55b7\u6c14\u5ba2\u673a", "image": "images/resources/jumbojet2.png", "db_letter": 95, "transportation": 2000, "retailable": true, "research": false}}, {"amount": 2, "price": 62710, "kind": {"name": "\u4eba\u9020\u536b\u661f", "image": "images/resources/satellite.png", "db_letter": 99, "transportation": 10, "retailable": true, "research": false}}], "qualityBonus": 1.68, "speedBonus": 0}]

      • Normally APIs provide an API key for APIs that are private. If this API doesn’t provide an API key then there wouldn’t be a way to access the data through Sheets, since it runs in a sandbox separate from the browser. Is there any documentation you can check?

    • Hey Matt, their documentation says that this API only allows access through OAuth for approved partners. So unfortunately you can’t set up your own custom OAuth connection as with other APIs. I’ll look into applying and getting access for Mixed Analytics so we can add this to our list of preset connections in the future.

      Reply
    • I don’t think this will work as we only enable sending JSON in request bodies, while it looks like this API requires an XML request body. Sorry for the inconvenience, will look into adding support for this in the future!

      Reply
  4. Hi,

    I am trying to fetch freshdesk tickets, however, showing a 401 error that credentials invalid. Freshdesk is logged in but with company’s common Microsoft account, however, I am using my gmail account.
    How to solve this?

    Response:
    We received an error from freshdesk.com (401)
    {“code”:”invalid_credentials”,”message”:”You have to be logged in to perform this action.”}

    Reply
    • You don’t actually have to be logged in to Freshdesk to use their API, so I think this is just a poor error message. The real problem is shown in the “code”, which shows you have entered invalid credentials. Please doublecheck the token you’ve entered in the Headers section, and make sure you’ve correctly encoded it as shown here.

      Reply
    • Generally you include your API key in the URL or as a Header, but it could be in the request body. There’s no generic input field for API keys, since every API is different. The API’s documentation will tell you where to include it. If you can share the name of the API, I’ll be happy to check it out for you and give you more specific instructions.

      Reply

Leave a Comment

Table of Contents