I&#39;m sorry if this is an obvious question, I&#39;m still pretty new to the API.
I&#39;m using the python drive api library, and trying to download a google spreadsheet as a csv.  
When I used files.get, it spat out a file with no downloadUrl, and with no &#39;text/csv&#39; key in the export links field.  
If it&#39;s not possible, I can find a workaround, but I&#39;m hoping it is, since it is possible to do manually (file-&gt;download_as-&gt;csv)

Do I need to use the google document list api?

thanks,
Matt

Using the google drive API to download a spreadsheet in csv format

I have a folder in Google Drive that I&#39;d like to embed in my website. I can&#39;t find an embed code or anything documented in Google Drive Help articles.

How to embed a Google Drive folder in a website

Is there a API for Google Keep? I want to make a windows 8 app for Google Keep, so that it synchronizes with your phone. 

I looked into the Drive SDK because Google Keep is a extension of Google Drive, but I couldn&#39;t find it. 

Is there a Google Keep API?

I have made a page in html5 with css3. It works fine on local (I dont use any server, just doubleclick in the index to open it).  
I want to put it in google drive. I have load all the documents needed, but when I try to open the html, I can only see the text (I mean, it is not being executing, I can see just the source code).
Any suggestion?

opening html from google drive

There are methods to sync my local git repository over to my google drive via google drive sync windows application, but I was wondering whether I could bypass its need altogether. 

Fro eg. 

    $ git remote add origin https://drive.google.com/&lt;my_folder&gt;/&lt;my_repository&gt;.git
    $ git push github master


Can I push/pull directly from my google drive online?

I&#39;m not a programmer, just a regular user of Google Drive. I want to see if the files are uploaded correctly. I go through a whole process in the OAuth 2.0 Playground that lists all files, shows the MD5 checksums but also lots of information per file. If I upload a new file it&#39;s hard to search for it and verify its md5 checksum.

Is there an easier way (through an app, maybe?) to show/list MD5 checksums for the uploaded files? I wonder why the Details pane doesn&#39;t have it, only lists the file size in bytes.

Google Drive MD5 checksum for files

Is it possible to number the headings in a Google Docs/Drive document?

How to number the headings in a Google Docs/Drive document?

A client of mine has uploaded some photos to their [Google Drive][1] and would like me to display their photos on their company website. I reviewed the [documentation][2] for displaying Google Drive content on a web page, but it appears that this is simply the instructions for displaying the contents on a web page, which it already does.

My question is, how do I display the contents directly on the client&#39;s web page?

  [1]: https://docs.google.com/folder/d/0B4QTOLODWzqaRFpxcWk3TjgtTEk/edit?pli=1
  [2]: https://developers.google.com/drive/publish-site

How do I display images from Google Drive on a website?

I&#39;m trying to download a file from google drive in a script, and I&#39;m having a little trouble doing so. The files I&#39;m trying to download are [here](https://drive.google.com/folderview?id=0Bz-w5tutuZIYeHJTWjR5WW1pa1E&amp;usp=sharing).

I&#39;ve looked online extensively and I finally managed to get one of them to download. I got the UIDs of the files and the smaller one (1.6MB) downloads fine, however the larger file (3.7GB) always redirects to a page which asks me whether I want to proceed with the download without a virus scan. Could someone help me get past that screen?

Here&#39;s how I got the first file working - 

    curl -L &quot;https://docs.google.com/uc?export=download&amp;id=0Bz-w5tutuZIYeDU0VDRFWG9IVUE&quot; &gt; phlat-1.0.tar.gz

When I run the same on the other file, 

    curl -L &quot;https://docs.google.com/uc?export=download&amp;id=0Bz-w5tutuZIYY3h5YlMzTjhnbGM&quot; &gt; index4phlat.tar.gz

I get the the following output -
[![enter image description here][1]][1]

I notice on the third-to-last line in the link, there a `&amp;confirm=JwkK` which is a random 4 character string but suggests there&#39;s a way to add a confirmation to my URL. One of the links I visited suggested `&amp;confirm=no_antivirus` but that&#39;s not working.

I hope someone here can help with this!


  [1]: http://i.stack.imgur.com/Szcq2.jpg

wget/curl large file from google drive

I have a rather large Android app that relies on many library projects. The Android compiler has a limitation of 65536 methods per .dex file and I am surpassing that number. 

There are basically two paths you can choose (at least that I know of) when you hit the method limit.

1) Shrink your code

2) Build multiple dex files ([see this blog post](http://android-developers.blogspot.se/2011/07/custom-class-loading-in-dalvik.html))


I looked into both and tried to find out what was causing my method count to go so high. The Google Drive API takes the biggest chunk with the Guava dependency at over 12,000. Total libs for Drive API v2 reach over 23,000!

My question I guess is, what do you think I should do? Should I remove Google Drive integration as a feature of my app? Is there a way to shrink the API down (yes, I use proguard)? Should I go the multiple dex route (which looks rather painful, especially dealing with third party APIs)?


How to shrink code - 65k method limit in dex

Let&#39;s say that I have a web app (&quot;mydriveapp&quot;) that needs to access Drive files in a background service. It will either own the files it is accessing, or be run in a Google Account with which the owner has shared the documents. 

I understand that my app needs a refresh token, but **I don&#39;t want to write the code to obtain that** since I&#39;ll only ever do it once.

**NB. This is NOT using a Service Account.** The app will be run under a conventional Google account. Service Account is a valid approach in some situations. However the technique of using Oauth Playground to simulate the app can save a bunch of redundant effort, and applies to any APIs for which sharing to a Service Account is unsupported.



How do I authorise an app (web or installed) without user intervention?

I am trying to download files from google drive and all I have is the drive&#39;s URL.

I have read about google API that talks about some `drive_service` and `MedioIO`, which also requires some credentials( mainly JSON `file/OAuth`). But I am unable to get any idea about how it is working. 

Also, tried `urllib2.urlretrieve`, but my case is to get files from the drive. Tried `wget` too but no use.

Tried `PyDrive` library. It has good upload functions to drive but no download options.

Any help will be appreciated.
Thanks.

Python: download files from google drive using url

So I&#39;m using RStudio and storing my files on Google Drive (the version with folders on your system, acting like Dropbox). I&#39;m using it because it provides a lot more space for free than Dropbox, and I need that space for the projects I&#39;m working on.

When I attempt to write any document at all -- an R script, an RMarkdown file, etc... -- I get the error mentioned in the title. This doesn&#39;t happen using Dropbox. I have found answers for this question for Dropbox, but the solution (tell Dropbox not to sync the Rproj file) doesn&#39;t seem applicable to Google Drive (if it is, please correct me). 

Currently, I&#39;m pausing Google Drive, which is fine, but I often forget to resume it and that causes headaches.

Thanks for your help!

Rstudio and Google Drive Syncing Problems: &quot;The process cannot access the file because it is being used by another process&quot;

I have an Android app that stores my notes in [hidden app data][1]. I want to export my notes so the question is simple:   

How can I access the hidden app data in Google Drive for a specific app? 


  [1]: https://developers.google.com/drive/web/appdata

How can I see hidden app data in Google Drive?

I am trying to automate the `GoogleAuth` process when using the `pydrive` library (https://pypi.python.org/pypi/PyDrive).

I&#39;ve set up the pydrive and the google API such that my `secret_client.json` works but it requires web authentication for gdrive access every time i run my script:

    from pydrive.auth import GoogleAuth
    from pydrive.drive import GoogleDrive
    
    gauth = GoogleAuth()
    gauth.LocalWebserverAuth()
    
    drive = GoogleDrive(gauth)
    
    textfile = drive.CreateFile()
    textfile.SetContentFile(&#39;eng.txt&#39;)
    textfile.Upload()
    print textfile
    
    drive.CreateFile({&#39;id&#39;:textfile[&#39;id&#39;]}).GetContentFile(&#39;eng-dl.txt&#39;)

`eng.txt` is just a textfile. Moreover when I try to use the above script while I am logged into another account. **It doesn&#39;t upload the `eng.txt` into my gdrive that generated the `secret_client.json` but the account that was logged in when I authorize the authentication**

From the previous post, I&#39;ve tried the following to automate the verification process but it&#39;s giving error messages: 

    import base64, httplib2
    from pydrive.auth import GoogleAuth
    from pydrive.drive import GoogleDrive
    
    from apiclient.discovery import build
    from oauth2client.client import SignedJwtAssertionCredentials
    from pydrive.auth import GoogleAuth
    from pydrive.drive import GoogleDrive
    
    #gauth = GoogleAuth()
    #gauth.LocalWebserverAuth()
    
    # from google API console - convert private key to base64 or load from file
    id = &quot;464269119984-j3oh4aj7pd80mjae2sghnua3thaigugu.apps.googleusercontent.com&quot;
    key = base64.b64decode(&#39;COaV9QUlO1OdqtjMiUS6xEI8&#39;)
    
    credentials = SignedJwtAssertionCredentials(id, key, scope=&#39;https://www.googleapis.com/auth/drive&#39;)
    credentials.authorize(httplib2.Http())
    
    gauth = GoogleAuth()
    gauth.credentials = credentials
    
    drive = GoogleDrive(gauth)
    
    drive = GoogleDrive(gauth)
    
    textfile = drive.CreateFile()
    textfile.SetContentFile(&#39;eng.txt&#39;)
    textfile.Upload()
    print textfile
    
    drive.CreateFile({&#39;id&#39;:textfile[&#39;id&#39;]}).GetContentFile(&#39;eng-dl.txt&#39;)

Error:

    Traceback (most recent call last):
      File &quot;/home/alvas/git/SeedLing/cloudwiki.py&quot;, line 29, in &lt;module&gt;
        textfile.Upload()
      File &quot;/usr/local/lib/python2.7/dist-packages/pydrive/files.py&quot;, line 216, in Upload
        self._FilesInsert(param=param)
      File &quot;/usr/local/lib/python2.7/dist-packages/pydrive/auth.py&quot;, line 53, in _decorated
        self.auth.Authorize()
      File &quot;/usr/local/lib/python2.7/dist-packages/pydrive/auth.py&quot;, line 422, in Authorize
        self.service = build(&#39;drive&#39;, &#39;v2&#39;, http=self.http)
      File &quot;/usr/local/lib/python2.7/dist-packages/oauth2client/util.py&quot;, line 132, in positional_wrapper
        return wrapped(*args, **kwargs)
      File &quot;/usr/local/lib/python2.7/dist-packages/apiclient/discovery.py&quot;, line 192, in build
        resp, content = http.request(requested_url)
      File &quot;/usr/local/lib/python2.7/dist-packages/oauth2client/util.py&quot;, line 132, in positional_wrapper
        return wrapped(*args, **kwargs)
      File &quot;/usr/local/lib/python2.7/dist-packages/oauth2client/client.py&quot;, line 475, in new_request
        self._refresh(request_orig)
      File &quot;/usr/local/lib/python2.7/dist-packages/oauth2client/client.py&quot;, line 653, in _refresh
        self._do_refresh_request(http_request)
      File &quot;/usr/local/lib/python2.7/dist-packages/oauth2client/client.py&quot;, line 677, in _do_refresh_request
        body = self._generate_refresh_request_body()
      File &quot;/usr/local/lib/python2.7/dist-packages/oauth2client/client.py&quot;, line 861, in _generate_refresh_request_body
        assertion = self._generate_assertion()
      File &quot;/usr/local/lib/python2.7/dist-packages/oauth2client/client.py&quot;, line 977, in _generate_assertion
        private_key, self.private_key_password), payload)
      File &quot;/usr/local/lib/python2.7/dist-packages/oauth2client/crypt.py&quot;, line 131, in from_string
        pkey = crypto.load_pkcs12(key, password).get_privatekey()
    OpenSSL.crypto.Error: [(&#39;asn1 encoding routines&#39;, &#39;ASN1_get_object&#39;, &#39;header too long&#39;)]

My authentication on gdrive api looks like this:

![enter image description here][1]

**How could I use pydrive such that I do not need to authenticate everytime I use it?**

**How to allow automatic authentication such that the python script using the pydrive script will only upload to the account that generated the `secret_client.json` and not the currently logged on account on the internet browser?**

  [1]: http://i.stack.imgur.com/7grL4.png

Automating pydrive verification process

I have completed steps of authorization and obtained access token and refresh token.

What should I do next to generate access token using refresh token that I have stored through google drive API?

I won&#39;t be able to use any sdk since I am working on Force.com so please suggest the way to implement it directly through the API.

How to generate access token using refresh token through google drive API?

I uploaded a file to Google spreadsheets (to make a publically accessible example IPython Notebook, with data) I was using the file in it&#39;s native form could be read into a Pandas Dataframe. So now I use the following code to read the spreadsheet, works fine but just comes in as string,, and I&#39;m not having any luck trying to get it back into a dataframe (you can get the data)

    import requests
    r = requests.get(&#39;https://docs.google.com/spreadsheet/ccc?key=0Ak1ecr7i0wotdGJmTURJRnZLYlV3M2daNTRubTdwTXc&amp;output=csv&#39;)
    data = r.content

The data ends up looking like: (1st row headers)

    &#39;,City,region,Res_Comm,mkt_type,Quradate,National_exp,Alabama_exp,Sales_exp,Inventory_exp,Price_exp,Credit_exp\n0,Dothan,South_Central-Montgomery-Auburn-Wiregrass-Dothan,Residential,Rural,1/15/2010,2,2,3,2,3,3\n10,Foley,South_Mobile-Baldwin,Residential,Suburban_Urban,1/15/2010,4,4,4,4,4,3\n12,Birmingham,North_Central-Birmingham-Tuscaloosa-Anniston,Commercial,Suburban_Urban,1/15/2010,2,2,3,2,2,3\n

The native pandas code that brings in the disk resident file looks like:

    df = pd.io.parsers.read_csv(&#39;/home/tom/Dropbox/Projects/annonallanswerswithmaster1012013.csv&#39;,index_col=0,parse_dates=[&#39;Quradate&#39;])

A &quot;clean&quot; solution would be helpful to many to provide an easy way to share datasets for Pandas use! I tried a bunch of alternative with no success and I&#39;m pretty sure I&#39;m missing something obvious again.

Just a Update note The new Google spreadsheet has a different URL pattern Just use this in place of the URL in the above example and or the below answer and you should be fine here is an example: 

    https://docs.google.com/spreadsheets/d/177_dFZ0i-duGxLiyg6tnwNDKruAYE-_Dd8vAQziipJQ/export?format=csv&amp;id

see solution below from @Max Ghenis which just used pd.read_csv, no need for StringIO or requests...

Getting Google Spreadsheet CSV into A Pandas Dataframe

I was wondering if its possible to access/display files like images which are stored in Google Drive on a public website.

Displaying files (e.g. images) stored in Google Drive on a website

I&#39;ve spent the last six hours pouring over documents from Google and I still don&#39;t know how to get started with this. All I want to do is make it so my existing Android app can read files from Google Drive, upload new files to Google Drive, and edit existing files on Google Drive.

I&#39;ve read that Drive SDK v2 was focused solely on making it easy for Android (and mobile in general) developers to use it, and yet there seems to be virtually nothing in their documentation about it.

Ideally, I&#39;d like someone to point at some decent documentation, example, or tutorial covering how to do this (keep in mind I&#39;m using Android. They have plenty of stuff on how to use Drive with the Google App Engine; I have already looked at it and I have no idea how to go from that to an Android app.)

I need to know which libraries I need to download and add to my project, what I need to add to my manifest, and how I can ultimately get a list of files from Google Drive, download one, and then upload a modified version.

Ideally, I&#39;d like it to handle accounts automatically, the way that the officially Google Drive app does.

Android Open and Save files to/from Google Drive SDK

Google Colaboratory is really cool, but it would be more useful if I can access all my google drive files, without using standard google drive API.


Is it possible and easy? and how?

Colaboratory: Can I access to my Google drive folder and file?

Currently, I&#39;m using [Google Drive Android API][1], to store my Android app data, to *Google Drive App Folder*.

This is what I&#39;m doing when saving my application data

 1. Generate a checksum for the current local zip file.
 2. Search in *Google Drive App Folder*, to see whether there is an existing App Folder zip file.
 3. If there is, overwrite the content of existing App Folder zip file, with current local zip files. Also, we will rename existing App Folder zip filename, with the latest checksum.
 4. If there isn&#39;t existing App Folder zip file, generate a new App Folder zip file, with local zip file&#39;s content. We will use the latest checksum as App Folder zip filename.

Here&#39;s the code which performs the above-mentioned operations.

Generate new App Folder zip file, or update existing App Folder zip file
------------------------------------------------------------------------

    public static boolean saveToGoogleDrive(GoogleApiClient googleApiClient, File file, HandleStatusable h, PublishProgressable p) {
        // Should we new or replace?

        GoogleCloudFile googleCloudFile = searchFromGoogleDrive(googleApiClient, h, p);

        try {
            p.publishProgress(JStockApplication.instance().getString(R.string.uploading));

            final long checksum = org.yccheok.jstock.gui.Utils.getChecksum(file);
            final long date = new Date().getTime();
            final int version = org.yccheok.jstock.gui.Utils.getCloudFileVersionID();
            final String title = getGoogleDriveTitle(checksum, date, version);

            DriveContents driveContents;
            DriveFile driveFile = null;

            if (googleCloudFile == null) {
                DriveApi.DriveContentsResult driveContentsResult = Drive.DriveApi.newDriveContents(googleApiClient).await();

                if (driveContentsResult == null) {
                    return false;
                }

                Status status = driveContentsResult.getStatus();
                if (!status.isSuccess()) {
                    h.handleStatus(status);
                    return false;
                }

                driveContents = driveContentsResult.getDriveContents();

            } else {
                driveFile = googleCloudFile.metadata.getDriveId().asDriveFile();
                DriveApi.DriveContentsResult driveContentsResult = driveFile.open(googleApiClient, DriveFile.MODE_WRITE_ONLY, null).await();

                if (driveContentsResult == null) {
                    return false;
                }

                Status status = driveContentsResult.getStatus();
                if (!status.isSuccess()) {
                    h.handleStatus(status);
                    return false;
                }

                driveContents = driveContentsResult.getDriveContents();
            }

            OutputStream outputStream = driveContents.getOutputStream();
            InputStream inputStream = null;

            byte[] buf = new byte[8192];

            try {
                inputStream = new FileInputStream(file);
                int c;

                while ((c = inputStream.read(buf, 0, buf.length)) &gt; 0) {
                    outputStream.write(buf, 0, c);
                }

            } catch (IOException e) {
                Log.e(TAG, &quot;&quot;, e);
                return false;
            } finally {
                org.yccheok.jstock.file.Utils.close(outputStream);
                org.yccheok.jstock.file.Utils.close(inputStream);
            }

            if (googleCloudFile == null) {
                // Create the metadata for the new file including title and MIME
                // type.
                MetadataChangeSet metadataChangeSet = new MetadataChangeSet.Builder()
                        .setTitle(title)
                        .setMimeType(&quot;application/zip&quot;).build();

                DriveFolder driveFolder = Drive.DriveApi.getAppFolder(googleApiClient);
                DriveFolder.DriveFileResult driveFileResult = driveFolder.createFile(googleApiClient, metadataChangeSet, driveContents).await();

                if (driveFileResult == null) {
                    return false;
                }

                Status status = driveFileResult.getStatus();
                if (!status.isSuccess()) {
                    h.handleStatus(status);
                    return false;
                }
            } else {
                MetadataChangeSet metadataChangeSet = new MetadataChangeSet.Builder()
                        .setTitle(title).build();

                DriveResource.MetadataResult metadataResult = driveFile.updateMetadata(googleApiClient, metadataChangeSet).await();
                Status status = metadataResult.getStatus();
                if (!status.isSuccess()) {
                    h.handleStatus(status);
                    return false;
                }
            }

            Status status;
            try {
                status = driveContents.commit(googleApiClient, null).await();
            } catch (java.lang.IllegalStateException e) {
                // java.lang.IllegalStateException: DriveContents already closed.
                Log.e(TAG, &quot;&quot;, e);
                return false;
            }

            if (!status.isSuccess()) {
                h.handleStatus(status);
                return false;
            }

            status = Drive.DriveApi.requestSync(googleApiClient).await();
            if (!status.isSuccess()) {
                // Sync request rate limit exceeded.
                //
                //h.handleStatus(status);
                //return false;
            }

            return true;
        } finally {
            if (googleCloudFile != null) {
                googleCloudFile.metadataBuffer.release();
            }
        }
    }

Search for existing App Folder zip file
---------------------------------------
    private static String getGoogleDriveTitle(long checksum, long date, int version) {
        return &quot;jstock-&quot; + org.yccheok.jstock.gui.Utils.getJStockUUID() + &quot;-checksum=&quot; + checksum + &quot;-date=&quot; + date + &quot;-version=&quot; + version + &quot;.zip&quot;;
    }

    // https://stackoverflow.com/questions/1360113/is-java-regex-thread-safe
    private static final Pattern googleDocTitlePattern = Pattern.compile(&quot;jstock-&quot; + org.yccheok.jstock.gui.Utils.getJStockUUID() + &quot;-checksum=([0-9]+)-date=([0-9]+)-version=([0-9]+)\\.zip&quot;, Pattern.CASE_INSENSITIVE);

    private static GoogleCloudFile searchFromGoogleDrive(GoogleApiClient googleApiClient, HandleStatusable h, PublishProgressable p) {
        DriveFolder driveFolder = Drive.DriveApi.getAppFolder(googleApiClient);

        // https://stackoverflow.com/questions/34705929/filters-ownedbyme-doesnt-work-in-drive-api-for-android-but-works-correctly-i
        final String titleName = (&quot;jstock-&quot; + org.yccheok.jstock.gui.Utils.getJStockUUID() + &quot;-checksum=&quot;);
        Query query = new Query.Builder()
                .addFilter(Filters.and(
                    Filters.contains(SearchableField.TITLE, titleName),
                    Filters.eq(SearchableField.TRASHED, false)
                ))
                .build();

        DriveApi.MetadataBufferResult metadataBufferResult = driveFolder.queryChildren(googleApiClient, query).await();

        if (metadataBufferResult == null) {
            return null;
        }

        Status status = metadataBufferResult.getStatus();

        if (!status.isSuccess()) {
            h.handleStatus(status);
            return null;
        }

        MetadataBuffer metadataBuffer = null;
        boolean needToReleaseMetadataBuffer = true;

        try {
            metadataBuffer = metadataBufferResult.getMetadataBuffer();
            if (metadataBuffer != null ) {
                long checksum = 0;
                long date = 0;
                int version = 0;
                Metadata metadata = null;

                for (Metadata md : metadataBuffer) {
                    if (p.isCancelled()) {
                        return null;
                    }

                    if (md == null || !md.isDataValid()) {
                        continue;
                    }

                    final String title = md.getTitle();

                    // Retrieve checksum, date and version information from filename.
                    final Matcher matcher = googleDocTitlePattern.matcher(title);
                    String _checksum = null;
                    String _date = null;
                    String _version = null;
                    if (matcher.find()){
                        if (matcher.groupCount() == 3) {
                            _checksum = matcher.group(1);
                            _date = matcher.group(2);
                            _version = matcher.group(3);
                        }
                    }
                    if (_checksum == null || _date == null || _version == null) {
                        continue;
                    }

                    try {
                        checksum = Long.parseLong(_checksum);
                        date = Long.parseLong(_date);
                        version = Integer.parseInt(_version);
                    } catch (NumberFormatException ex) {
                        Log.e(TAG, &quot;&quot;, ex);
                        continue;
                    }

                    metadata = md;

                    break;

                }   // for

                if (metadata != null) {
                    // Caller will be responsible to release the resource. If release too early,
                    // metadata will not readable.
                    needToReleaseMetadataBuffer = false;
                    return GoogleCloudFile.newInstance(metadataBuffer, metadata, checksum, date, version);
                }
            }   // if
        } finally {
            if (needToReleaseMetadataBuffer) {
                if (metadataBuffer != null) {
                    metadataBuffer.release();
                }
            }
        }

        return null;
    }


----------

The problem occurs, during loading application data. Imagine the following operations

 1. Upload zip data to *Google Drive App Folder* for the first time. The checksum is `12345`. The filename being used is `...checksum=12345...zip`
 2. Search for zip data from *Google Drive App Folder*. Able to find the file with filename `...checksum=12345...zip`. Download the content. Verify the checksum of content is `12345` too.
 3. Overwrite new zip data to existing *Google Drive App Folder* file. New zip data checksum is `67890`. The existing app folder zip file is renamed to `...checksum=67890...zip`
 4. Search for zip data from *Google Drive App Folder*. Able to find the file with filename `...checksum=67890...zip`. **However, after downloading the content, the checksum of the content is still old `12345`!**

Download App Folder zip file
----------------------------

    public static CloudFile loadFromGoogleDrive(GoogleApiClient googleApiClient, HandleStatusable h, PublishProgressable p) {
        final java.io.File directory = JStockApplication.instance().getExternalCacheDir();
        if (directory == null) {
            org.yccheok.jstock.gui.Utils.showLongToast(R.string.unable_to_access_external_storage);
            return null;
        }

        Status status = Drive.DriveApi.requestSync(googleApiClient).await();
        if (!status.isSuccess()) {
            // Sync request rate limit exceeded.
            //
            //h.handleStatus(status);
            //return null;
        }

        GoogleCloudFile googleCloudFile = searchFromGoogleDrive(googleApiClient, h, p);

        if (googleCloudFile == null) {
            return null;
        }

        try {
            DriveFile driveFile = googleCloudFile.metadata.getDriveId().asDriveFile();
            DriveApi.DriveContentsResult driveContentsResult = driveFile.open(googleApiClient, DriveFile.MODE_READ_ONLY, null).await();

            if (driveContentsResult == null) {
                return null;
            }

            status = driveContentsResult.getStatus();
            if (!status.isSuccess()) {
                h.handleStatus(status);
                return null;
            }

            final long checksum = googleCloudFile.checksum;
            final long date = googleCloudFile.date;
            final int version = googleCloudFile.version;

            p.publishProgress(JStockApplication.instance().getString(R.string.downloading));

            final DriveContents driveContents = driveContentsResult.getDriveContents();

            InputStream inputStream = null;
            java.io.File outputFile = null;
            OutputStream outputStream = null;

            try {
                inputStream = driveContents.getInputStream();
                outputFile = java.io.File.createTempFile(org.yccheok.jstock.gui.Utils.getJStockUUID(), &quot;.zip&quot;, directory);
                outputFile.deleteOnExit();
                outputStream = new FileOutputStream(outputFile);

                int read = 0;
                byte[] bytes = new byte[1024];

                while ((read = inputStream.read(bytes)) != -1) {
                    outputStream.write(bytes, 0, read);
                }
            } catch (IOException ex) {
                Log.e(TAG, &quot;&quot;, ex);
            } finally {
                org.yccheok.jstock.file.Utils.close(outputStream);
                org.yccheok.jstock.file.Utils.close(inputStream);
                driveContents.discard(googleApiClient);
            }

            if (outputFile == null) {
                return null;
            }

            return CloudFile.newInstance(outputFile, checksum, date, version);
        } finally {
            googleCloudFile.metadataBuffer.release();
        }
    }

First, I thought 

    Status status = Drive.DriveApi.requestSync(googleApiClient).await()

doesn&#39;t do the job well. It fails in most of the situation, with error message `Sync request rate limit exceeded.` In fact, the hard limit imposed in `requestSync`, make that API not particularly useful - https://stackoverflow.com/questions/31203255/android-google-play-drive-api


----------


However, even when `requestSync` success, `loadFromGoogleDrive` still can only get the latest filename, but outdated checksum content.

I&#39;m 100% sure `loadFromGoogleDrive` is returning me a cached data content, with the following observations.

 1. I install a `DownloadProgressListener` in `driveFile.open`, bytesDownloaded is 0 and bytesExpected is -1.
 2. If I use [Google Drive Rest API][2], with the following [desktop code][3], I can find the latest filename with correct checksum content.
 3. If I uninstall my Android app and re-install again, `loadFromGoogleDrive` will able to get the latest filename with correct checksum content.

***Is there any robust way, to avoid from always loading cached app data from Google Drive?***


----------

I manage to produce a demo. Here are the steps to reproduce this problem.



Step 1: Download source code
-----------------------------
https://github.com/yccheok/google-drive-bug



Step 2 : Setup in API console
-----------------------------

[![enter image description here][4]][4]



Step 3: Press button SAVE &quot;123.TXT&quot; WITH CONTENT &quot;123&quot;
-------------------------------------------------------
[![enter image description here][5]][5]

A file with filename &quot;123.TXT&quot;, content &quot;123&quot; will create in the app folder.



Step 4: Press button SAVE &quot;456.TXT&quot; WITH CONTENT &quot;456&quot;
-------------------------------------------------------
[![enter image description here][6]][6]

The previous file will be renamed to &quot;456.TXT&quot;, with content updated to &quot;456&quot;



Step 5: Press button LOAD LAST SAVED FILE
------------------------------------------
[![enter image description here][7]][7]

**File with filename &quot;456.TXT&quot; was found, but the previous cached content &quot;123&quot; is read. I was expecting content &quot;456&quot;.**

Take note that, if we

 1. Uninstall demo app.
 2. Re-install demo app.
 3. Press button LOAD LAST SAVED FILE, file with filename &quot;456.TXT&quot; and content &quot;456&quot; is found.

I had submitted issues report officially - https://code.google.com/a/google.com/p/apps-api-issues/issues/detail?id=4727


----------


Other info
-----------
This is how it looks like under my device - http://youtu.be/kuIHoi4A1c0 

I realise, not all users will hit with this problem. For instance, I had tested with another Nexus 6, Google Play Services 9.4.52 (440-127739847). The problem doesn&#39;t appear.
   	 
I had compiled an APK for testing purpose - https://github.com/yccheok/google-drive-bug/releases/download/1.0/demo.apk  

  [1]: https://developers.google.com/drive/android/intro
  [2]: https://developers.google.com/drive/v3/web/quickstart/java
  [3]: https://github.com/yccheok/jstock/blob/master/src/org/yccheok/jstock/gui/Utils.java#L1225
  [4]: http://i.stack.imgur.com/GS7gr.png
  [5]: http://i.stack.imgur.com/D7F4j.png
  [6]: http://i.stack.imgur.com/P5WoM.png
  [7]: http://i.stack.imgur.com/ROVZd.png





How to avoid from always loading cached app data from Google Drive

Because this product is new, I am looking forward to develop an app on it so is there any limit on the API usage such as: 

 - upload and download quota 
 - requests per app
 - etc

All Google Drive-Api Solutions on Gang of Coders

Total of 22 Google Drive-Api Solutions