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!

   Reply

   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.

      Reply

      1. Thank tou very much!
         I will check that =]

2. How does it works with GraphQL API?

   Reply

   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.

      Reply

3. Do I need to create each API URL or is there somewhere they are listed?

   Reply

   1. You need to create them based on the API documentation provided by each website or platform.

      Reply

4. Thanks, so no-one has compiled a fully created list yet that you know of?

   Reply

   1. There are a few API directories, e.g. https://apilist.fun/ and https://github.com/public-apis/public-apis.

      Reply

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

   1. By default Facebook limits the number of results in a single response as described here: https://developers.facebook.com/docs/graph-api/using-graph-api/#paging. To get more records, you can page through the results as described and/or add ‘&limit=1000’ (or some other number) to the end of your URL.

      Reply

      1. Thank you – this did the trick.

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

   1. Can you please try changing the report style to see if it returns the format you’re looking for? Report Styles: https://mixedanalytics.com/knowledge-base/report-styles/

      Reply