Downloading File From Google Drive

[ketangp28686788]

Hi,

    Is there any way to download file from google drive and use in data loading ?

    l Web download would work in that scenario ?

    If Yes, please elaborate the required steps.

Thanks 

[Vipul_Raghav]

Hi Ketan,

If the file is accessible from your Google Drive by a simple Get request, then yes you can make use of Web Download feature.

Regards,vipul

[ketangp28686788]

Hi Vipul,

        I Tried the web download method using GET googleapi, but getting following error.

 28/02/2017 18:00:28    HTTP reply 403: Forbidden -  The server understood the request, but is refusing to fulfill it

28/02/2017 18:00:28    Starting transfer of 'https://www.googleapis.com/drive/v3/files/0B1P0VH6_U4gxbVlmZW41UEI5c' to '0B1P0VH6_U4gxbVlmZW41UEI5c_20170228123028a.html'

[Vipul_Raghav]

Please check the access settings for this file.

HTTP 403 means that the call is not allowed to be processed. 

[Vipul_Raghav · Accepted solution]

Hi Ketan,

If I fire your URL in my browser, I observe the same problem. This is the response received

{ "error": { "errors": [ { "domain": "usageLimits", "reason": "dailyLimitExceededUnreg", "message": "Daily Limit for Unauthenticated Use Exceeded. Continued use requires signup.", "extendedHelp": "https://code.google.com/apis/console" } ], "code": 403, "message": "Daily Limit for Unauthenticated Use Exceeded. Continued use requires signup." } }

It seems you have not enabled public access on this file.