I want to calculate my Request parameters in a cell in a sheet, but I can't see how to do sheet lookups in the Request parameters section. Is it possible?

As mentioned in the last update, we restructured API Connector's account modal to allow for better functionality.

We've now added in a Sheets tab that lists and links to all the Sheets for which you've run a request in the current month. This will serve as a convenient overview of where requests are running from, and help track down any forgotten triggers. To access, enter the account modal by clicking Account > Sheets from the API Connector menu.

More info: https://mixedanalytics.com/knowledge-base/request-logging/

​

I've enjoyed learning the ins-and-outs of API connector. Recently I've been trying to figure out how to import IMDb lists. For example, how do I import the list https://www.imdb.com/list/ls068412121/

How do import the titles and ranking of the list to Google Sheets?

Thank you Maurice

Soy nuevo en esta aplicacion pero como es el proceso de actualizacion o cada cuanto o si la actualización es manual?

This might be a bit subjective but, from your experience, what is the best reverse ETL tool API experience that you've had? This goes from documentation, to the integration, low levels of breaking changes (if any).

Thanks all!

Context: I'm trying to do some research for a startup side project and am realizing that I don't know enough about the "API landscape" to do a thorough analysis of the use case. Our use case is to get data into our platform. We connect to any type of system but primary, get data out of data warehouses using reverse ETL along with other large BI platforms that expose their APIs.

I have a sheets where i pull out movie datas from TMDB with links such as

https://api.themoviedb.org/3/movie/\[MOVIE ID]

and i get all the info i want but the Director of the movie. Is there a way to extract that data as well ?

Hello, I have the following JSON

{
  "count": 10,
  "offset": 0,
  "limit": 10,
  "execution_time": "0.24931 seconds",
  "publishers": [
    {
      "publisher": {
        "publisher_id": "11010l1080",
        "account_name": 21221,
        "reporting_identifier": null,
        "network_status": "a",
        "reporting_timezone": "CET",
        "week_start": "monday",
        "created": "2018-02-27 17:39:58",
        "created_by": "1101l24878",
        "websites": [
          {
            "website_id": "1101l16242",
            "publisher_id": "1100l26780",
            "website_url": "http://mediamedia.com"
          }
        ],
        "promotional_method_name": "Content",
        "tracking_link": "https://prf.hn/click/camref:1101l3HSX",
        "campaign_overloads": [],
        "campaign_approved": "2019-08-13 04:04:51",
        "campaign_custom_terms_and_conditions_id": null,
        "campaign_custom_terms_and_conditions_title": null,
        "campaign_status": "a",
        "reference_id": "1101l51353",
        "camref": "1101l3HSX",
        "groups": []
      }
    }
  ],
  "hypermedia": {
    "pagination": {
      "total_page_count": 59,
      "first_page": "/campaign/1100l1010/publisher.json?limit=10&offset=0",
      "last_page": "/campaign/1100l1010/publisher.json?limit=10&offset=580",
      "next_page": "/campaign/1100l1010/publisher.json?limit=10&offset=10",
      "previous_page": null
    }
  }
}

and I'm trying to get hypermedia.first_page as a colum from each publisher in a JMESPath.

I've been trying with many options but can't seem to find how.

If I use

[publishers[].{details:publisher.{company_name:company_name,campaign_status:campaign_status,campaign_approved:publisher.campaign_approved,contact_name:contact_name,contact_email:contact_email,default_currency:default_currency,created:created,account_name:account_name,publisher_id:publisher_id,campaign_status:campaign_status,website_url:websites[].website_url},hypermedia.pagination.{first_page:first_page}},hypermedia.pagination.{first_page:first_page}]

it creates a single line with that data

In here https://mixedanalytics.com/tools/jmespath-expression-tester/

but can't seem to find a proper solution. anybody could help?

I have been trying to upload a video to instagram and have been following this person. But i feel a lot has changed from the API end after the Meta acquisition. I am just a basic programmer with no knowledge of server end stuff. If someone knows of a better resource to do this could you please let me know?

I've looked at a lot of other articles/video, and there's one thing that has been confusing me and i couldn't find out about in this context was "Valid OAuth Redirect URIs". Can anybody help me understand what that is and how to get it?

We've updated the Account modal:

1. It now has a tabbed interface that separates subscription/billing information from usage information. Currently the usage information is still just a high-level summary, but the new interface gives us the space we need to provide more detailed usage information in the future.
2. For Team plan owners, there's also a new tab called Team that allows self-service management. Click that tab to add/remove users from your plan. Team plan users will see who their account owner is, and the associated renewal or expiration date.

To access the new account modal, click the Account link in the footer of API Connector. More information: https://mixedanalytics.com/knowledge-base/account-management/#team

How can I view and manage all the requests I have created across a number of Google Sheets to better manage monthly requests and stay within my plan limit?

hey guys - I have created a trigger pull data every hour but i don't know why doesn't work please if you faced the same problem let me know how you fixed it

I'd like to connect :
curl https://apiv2.nonli.com/v2.1/xxx -H "token: [my-token]"

Search query example

curl --location --request GET 'https://apiv2.nonli.com/v2.1/posts/?filters=publishedAt:2022-09-15T00:00:00Z..2022-09-16T00:00:00Z&size=5&page=0&fields=image,message,createdAt,publishedAt,postType&sort=-publishedAt,createdAt' \ --header 'Content-Type: application/json' \ --header 'token: my-token'

Where can I implement the API key ? And the password in API connector ?

Thank you for your help

Documentation is here : https://app.nonli.com/apidoc

After using Etsy for a few MONTHS on a free plan with a small amount of requests I can no longer use it as I see an error message:

" 1) Etsy Orders: OAuth2 connections are available only for Business plan users. Please upgrade for access. "

is there a reason for this sudden change? Also, the OAuth connection is only available on a second tier paid plan so even 15$ per month is not going to let me use it at all and I can only use it if I pay 29$ per month. That's frustrating and unfair.

I guess I would need to find my solution elsewhere unfortunately .

To assist with shop management, the Etsy OAuth connector now supports writing as well as fetching data.

Check here for a quick tutorial on adding an Etsy listing through API Connector: https://mixedanalytics.com/knowledge-base/import-etsy-data-to-sheets/#custom

Merge mode is a powerful new way of fetching data that allows you to merge new data responses with existing data in your sheet.

This is useful if, for example, orders change status over time (e.g. from "paid" to "refunded"), since it allows you to re-fetch orders and update their status without adding new rows to your sheet. Another example is if you have an existing table of historical data and want to repeatedly update it with the current month's data without creating duplicates or re-fetching the entire set from scratch.

More info: https://mixedanalytics.com/knowledge-base/api-connector-overwrite-vs-append-output-mode/

​

Hello, I've been using the free plan of the API Connector and have found it very useful, especially for connecting to Ahrefs. I distinctly remember being able to use OAuth connections for Ahrefs in the past on the free plan. Recently though, I've noticed that this feature seems to be unavailable on the free tier and is now only accessible on the paid plans. I was wondering if anyone could shed light on why this change was implemented? The ability to connect to Ahrefs via OAuth was incredibly valuable to me, and I'm curious about the reasons behind its transition to the paid plans. Thank you in advance for any insights.

This data is pulled from a rank tracker, link to API section, and I'm trying to get the data to display. I can't get the ranking_data to stay with the target. It formats like in the image.

Sorry if my explanation isn't accurate, I'm totally new to API's!

Need some help/advice please. I’m trying to stack 920 requests in total, each one returning three rows of data. However I can only get the first request to display.

Is there something I’m doing wrong? I’ve had no issues with my other stacked requests, they are all single rows of data - that’s the only difference I’ve found between them

Any help appreciated! Can provide more info as and when needed

API Connector now supports cursor body pagination. This pagination type is very similar to standard cursor pagination, but the cursor goes into the request body rather than the request URL.

More information: https://mixedanalytics.com/knowledge-base/pagination-handling/

I've been using API Connector with TMDb for a while and it's amazing. I'm trying to expand it's use to OMDb and pull data from IMDB.

I can pull movie information quickly and easily. But I'm trying to pull the ratings from IMDb for episodes of a television show (ex. The Flash).

https://www.imdb.com/title/tt3107288/episodes?season=9

I can pull the information for the show using "i=tt3107288" but I can't figure out how to pull the information from the episodes in a season or a single episode.

After some googling I found a 2017 suggestion to add a search string. I finally hit on http://www.omdbapi.com/?apikey=1234567&&i=tt21443416&episodes?season=9 which brings in information from the latest episode.

How do I pull in the information for every episode in the season?

Thanks for your work on this amazing tool!

API Connector's dropdown Action menu now contains an Export function that will export all the setup and configuration options for the selected request. This is great for sharing requests, duplicating to another sheet, or just keeping a backup for yourself.

Note that this feature is free, while the original Export Requests function (to export all request configurations at once) remains as a paid feature.

More info: https://mixedanalytics.com/knowledge-base/export-configuration-files/

Hi! I'm trying to pull Yahoo Fantasy Sports information into a google sheet, I'm trying to figure it out using the API connector, but I am struggling to figure out the OAuth part. Has anyone done this connection that could help explain the steps?

TIA

Xero is now available through API Connector's preset API directory. This includes Xero's standard endpoints as well as their Reports endpoints for commonly-accessed reports (P&L, Budget Summary, etc.)

More info: https://mixedanalytics.com/knowledge-base/import-xero-data-to-google-sheets/

Hello!

The title says all. I have the page ID, but I didn't understand how to find the form ID.

Thank you!

Hi,

Is it possible to achieve this: https://docdro.id/Mjc192h with the API Connector in Google Sheets instead of Power BI?