function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Ben SilvermanBen Silverman 

Validating External Data Source

I am receiving an error when attempting to validate an external data source (Google Drive) in our sandbox so I can create an external object. For some reason I do not have permission to do this, even though I am a system administrator. The error appears under the Status field and shows "You are not authorized to perform that operation." Any advice anyone could provide me would be greatly appreciated!
venkat-Dvenkat-D
Do you have right permision in the external data source? You need to have acces on both if Im not wrong.
Ben SilvermanBen Silverman
Do you know where I would allow this access? When I press the Validate and Sync button, the status appears as “You are not authorized to perform that operation”. I do appreciate your guidance!
venkat-Dvenkat-D
Also go to My Settings>  Personal > Authentication settings for exernal systems. There provide your credentials for third party system. I just tried connections once with SFDC to SFDC and it worked fine. 

Also refer to https://help.salesforce.com/HTViewHelpDoc?id=admin_files_connect_google_xds.htm
Ben SilvermanBen Silverman
I think I am on the right track. I found that and the user name column is blank. When I press edit, there is no place for me to fill in my G Drive username. Where can I do this?
venkat-Dvenkat-D
Select Authentication Identify Type as Per User
Ben SilvermanBen Silverman
I have always had the identity type as “per user”. Is it possible that this is happening because I am doing this in a sandbox?
venkat-Dvenkat-D
can you post here screenshot ?
Ben SilvermanBen Silverman
User-added imageUser-added imageUser-added image
venkat-Dvenkat-D
As told in my previous post, did you setup My Settings>  Personal > Authentication settings for exernal systems.
venkat-Dvenkat-D
Long shot, just check if you have to enable some settings in google Drive to access it with OAuth2.0. I do not have drive enabled in my sandbox so this is my final try. :)
Ben SilvermanBen Silverman
I got it! I redid the entire setup of the external datasource and turns out I only entered the URL piece of this line: Default Scopes—Enter openid email profile https://www.googleapis.com/auth/drive. Thanks for taking the time to help me with this!
Bill FlorioBill Florio
Hi I'm getting the same error as above but unfortunatley the default scopes trick did not work for me.  Anyone have any ideas around what else would prevent the Validate and Sync button to fail?
Inderjit Singh WaraichInderjit Singh Waraich
I am getting same error, may i know how it was resolved.
Kai WilliamsKai Williams
I eventually resolved this error with aid from https://help.salesforce.com/articleView?id=000220146&type=1  Even though I initially did select the Drive API and created all my credentials, it appears the credentials were saved without the Drive API. Going back to Google and (re)Enabling the Drive API for the project resolved the error.    Of course upon getting everything working I discovered that Team Drive files aren't viewable - just my personal Google Drive files.   If you need Team Drive access consider upvoting https://success.salesforce.com/ideaView?id=0873A000000CSZSQA4