Quick Start

Quick Start

Comments:14

  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!

    1. Hi Urian, API Connector displays all records returned from the API. Most likely your API limits the number of records in a single response. 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.

    1. 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.

  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!

  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.

Leave a Reply

Your email address will not be published.