![]() Basically you can create or open Google Sheet and add the Service Account as an editor to it as below. Now last thing is give read/write permission to Service Account. ![]() ![]() Now you may use downloaded *.p12 key file as secret file and Service Account Email as Client ID (e.g.We will use this file in our API connection. A P12 key file is downloaded to your computer. Click Add key, then click Create new key.In the Cloud Console, click the email address for the service account that you created.Once service account is created we need to create key file (i.e. For Role, do not select anything for now and Click Continue and then click Done.Enter Service account name and Service account description.Service account has its ID which looks like some email ID (not to confuse with Google /Gmail email ID) Once Project is created and APIs are enabled we can now create a service account under that project. Now we need to Enable two APIs one by one (Drive API).Skip this section if you already have Project (Go to next section) Learn more about service account hereīasically to call Google API as Service account we need to perform following steps listed in 3 sections (Detailed steps found in the help link at the end)įirst thing is create a Project so we can call Google API. Use these steps to authenticate as service account rather than Google / GSuite User. You can use this information now to configure Connection with UseCustomApp=true.įill in all required parameters and set optional parameters if needed: When prompted Select Application Type as Desktop App and click Create to receive your ClientID and Secret.Click CREATE CREDENTIALS (some where in topbar) and select OAuth Client ID option.Go to back to main screen of Google API Console.Now we need to enable Google Drive API.Once project is created you can click Select Project to switch the context (You can click on Notification link or Choose from Top Dropdown).From the Project Dropdown (usually found at the top bar) click Select Project.To register an App, perform the following steps (Detailed steps found in the help link at the end): Then just move to "My Drive" somewhere and Tableau has the permission.To make this work you will have to create an OAuth application. The file owner can transfer the ownership to this Google account so that this Google account has the "Move to" permission.Then Tableau has the permission connecting to this copy file under this Google account. Choose "Make a copy" and move the copy to "My Drive" somewhere.If the "Move to" is disabled, this Google account has insufficient permission and as a result, Tableau has insufficient permission when connecting to this file under this Google account.Ģ. Under Google Drive, right click the file from "Shared with me". You may receive this error message above also when the Google account have insufficient permission if the file is shard from another place. Contact the external site for answers to questions regarding its content. *Although we make every effort to ensure links to external websites are accurate, up to date, and relevant, Tableau cannot take responsibility for the accuracy or freshness of pages maintained by external providers. Google Drive rest api v3 file export error.Google Drive Rest Api Files export limitation.其他資訊For additional information about this limitation, refer to the third party links below*. The Google account has insufficient permission of this file.Google's API does not permit connecting to files larger than 10MB.Grant permission of this file for this Google account. For example, consider copying the sheet(s) you want to connect to into a new workbook that doesn't contain any large sheets. 解決方法Reduce the size of the file you are connecting to. 問題When you try to connect to Google Drive, the following error occurs:Īn error occurred while communicating with Microsoft Excelīad Request: The data source does not contain the expected data.Įrror Code: A7AE75CC Google Drive has rejected this request because of insufficient permissions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |