airbytehq / airbyte

The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
https://airbyte.com
Other
15.5k stars 3.99k forks source link

Source Facebook Pages: problem creating new source + printing access_token #9827

Closed marcosmarxm closed 1 year ago

marcosmarxm commented 2 years ago
## Environment - **Airbyte version**: 0.35.10-alpha - **OS Version / Instance**: macOS - **Deployment**: Docker - **Source Connector and version**: Facebook Pages 0.1.6 - **Destination Connector and version**: - - **Severity**: Very Low / Low / **Medium** / High / Critical - **Step where error happened**: Creating a new source ## Current Behavior ![image](https://user-images.githubusercontent.com/5154322/151254339-944a25df-cf9f-4a4e-82ff-6a3b9b80695d.png) Getting ERROR 400 ```` "HTTPError('400 Client Error: Bad Request for url: https://graph.facebook.com/v12.0/112704783733939?access_token=&fields=id%2Cabout%2Cad_campaign%2Caffiliation%2Capp_id%2Cartists_we_like%2Cattire%2Cawards%2Cband_interests%2Cband_members%2Cbio%2Cbirthday%2Cbooking_agent%2Cbuilt%2Ccan_checkin%2Ccan_post%2Ccategory%2Ccategory_list%2Ccheckins%2Ccompany_overview%2Cconnected_page_backed_instagram_account%2Ccontact_address%2Ccountry_page_likes%2Ccover%2Cculinary_team%2Ccurrent_location%2Cdelivery_and_pickup_option_info%2Cdescription%2Cdescription_html%2Cdifferently_open_offerings%2Cdirected_by%2Cdisplay_subtext%2Cdisplayed_message_response_time%2Cemails%2Cengagement%2Cfan_count%2Cfeatured_video%2Cfeatures%2Cfollowers_count%2Cfood_styles%2Cfounded%2Cgeneral_info%2Cgeneral_manager%2Cgenre%2Cglobal_brand_page_name%2Cglobal_brand_root_id%2Chas_added_app%2Chas_transitioned_to_new_page_experience%2Chas_whatsapp_business_number%2Chas_whatsapp_number%2Chometown%2Chours%2Cimpressum%2Cinfluences%2Cis_always_open%2Cis_chain%2Cis_community_page%2Cis_eligible_for_branded_content%2Cis_messenger_bot_get_started_enabled%2Cis_messenger_platform_bot%2Cis_owned%2Cis_permanently_closed%2Cis_published%2Cis_unclaimed%2Cis_webhooks_subscribed%2Cleadgen_tos_acceptance_time%2Cleadgen_tos_accepted%2Cleadgen_tos_accepting_user%2Clink%2Clocation%2Cmembers%2Cmerchant_review_status%2Cmessenger_ads_default_icebreakers%2Cmessenger_ads_default_page_welcome_message%2Cmessenger_ads_default_quick_replies%2Cmessenger_ads_quick_replies_type%2Cmission%2Cmpg%2Cname%2Cname_with_location_descriptor%2Cnetwork%2Cnew_like_count%2Coffer_eligible%2Coverall_star_rating%2Cpage_token%2Cparking%2Cpayment_options%2Cpersonal_info%2Cpersonal_interests%2Cpharma_safety_info%2Cphone%2Cpickup_options%2Cplace_type%2Cplot_outline%2Cpreferred_audience%2Cpress_contact%2Cprice_range%2Cprivacy_info_url%2Cproduced_by%2Cproducts%2Cpromotion_eligible%2Cpromotion_ineligible_reason%2Cpublic_transit%2Crating_count%2Crecord_label%2Crelease_date%2Crestaurant_services%2Crestaurant_specialties%2Cschedule%2Cscreenplay_by%2Cseason%2Csingle_line_address%2Cstarring%2Cstart_info%2Cstore_code%2Cstore_location_descriptor%2Cstore_number%2Cstudio%2Csupports_donate_button_in_live_video%2Ctalking_about_count%2Ctemporary_status%2Cunread_message_count%2Cunread_notif_count%2Cunseen_message_count%2Cusername%2Cverification_status%2Cvoip_info%2Cwebsite%2Cwere_here_count%2Cwhatsapp_number%2Cwritten_by%2Cagencies%2Calbums%2Cblocked%2Ccall_to_actions%2Ccanvas_elements%2Ccommerce_merchant_settings%2Cevents%2Cfeed%2Cglobal_brand_children%2Cgroups%2Cimage_copyrights%2Cindexed_videos%2Cinstagram_accounts%2Clikes%2Clive_videos%2Clocations%2Cnativeoffers%2Cpage_backed_instagram_accounts%2Cphotos%2Cposts%2Cproduct_catalogs%2Cpublished_posts%2Cratings%2Croles%2Crtb_dynamic_posts%2Cscheduled_posts%2Csettings%2Ctabs%2Ctagged%2Cvideo_lists%2Cvideos%2Cvisitor_posts')" ``` ## Expected Behavior *Tell us what should happen.* ## Logs Complete logs: [logs-96aba461-eb6e-42c6-b854-1e29d15ee51d.txt](https://github.com/airbytehq/airbyte/files/7945886/logs-96aba461-eb6e-42c6-b854-1e29d15ee51d.txt) ## Steps to Reproduce 1. create facebook pages using integration account creds 2. 3. ## Are you willing to submit a PR?

Remove this with your answer.

misteryeo commented 2 years ago

From @marcosmarxm - "I saw at least 3 users having problem with Facebook Pages"

For folks who experience this issue, please comment on this thread to help us prioritize this in upcoming sprints!

marcosmarxm commented 2 years ago
  1. 26-jan Yvonne Huang
  2. 23-dec iggy002
  3. 14-jan Madison Mae
marrocksd commented 2 years ago

I'm having this issue as well, very critical as we can't use it at all

marrocksd commented 2 years ago

I tried generating a token with all 32 permissions and It worked though I was told from the docs that only 4 permissions are needed

kelvingakuo commented 2 years ago

Running into the same problem here

YasmineBrut commented 2 years ago

I'm also having the same issue

kelvingakuo commented 2 years ago

I was able to create the connection. Turned out I needed almost admin access level for it to work.

However, I'm now running into the "printing access_token error". Seems to be a bug with the connector, no way to solve it

ghost commented 2 years ago

Same problem here as well.

cornjuliox commented 2 years ago

We're having issues with this as well.

adriennevermorel commented 1 year ago

We are having issues with this as well.

musman2013103 commented 1 year ago

I am having issue as well. same Error HTTPError('400 Client Error: Bad Request for url:

YowanR commented 1 year ago

Hi Folks, thanks for flagging this issue. We are actively monitoring it, but since this is an alpha connector, we are not prioritizing the issue at this time. As always, we welcome contributions from our community to resolve this problem. Thank you!

GitTH commented 1 year ago

I'm had issues with these fields and suggest they could be removed:

With those 6 removed, I can successfully query the API explorer with FB API versions 13/14/15 but v12 throws an error:

You are calling a deprecated version of the Ads API. Please update to the latest version: v14.0.

Duplicate issues: #20117

artem1205 commented 1 year ago

fixed in https://github.com/airbytehq/airbyte/pull/19788, please double check you use the proper long lived access token. (see the docs)