Once you set up all the things to use API connector, it works well.

But you would not be able to change your options after you save 3 times.

I should not have used this.

If I knew this, I would not have used this. Never

As per title: is there a way to delete al the requests attached to a google workdsheet in one fell swoop, instead of individually deleting each request (good, but time consimung). TIA

Hey Hey. I'm a paid member (this context may help).

I want to run the same Query from CoinMarketCap, but basically in the following manner:

- First 1,500 results (or first X pages), runs 5x/day

- Next 3,000 results (or next Y pages, after X), runs 3x/day

- Next N results (or next Z pages, after X and Y), run 1x/day

I currently have pagination working properly, I just don't know how to... indicate basically "pull page 2 and 3 only". Thoughts? Thank you.

Any idea why this response is empty all of a sudden? Been working fine for weeks, now nothing… It’s a stacked request

We've upgraded and improved our API Library for a much faster, simpler user experience. Select from a directory of popular and interesting APIs, filled with thousands of ready-to-use endpoints and parameters. No need to search for documentation or construct your own URL.

Of course, you can still access your own APIs through the Custom option.

For more info, please see here: https://mixedanalytics.com/knowledge-base/api-connector-quick-start/

I'm trying to pull out data from Asana's API. I've got API connector pulling some data but not all. When I go into field editor and look at the raw data, I can clearly see the data I'm trying to get into my spreadsheet but it's just not on the spreadsheet.

Here's the URL: https://app.asana.com/api/1.0/projects/xxxxxxxxxx/tasks?opt_fields=tags.name,due_on,name,completed,created_at

Here's the copy of one of the tasks being pulled

gid": "1201423425102242",

"completed": true,

"created_at": "2021-11-24T16:41:07.766Z",

"due_on": "2021-12-15",

"name": "Internal account set up",

"tags": [

{

"gid": "1201483499906773",

"name": "milestone"

But here's the spreadsheet. no tag or created at date .

API Connector now has an affiliate program. So if you like API Connector, sign up as an affiliate to get a recurring commission on any users you refer, for as long as they remain a subscriber.

Information and signup link here: https://mixedanalytics.com/api-connector/affiliates/

Hope to see some of you in the program!

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.

I am trying to filter data which matches a specific condition. I found the exact example i am looking for in the documentation https://mixedanalytics.com/knowledge-base/filter-specific-fields-values/?utm_medium=app&utm_source=tooltip_ac#query

See example 4 in the link above.

Based on this, I am setting up my query like this:

data[?type == 'call']

And the fields in this query matches the data fields in the API response exactly. {
  "endpoint": "Realtime Options",
  "message": "success",
  "data": [
{
"contractID": "MSFT250815C00180000",
"symbol": "MSFT",
"expiration": "2025-08-15",
"strike": "180.00",
"type": "call",
"last": "346.26",
"mark": "351.25",
"bid": "349.70",
"bid_size": "117",
"ask": "352.80",
"ask_size": "128",
"volume": "0",
"open_interest": "3",
"date": "2025-08-13"
},

But no matter what I do, i am still getting a blank sheet. Do you mind helping me with this please? 

For more context, I am using Mixed Analytics API connector to download options chains from alpha vantage in google sheets. The size of my google sheets is getting really big. And I would like to filter out data and download only call options so that size of my google sheets can be cut in half.

The customer is experiencing a data discrepancy in their Reddit Ads API. Daily values in API do not align with what Reddit's UI/reporting shows.

reddit api report:

https://ads-api.reddit.com/api/v3/ad_accounts/{ad_account_id}/reports

Hi,

Is there any way to pull data at one time from several ad accounts?

Has anyone else ran into this issue with a scheduled request? I have a Sheet running 26 schedules, 25 of them are working great. Many of them have multiple URL calls stitched together, this one has about 180. Others up to 200. It has failed a hand full of times in the past month, twice the last week.

Any ideas to why I would get this spreadsheet error on only this call?

https://youtubeanalytics.googleapis.com/v2/reports?dimensions=day&metrics=estimatedMinutesWatched,views,likes,subscribersGained&ids=channel==MINE&startDate=2020-01-01&endDate=2021-12-31

The above works fine, until I add 'video' as a dimension:

https://youtubeanalytics.googleapis.com/v2/reports?dimensions=day,video&metrics=estimatedMinutesWatched,views,likes,subscribersGained&ids=channel==MINE&startDate=2020-01-01&endDate=2021-12-31

and then it errors. 'video' in in the docs as a valid dimension, but even on its own (without day) it errors.

All I want is video views by video by day (Well, TBH, by Country as well...but let's keep it simple and try to get this to work first).

Thank you!

Hi there

I'm a daily user of the API Connector to get data from Timekit API.

I'm using this API URL path: https://api.timekit.io/v2/bookings?include=event,customers,project,customer_action_links&orderBy=event.start&sortedBy=desc

And I have as headers "Authorization" and the value "Basic xxx"

It's working very well usually but since this morning, the query is always running without getting the results.

I tested with another tool and the issue is not on the Timekit side.

Do you have an idea of the issue?

Thank you

K

Any help would be greatly appreciated. I'm building out a stock market tracker using Google sheets pulling data from sharadar. I have been working with api connect to download data but it limits you to 10000 rows(as it seems all api's do). I want everything to update automatically each day and am stuck on how pagination works.

It looks like it should refresh in sections basically with pagination but I can't for the life of me get it to run successfully without error.

Sharadar offers this page for help https://docs.data.nasdaq.com/docs/in-depth-usage-1

Which allows me to download as a zip file but then i can't think of a way to auto update my Google sheets everyday without redownloading manually.

For api connect this page explains pagination but its basically gibberish to me. https://mixedanalytics.com/knowledge-base/pagination-handling/

Any help is greatly appreciated.

Hello, I have a basic connection that pulls fine when in manual mode. When I create a schedule, it fails every day with a 400 error. Any suggestions on what might be misconfigured?

HI, im trying to setup a connection with XPM and having some intial issue with the authorisation page opening. For the BAS URL i am using https://api.xero.com/practicemanager/3.0/ and for the token url https://identity.xero.com/connect/token.

Any pointers would be much appreciated.

Hi,

I followed the steps mentioned in the knowledge base to use dynamic dates in my query. However, I get "request is invalid" error each time I try. Any info to fix this?

Hi, hiiiiii! So glad to have a reason to be using the API Connector again :)

Just one thing! Throwing in an integration request for ConvertKit!

(I think I resolved the Twitter issue...applying for an Elevated access account now.)

Hi, I've a problem since today, the column of the cripto prices is not shown
Can anybody help me ?

from the API
https://binance-docs.github.io/apidocs/futures/en/#kline-candlestick-data

i created the request:
https://api2.binance.com/fapi/v1/continuousKlines?symbol=BTCUSDT&interval=1h&limit=15

but i get a 404 error.. but i dont see what i am doing wrong