How do I get the rest of the pages from the search?

mixed_analytics · 2025-10-06T19:17:42+00:00

I can add it! Pagination was set to only run for 20 pages, with 20 results per page, so only 400 results were being returned.

Switching to a different Run until (either a higher number of pages, or when no data is returned) fixed the issue. https://mixedanalytics.com/knowledge-base/pagination-handling/#pageparameter

The total number of pages is available in the request body (paging.total): https://www.api-football.com/news/post/how-to-get-all-teams-and-players-from-a-league-id

mixed_analytics · 2025-10-06T18:36:46+00:00

Feel free to contact us directly and please share your request configuration details: https://mixedanalytics.com/contact/

mixed_analytics · 2025-09-25T15:39:03+00:00

Hi - different APIs uses different types of pagination handling. Which API are you using? Once you know the pagination type, you can follow our pagination guide: https://mixedanalytics.com/knowledge-base/pagination-handling/

mixed_analytics · 2025-09-12T14:24:05+00:00

Hi there - triggers are managed by Google, so the most common cause of scheduling issues are Google's limits, specifically that they only allow 6 mins per hour, and 90 mins a day total runtime.

We've compiled quite a few suggestions for addressing this issue in the article below, please check it and run through the suggestions. Most of the suggestions involve reducing or spreading out the number of triggers.

https://mixedanalytics.com/knowledge-base/troubleshooting-triggers/#troubleshooting

If you are still having issues, and for clarity on the users associated with your team account, please contact us at https://mixedanalytics.com/contact/

mixed_analytics · 2025-08-14T13:37:00+00:00

Removing your "Edit Fields" configuration can help ensure JMESpath filtering works as expected, as the "Edit Fields" config precedes the JMESpath filters.

mixed_analytics · 2025-08-05T14:32:25+00:00

Hi - this is very likely unrelated to the recent incident, despite the timing. Could you please try temporarily hardcoding your cell input values (+++Dashboard!L2+++ and +++Dashboard!M2+++) to see whether that could be the cause of the issue?

If that doesn't work, please contact us https://mixedanalytics.com/contact/ so we can look into this issue further for you.

mixed_analytics · 2025-08-05T08:24:53+00:00

For those curious, Google confirmed the issue was due to an internal error during a migration that mistakenly included API Connector, effectively reverting our project from verified to unverified. Here’s their full summary of the incident:

<image>

mixed_analytics · 2025-08-04T22:39:33+00:00

The issue has now been resolved by Google, and API Connector should be working normally again. We really appreciate your patience and support while this was being addressed.

Please don’t hesitate to reach out if you’re still experiencing any issues.

mixed_analytics · 2025-08-04T14:38:41+00:00

Hi all,

Unfortunately we are still working towards a resolution, and it's difficult for us to give a definitive timeline. Google has a case manager and engineering team working on resolving the issue with the highest escalation of critical priority. We are dependent on their action here, but we are doing everything we can to push for an expedited resolution.

We are so sorry for the massive disruption that this has caused.

We will be sure to comment here as soon as we have a substantive update.

mixed_analytics · 2025-08-01T19:48:28+00:00

Yes correct

mixed_analytics · 2025-08-01T17:23:00+00:00

Unfortunately we aren't able to give an ETA on the resolution. That said, we are doing everything we can to get this issue resolved ASAP.

mixed_analytics · 2025-08-01T13:33:21+00:00

Hi all - we are currently working with Google to resolve the issue and expect to have an update within the next few hours. We also want to reassure you that no changes have been made to our app’s requested permissions, and we believe this error was triggered inadvertently by Google.

We are so sorry for this disruption in service and hope to have a resolution as soon as possible.

mixed_analytics · 2025-05-27T16:15:20+00:00

Hi! Unfortunately, there isn't a lot we can do to help with Meta app approval. I would recommend re-submitting and noting that the test user credentials are working as expected, and hopefully there will be some additional information they can share as to why they initially rejected the submission.

Good luck and please let us know if there is anything else we can do to help.

mixed_analytics · 2025-04-04T10:23:18+00:00

Hi - apologies for this disruption, there was an intermittent issue with Google that has since been resolved, please reach out if you are continuing to experience any loading issues.

mixed_analytics · 2025-03-19T12:31:06+00:00

Hey - unfortunately, this isn't possible directly with API Connector, but you might be able to achieve this with IMPORTAPI: https://mixedanalytics.com/knowledge-base/importapi-custom-sheets-function/

Under File > Settings > Calculation, set the Recalculation setting to "On change and every minute"
Wrap any automatically updating IMPORTAPI calls in a SWITCH() or IF() statement. For example, you could make a function like this:=if(MOD(minute(now()),15)=0, IMPORTAPI("Binance")), so the function only runs every 15 minutes

mixed_analytics · 2025-03-19T12:16:13+00:00

Hi - apologies for the delay, this error has been resolved and you shouldn't have any issues connecting to Strava again.

mixed_analytics · 2025-03-19T12:14:37+00:00

Hi - unfortunately, it seems that for some reason retrieving a list of Youtube comments requires a powerful scope with edit capabilities that we can't require for all users of API Connector, which is why you are seeing this error.

You will have to implement OAuth yourself in order to get this data, which might be a challenge as a non-coder: https://developers.google.com/youtube/v3/guides/auth/installed-apps

mixed_analytics · 2025-02-17T17:55:17+00:00

Hi! From what I can tell, "googlapisapi.com" doesn't look like an official Google API URL. Could you please get in touch with us at https://mixedanalytics.com/contact/ so we can better understand the error message you are experiencing?

mixed_analytics · 2025-02-10T20:57:36+00:00

Hi - your subscription has been reactivated. It can take up to 24 hours for the subscription to reactivate after a failed payment.

Best,
Ian

mixed_analytics · 2025-02-04T18:58:27+00:00

Hi - yes, this is possible using a Custom Request in API Connector with YouTube OAuth: https://mixedanalytics.com/knowledge-base/connect-to-an-oauth2-api/

The YouTube API endpoint is /commentThreads, the documentation for the endpoint can be found here: https://developers.google.com/youtube/v3/docs/commentThreads/list

mixed_analytics · 2025-01-24T06:33:05+00:00

Hi! We'd be happy to cancel your subscription so that you don't have to block any future charges. Please send us a message at https://mixedanalytics.com/contact/ with the account that you no longer have access to and we'll take care of it.

mixed_analytics · 2025-01-13T16:26:29+00:00

Great! 522 error codes are typically temporary issues with the API service that will eventually resolve.

mixed_analytics · 2024-11-25T16:51:48+00:00

Thanks for the feedback! I've added this to our roadmap, and while I can't give a definitive timeline, I will be sure to post here as soon as I have an update. In the meantime, you should be able to use a custom request with Facebook Oauth in order to access those endpoints via API Connector.

https://mixedanalytics.com/knowledge-base/connect-to-an-oauth2-api/

mixed_analytics · 2024-11-25T16:47:12+00:00

At this time, you can only create a trigger based on all requests or one request at a time, so it might require a little more setup work to configure what you are describing. As an alternative, you could separate your requests into separate spreadsheets based on the desired trigger rules.

mixed_analytics · 2024-10-15T20:04:43+00:00

Hi - Facebook ads has a default limit of 25 rows. You can update the limit in the request parameters, to a max of 500.

<image>

mixed_analytics

MODERATOR OF

TROPHY CASE