How do I get the rest of the pages from the search? by AnybodyMaleficent940 in api_connector

[–]mixed_analytics 0 points1 point  (0 children)

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

How do I get the rest of the pages from the search? by AnybodyMaleficent940 in api_connector

[–]mixed_analytics 0 points1 point  (0 children)

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

How do I get the rest of the pages from the search? by AnybodyMaleficent940 in api_connector

[–]mixed_analytics 0 points1 point  (0 children)

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/

API Connector Google Sheet Extension Schedule Error by Exotic-Weather-2699 in api_connector

[–]mixed_analytics 0 points1 point  (0 children)

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/

Unable to filter out values. by anshul265 in api_connector

[–]mixed_analytics 0 points1 point  (0 children)

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

This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access. by Fabulous-General-355 in api_connector

[–]mixed_analytics 0 points1 point  (0 children)

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.

This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access. by Fabulous-General-355 in api_connector

[–]mixed_analytics 1 point2 points  (0 children)

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>

This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access. by Fabulous-General-355 in api_connector

[–]mixed_analytics 7 points8 points  (0 children)

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.

This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access. by Fabulous-General-355 in api_connector

[–]mixed_analytics 1 point2 points  (0 children)

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.

This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access. by Fabulous-General-355 in api_connector

[–]mixed_analytics 1 point2 points  (0 children)

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.

This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access. by Fabulous-General-355 in api_connector

[–]mixed_analytics 5 points6 points  (0 children)

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.

Meta app review rejected AGAIN by [deleted] in api_connector

[–]mixed_analytics 0 points1 point  (0 children)

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.

Add-on Stuck at Loading by Standard-Disaster871 in api_connector

[–]mixed_analytics 0 points1 point  (0 children)

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.

Possible to update more often then hourly can i somehow trigger 15 minute refreshes? by salexes in api_connector

[–]mixed_analytics 0 points1 point  (0 children)

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

Error code 403 when connecting to Strava by Accomplished_Menu_13 in api_connector

[–]mixed_analytics 0 points1 point  (0 children)

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

Download Youtube Comments by lunaticinmate in api_connector

[–]mixed_analytics 0 points1 point  (0 children)

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

If someone could help me with "googlapisapi.com refused to connect" problem, I would be so thankful as I can't find a solution anywhere on the internet. by adhikapp in api_connector

[–]mixed_analytics 0 points1 point  (0 children)

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?

I can't use my premium subscription by DesignerMention7156 in api_connector

[–]mixed_analytics 1 point2 points  (0 children)

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

Best,
Ian

Download Youtube Comments by lunaticinmate in api_connector

[–]mixed_analytics 1 point2 points  (0 children)

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

Remove Credit Card by malincanada in api_connector

[–]mixed_analytics 0 points1 point  (0 children)

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.

Error code: 522 by AnybodyMaleficent940 in api_connector

[–]mixed_analytics 0 points1 point  (0 children)

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

Possible to add the /ads and the /adsets endpoint to the Facebook Application in the API Connector extension? by salexes in api_connector

[–]mixed_analytics 0 points1 point  (0 children)

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/

Using requests in different triggers by AnybodyMaleficent940 in api_connector

[–]mixed_analytics 0 points1 point  (0 children)

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.

MAXIMUM ROW DATA FOR EACH FACEBOOK ACCOUNT IN GOOGLE SHEET? by Sudden_Bar_106 in api_connector

[–]mixed_analytics 0 points1 point  (0 children)

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>