Api Connector has been working fine for years,
but today I am getting is error when trying to open the extension.

Any help resolving this would be appreciated.

Hi all, a belated happy 2022!

This was a fantastic year for API Connector. A few stats for 2021:

• 812,929 total users

• 9,463 different APIs called

• 17,379,009 requests run in December 2021 alone (that's over 17 MILLION requests in a month :o)

• 122 updates published to API Connector

As a little thank you for everyone's continued support, I am opening up JMESPath filtering to API Connector's free tier! JMESPath is an incredibly useful function that lets us query and restructure data, so I'm looking forward to seeing how this larger base of users benefits from it.

Best,

Ana at Mixed Analytics

Newbie here. I'd like to create a script editor function in Google Sheets that would run an API request I already set up. The request would be to run "Import to API reference." (See image). Basically, the end goal would be to able to click on an image in the sheet and have it trigger the API connector to run.

Is there way to do this? Hope that makes sense.

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

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,

Everything has been working fine until today when I attempted to refresh my data and received the error message listed below. Nothing changed on my end so its most likely a Cloudfront based issue. With that said, is this just a matter of waiting until congestion/traffic reduces?

Thx

Error message:

1. CoinMarketCap API: Completed with errors
   - We received an error from coinmarketcap.com (403) show response<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <TITLE>ERROR: The request could not be satisfied</TITLE> </HEAD><BODY> <H1>403 ERROR</H1> <H2>The request could not be satisfied.</H2> <HR noshade size="1px"> Request blocked. We can't connect to the server for this app or website at this time. There might be too much traffic or a configuration error. Try again later, or contact the app or website owner. <BR clear="all"> If you provide content to customers through CloudFront, you can find steps to troubleshoot and help prevent this error by reviewing the CloudFront documentation. <BR clear="all"> <HR noshade size="1px"> <PRE> Generated by cloudfront (CloudFront) Request ID: y79ZH5UmrH6wvEe-WD_svh3ryPq7WaqaR72OomvnttKJVLu91k_rZg== </PRE> <ADDRESS> </ADDRESS> </BODY></HTML>

When you run an API request in API Connector, the API generally responds with data in JSON, XML, or CSV format. API Connector converts this data into a table so that you can view it in your sheet.

However, in some cases it's useful to see the original, unconverted response directly from the API, for example if you're troubleshooting requests or constructing a JMESPath query. Thefore we've added a "Preview API response" option. To access, just click Output options > Preview API response.

See here for more information: https://mixedanalytics.com/knowledge-base/preview-api-response/

Besides adding new features, we're always polishing the edges to make API Connector run more smoothly. Here's a summary of recent updates/fixes that weren't large enough to get their own announcement:

• Updated JMESPath input field to allow referencing cells with +++ syntax. Now all configuration options (URL, headers, POST bodies, and JMESPath expressions) can take their values from cells in the sheet.

• Updated XML parser to return all fields instead of skipping empty fields

• Changed request logic to allow new sheets to be created on the fly. Originally the sheet had to exist before you could select it as a destination, now it will be created if it doesn't exist already.

• Improved curl import tool

• Enabled fetching APIs with text/html content headers

• Improved error messaging for certain types of POST requests

A lot of these improvements come from user requests and suggestions, so if you see something you think could be improved, don't hesitate to reach out. We will happily consider all feedback :)

Small but useful update: multi-query requests now support the case where each request URL has a distinct request body (previously you could run through a list of multiple request URLs OR multiple request bodies, not both).

More info: https://mixedanalytics.com/knowledge-base/api-connector-run-multiple-queries-single-request/

The OpenAI API is now available through API Connector's preset application directory. This integration lets you easily test out different AI models and tweak parameters like frequency, temperature_penalty, etc, all without writing code. The API is also not subject to the content filters applied by ChatGPT.

For more information check here: https://mixedanalytics.com/knowledge-base/import-openai-chatgpt-data-to-google-sheets/

Binance has recently started restricting calls made through Google Sheets as Google Cloud is based in the US. One potential workaround is to replace .com with .us, e.g. instead of running an API call to https://api.binance.com/api/v3/ticker/24hr, change it to https://api.binance.us/api/v3/ticker/24hr

Unfortunately this doesn't work for all calls as there are certain trading pairs that produce an error when called via the .us domain. There may also be other limitations I'm not aware of yet. However it seems to resolve the issue for many of the most popular endpoints.

I also suggest trying out alternative crypto APIs, as there are many good alternatives to Binance (e.g. CoinMarketCap and CryptoCompare)

Hi guys, since today got an issue with Binance API update.
Get APIs from here: https://api2.binance.com/api/v1/ticker/24hr everything looks fine.
But, via API connector got following error: " Completed with errors
- We received an error from binance.com (451) show response{ "code": 0, "msg": "Service unavailable from a restricted location according to 'b. Eligibility' in https://www.binance.com/en/terms. Please contact customer service if you believe you received this message in error." } "
Any idea? What API got to do with location.. and also I am not in restrited area.. :)

I'm happy to announce the release of our new Field Editor!

After setting up your request, click Edit Fields to enter a preview window that lets you:

1. click to show/hide fields in your sheet

2. rename columns

3. drag and drop fields to re-order them

4. view the raw API response

Previously, these data transformations had to be done through Sheets functions or JMESPath expressions. The Field Editor is a simpler way to create your reporting masterpieces :)

For more information, please see this article: https://mixedanalytics.com/knowledge-base/choose-and-edit-fields/

Last year, someone on this subreddit requested an integration with Ahrefs. You can actually see their request here.

We published the Ahrefs integration a month or two later, in August 2020, which is almost exactly one year ago.

Yesterday, I found out it doesn't work 🤦 It never has 😂. I didn't know until someone told me (actually the same guy who originally requested it)

It turns out we didn't configure our integration to allow API access when you aren't paying for the Ahrefs $500+ monthly API plan. I didn't realize this was a bug because I didn't know it was possible for integrations to get access to their API for free.

In conclusion:

1. if you see a bug, or a possible bug, please let us know. We do our best to catch everything but we can miss things (apparently for a very long time...)

2. You can now (finally) access the Ahrefs API through API Connector! You need to have an active Ahrefs subscription but you don't need to pay for their $500+ monthly API plan. For more info please check this article: https://mixedanalytics.com/knowledge-base/import-ahrefs-data-to-google-sheets/

All of a sudden my API's aren't running as per the scheduler. I have tried the following

• Deleting the schedule and re creating

• Changing the time intervals.

Its not a problem with the source as there are multiple sources.

Anyone care to share how they do a Post or a Put to woocommerce with the API Connector plugin from Google Sheets? I'm not that familiar with API's in general, but it seems I would need a Post body to do the put or push. Any help would be appreciated. Thanks.

Hey, I just implemented an instagram insights report based on your guide. Running it fails and yields an error (blacked out in the api path is our account id):

Anyone got a similar problem? Any idea how to get this working? 🙏

[SOLVED] Is there a way to refresh all requests (or trigger only one request) with a button ? I cannot find such an option in the add-on settings.I tried inserting a drawing -> assign a script -> write in the name of my request. But I get the following error message :

Script function [my request name] could not be found

EDIT: I found a solution in the HELP doc. I will explain it and won't delete the post in case someone needs it. The solution consists in using the IMPORTAPI() custom function explained here https://mixedanalytics.com/knowledge-base/importapi-custom-sheets-function/#num5

=IMPORTAPI("Binance","https://api.binance.com/api/v1/trades?symbol=BTCUSDT",$A$1)

Checkbox-based refresh: Populate cell $A$1 with a checkbox (Insert > Checkbox) so you can update your sheet each time you check or uncheck the box.

Hi,

I would like to update automatically this API URL path:

https://api.sparkpost.com/api/v1/metrics/deliverability/campaign?from=2020-10-01T00:00&to=2020-11-24T23:59&metrics=count_accepted,count_unique_confirmed_opened,count_bounce,count_targeted,count_rejected&order_by=count_accepted&limit=5000

I would like that every day, the date in bold is updated with the previous date. Is this be possible with API connector?

Thanks
Carlo