Hi, guys! I'm new using airbyte. I'm trying to mak...
# replication-troubleshooting
a
Hi, guys! I'm new using airbyte. I'm trying to make a connection between Facebook Marketing and BigQuery but whenever I try to bring the AdCreative table I get the error of "Too many calls to this ad account". Is there any path I can follow to overcome this problem?
n
Hi Arthur! Is there an error code you're getting in the logs? It sounds like you may have hit the API limit for your account. Attach the full logs if you can please.
a
Yes, but I am trying to pull only one day of one table, it should not reach the limit of requests. The logs below:
a
@Artur Vemado your current batch size is 200? you need to change it to 50
a
You mean the "Maximum Size of batched request"? If so, it is already set to 50
a
can you change it to 10?
👍 1
a
I tried, but the limit is already reached. I have to wait now.
👍 1
Tried with 10 and still giving the same message.
Please, help!
n
Are you able to ping the Facebook Marketing API with something else, for example curl?
a
I don't think that the problem is with Facebook API, because we can fetch the data using Funnel. And the error occurs only when I try to fetch the AdCreative table.
n
And the AdCreative table is in BigQuery?
a
Yes
It actually brought some data, but threw errors.
u
OK, then you need to try and ping it using another method outside of Airbyte to double check that it's accessible. If you're still getting a rate limit error, I would look into your BigQuery configuration.
a
I can get the same data with Funnel. Maybe Airbyte is not handling the limit very well. Besides that, what difference does it make to have a standard access account and an advanced access account in Facebook, when using airbyte open source?
n
Could you please clarify what Funnel is? I am not familiar with it. Are you saying you’re not getting the rate limit error with a different tool?
a
n
I see! I've found an older GitHub issue regarding rate limiting, I think we might need more documentation on it: The user states that unless you have advanced API access, you'll run into this. https://github.com/airbytehq/airbyte/issues/10898 Let me get feedback from the team on this, but it might be a current limitation of the connector right now.
Also, looking through the documentation for this connector I see: 1. Request a rate increase limit: Facebook heavily throttles API tokens generated from Facebook Apps with the "Standard Access" tier (the default tier for new apps), making it infeasible to use the token for syncs with Airbyte. You'll need to request an upgrade to Advanced Access for your app on the following permissions: ◦ Ads Management Standard Access ◦ ads_read ◦ Ads_management 2. See the Facebook documentation on Authorization to request Advanced Access to the relevant permissions. Have you requested a rate limit increase?
a
I have seen this, but as we did not need this for the Funnel tool, we expected to not need this using airbyte. But we will try to request this limit. As soon as we do that and test the tool, I come back here.
Thank you for the information. I appreciate it a lot.
n
No problem!
s
Hey @Artur Vemado, did you mange to upgrade to Advanced Access? Could you help me out with the application, get rejected every time..
r
hey! What type of recording should I upload so that I can authorize advanced access if I have data via airbyte?
b
@Artur Vemado @Sebastian Sundet Flaen, any success on the app review? I'm going through difficulties here too.
r
Folks have you any sucess here? I am facing too the same problem
b
@Raphael Castilho Gil are you by any chance also stuck in the loop of Tech Provider Access Verification? I opened this issue because, if I understand the situation correctly, there is no solution on the applicant's behalf: https://github.com/airbytehq/airbyte/issues/35930
r
Same problem here @Bruno Pini