Unable to complete FB oAuth in Matillion -Snowflake AWS Instance

Matillion ETL
1

Hi,

 

We are trying to achieve oAuth for FB app of ours in matillion but it gives the below error:

 

Error Message:

Can’t Load URL: The domain of this URL isn’t included in the app’s domains. To be able to load this URL, add all domains and subdomains of your app to the App Domains field in your app settings.

 

Steps Followed:

  1. Added the apex domain and subdomain of the matillion endpoint in the "domains" section of the FB app.
  2. In Matillion, Under the credentials manager created a FB authentication method with client key and secret key.
  3. On click of "Authorize call back url" we get redirected to FB page which gives the above error.

Note: this is tried on the same browser and multiple tab while we are already logged in to FB account.

 

Please provide pointers if any.

 

Regards

 

 

 

2

Update:

 

Went through the Matillion Documentation:

Facebook 3rd Party OAuth Setup (matillion.com)

 

There was a Valid Oauth Redirect URL to be added in the Facebook Login Settings ( Left Pane of the Apps ).

 

Post the addition, when tried to authorize from Matillion, the earlier mentioned error was resolved.

 

Although a new Message surfaced:

 

Message:

Invalid Scopes: user_tagged_places, read_insights, manage_pages, ads_read, publish_pages, business_management, instagram_basic, instagram_manage_insights. This message is only shown to developers. Users of your app will ignore these permissions if present. Please read the documentation for valid permissions at: https://developers.facebook.com/docs/facebook-login/permissions

 

When clicked on "Okay" of the above message pop-up, the matillion authorization process remains stuck in "Waiting for response from service" state.

 

Do we need to do an App Review as suggested in the link below prior to Matillion oAuth process?

 

https://developers.facebook.com/community/threads/906590833029119/

 

Regards

 

 

3

Hi @persistentengteam​,

Did you copy and paste the Redirect URL from the Matillion screen (like below) into the Facebook app's "Valid OAuth Redirect URIs field"?

0694G00000GINnrQAH_0D74G000007jmzUSAQ
0694G00000GINnrQAH_0D74G000007jmzUSAQ568×125 2.45 KB

Also, are you using a dotted IP address, or a DNS name (like above)

Best regards,

Ian

4

Hi @ian.funnell​

Yes, that's been done and it proceeded to the next pop-up message mentioned in the Update post:

Message:

Invalid Scopes: user_tagged_places, read_insights, manage_pages, ads_read, publish_pages, business_management, instagram_basic, instagram_manage_insights. This message is only shown to developers. Users of your app will ignore these permissions if present. Please read the documentation for valid permissions at: https://developers.facebook.com/docs/facebook-login/permissions

If clicked on Okay, the matillion authorization process remains stuck in "Waiting for response from service" state.

Please advice.

Regards

5

Hi @persistentengteam​,

Thanks for confirming. It sounds like you may have hit the "Invalid Scopes" problem that we have in the Known Issues. Would you mind taking a look and see if that's it?

Best regards,

Ian

6

Thanks @ian.funnell​ for the pointer.

Unfortunately there's some more Invalid Scopes error shown post the change in url as suggested in the link of Known Issues provided in your response

Changes done as per post :

2020-05-13 - Invalid Scopes when you Create New App in Facebook

Facebook generates an error "Invalid Scopes: manage_pages, publish_pages" during the OAuth setup process.

This is because Facebook has removed or changed scopes (permissions) that Matillion tries to use.

You must adjust the URL presented by Facebook as follows:

Delete from the URL:

  • user_events%2Cuser_birthday%2Cuser_photos%2Cuser_videos%2Cuser_likes%2Cuser_hometown%2Cuser_location%2Cuser_tagged_places%2C
  • %2Cmanage_pages
  • %2Cpublish_pages

Add to the URL (immediately after scope=)

  • pages_messaging%2Cpages_show_list%2Cpages_manage_ads%2Cpages_manage_cta%2Cpages_manage_engagement%2Cpages_manage_instant_articles%2Cpages_manage_metadata%2Cpages_manage_posts%2Cpages_read_engagement%2Cpages_read_user_content%2C

Post this change we get the below error:

Invalid Scopes: pages_messaging, pages_manage_ads, pages_manage_cta, pages_manage_engagement, pages_manage_instant_articles, pages_manage_metadata, pages_manage_posts, pages_read_engagement, pages_read_user_content, read_insights, ads_read, business_management, instagram_basic, instagram_manage_insights. This message is only shown to developers. Users of your app will ignore these permissions if present. Please read the documentation for valid permissions at: https://developers.facebook.com/docs/facebook-login/permissions

Let us know your thoughts on this.

Regards