mixedanalytics

Dust off your antique APIs, API Connector now supports XML format! XML isn't that popular anymore, but some of the older APIs still use it, so this should be convenient for those who need it. This is available for both free and paid versions of API C...

The requests in the request list now show some extra metadata on hover: API request hostname last refresh timestamp (in sheet timezone) originally posted 2021-10-17

You can now set a destination cell for your data instead of importing data to cell A1 only. One of the main benefits is that you can keep calculations and formulas on the left-hand side of your sheet, then pull in data to the right of them so they do...

We've added a built-in library that includes hundreds of commonly used API URLs. To access the library, simply open API Connector and enter a keyword into the API URL field. You may search on API name, description, or authorization type. When you cli...

Last year, someone on this subreddit requested an integration with Ahrefs. 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 di...

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

We've added new built-in OAuth2 connections for several Google products: Calendar, Classroom, PageSpeed Insights, and Search Console. They can be accessed via the Connection Manager (Add-ons > API Connector > Manage Connections). Please try them out ...

We've made a couple of small but nice updates: Truncate headers: under Output Options, there's now an option to truncate headers. This makes the header row prettier by truncating paths. For example, if the original header was "campaigns » groupId", c...

We've upgraded our customer portal! Now, instead of requesting an access code through the website, simply open Sheets and navigate to Add-ons > API Connector > Account. The upgraded customer portal enables the following features: Cancel plan Upgrade ...

We've added new built-in OAuth2 connections for Zoho CRM and Google Ads. They can be accessed via the Connection Manager (Add-ons > API Connector > Manage Connections). Please try them out and let us know if you have any feedback or questions. Connec...

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

You can now store a complete log of your API requests and whether they completed successfully or not. This is useful for troubleshooting scheduled requests or identifying issues when you run a batch of requests together. The log contains the timestam...

Working with APIs often requires looping through a set of endpoints to collect all the data you need, so API Connector provides the ability to "stack" request URLs and cycle through them as a block. While stacking URLs works for GET requests, we've n...

If you check any API documentation, you'll likely notice many APIs provide sample requests as curl commands, which is a method of interacting with APIs via the command line. You can now copy and import these curl commands directly into API Connector ...

This feature lets you print your request URL into your response sheet. This is useful in cases where the request URL itself contains some important metadata that isn't available from the API response. For example, consider the URL https://api.com/v2/...

Most APIs let you connect through an API key, which is like a password. However, some APIs only allow connecting through OAuth2, which is a more secure (and complex) method of authentication/authorization that works through a process of exchanging an...

This much-requested feature allows you to set the order that triggers execute, so you can run scheduled requests in a sequence. Example use cases: Get a fresh access token, and then use that token to populate your request URL Pull a list of new playe...

JSON API responses typically contain nested tree-like data rather than the flat row-column output used in spreadsheets. Therefore the API Connector add-on provides several built-in algorithms to convert JSON responses into a tabular format for Google...

Basic authentication is a simple API authentication scheme that works by adding a Header Key of "Authorization", and a Value of "Basic + username:password", where username:password is encoded to base 64. I noticed a few authentication-related error m...

Business plan users can now choose to refresh their requests on a 1, 3, 6, or 12 hour basis. These new options are useful for cases where requests need to be triggered more frequently than daily but not as often as every hour. As a best practice, alw...

In general, GET is for getting data into your sheet (makes sense). POST is for creating new records, and PUT is for updating data that already exists. There are already some interesting use cases for this; one of API Connector's users messaged me to ...

API Connector now supports OAuth 2.0 integrations for Business plan users. OAuth2 integrations have been enabled for Github, Harvest, and Quora Ads (more platforms coming soon). Why OAuth2? While most APIs enable access through API keys, there are qu...

When running requests, it can be useful to run through a list of cells to hit different endpoints. For example, if you were querying stock quotes, you may have to hit a different endpoint for each request, like this: /api/quote/AAPL /api/quote/GOOG /...

This is the place for you to discuss APIs, Google Sheets, and our add-ons for Google Sheets: API Connector and Archive Data.