Google drive web doesn't match with Google drive API

Question

1.00/5 (1 vote)

See more:

I have implemented a Google Drive API Tool and i try to list all files which are held in Google Drive. But i only can see the files which i uploaded with my API Tool. When i upload a file with the Google Drive Web then i can see it only in the Web interface, but not in my API Tool. I thought with the API Tool i have full access to my personal Google Drive. Why can't i see all files?

What I have tried:

When i upload a file with the Google Drive Web then i can see it only in the Web interface, but not in my API Tool.

C#

public static Dictionary<string,string> GetFiles(bool gelöschteanzeigen)
        {
            Dictionary<string, string> listdateien = new Dictionary<string, string>();

            string pageToken = null;
            do
            {
                var request = service.Files.List();

                if (gelöschteanzeigen)
                    request.Q = "trashed = true and '" + RootId + "'" + " in parents";
                else
                    request.Q = "trashed = false and '" + RootId + "'" + " in parents";

                request.Spaces = "drive";
               request.Fields = "nextPageToken, files(id, name)";
                request.PageToken = pageToken;
                var result = request.Execute();
                foreach (var file in result.Files)
                {
                    listdateien.Add(file.Id, file.Name);
                }
                pageToken = result.NextPageToken;
            } while (pageToken != null);
            
            
            return listdateien;
        }

Posted 13-Sep-17 2:52am

Member 11930819

Updated 13-Sep-17 8:02am

v4

Add a Solution

Comments

Richard MacCutchan 13-Sep-17 11:40am

Ask Google, it's their API.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Graeme_Grant · Answer 1 · 2017-09-13T07:14:00

Solution 1

I have done a lot of work with the Google Drive API and have not experienced what you are mentioning. Their file/folder system works a bit different to most. Check that you are looking in the correct folder location.

Maybe this documentation will help: Search for Files | Drive REST API | Google Developers[^]

Posted 13-Sep-17 7:14am

Graeme_Grant

Comments

Member 11930819 13-Sep-17 13:33pm

hey, thanks for your answer, but i already found the link and couldn't solve it on my own.

Here i wanna show you my method to get the Files from a folder by id:

[code moved into question]

I only get a List with the files, which i uploaded with the API.

Graeme_Grant 13-Sep-17 13:48pm

Your code is not checking for more data, so you may only be seeing the first page of results. This may also be why. Documentation states:

Multiple corpora and Team Drives may be searched in a single query, though incomplete results may be returned if the combined corpus is too large. If the incompleteSearch field in the result is true, not all documents have been searched.

The example on the link provided above shows you how to get "all" the data.

Here is a link to the example on that page: Search for Files | Drive REST API | Google Developers[^]

Member 11930819 13-Sep-17 14:00pm

hm, i have updated my code, it looks now very similar to your suggestion. But i get the same list as before.

Graeme_Grant 13-Sep-17 14:08pm

I have run a test a few minutes ago:
1. Add a new File, Delete a file, rename a folder, using: Google Drive web interface[^]
2. Use API to read folders and file and everything looked just as expected.

The problem may be in your query.

Member 11930819 13-Sep-17 14:23pm

strange, i can't find a mistake there... maybe i can show you via skype?

Graeme_Grant 13-Sep-17 19:07pm

No to skype.

Member 11930819 15-Sep-17 5:32am

okay, other way maybe? Or can you send me the part of your code?

Graeme_Grant 15-Sep-17 5:35am

Mine is a private comms library for a commercial application written to the Google specification. So, no, at this stage I am not in a position to share it. You will find that the results would be no different.

What I suggest is to simplify your query and pull in all files, then look at the data and refine the query accordingly.

UPDATE: Here are a couple of links for you to get support from Google & other Google Drive API users:
* How to Get Help | Drive REST API | Google Developers[^]
* Google Drive Help Forum[^]

Member 11930819 15-Sep-17 10:31am

ok, np, but still can't find the mistake in the query. Even with this query i don't get the files which I uploaded with the web interface:

request.Q = "trashed = false";

I try to find a solution with you last links. Thank you so far!

Linda Lawton · Answer 2 · 2017-09-15T05:48:00

Solution 2

It sounds to me like you are using service account authentication.

Remember that a service account is not you think of it as a dummy user. When you upload using a service account you are uploading to the google drive account owned by the service account. When you run file.list as the service account you are going to see the files uploaded to the service accounts Google drive account.

You are not going to see the files uploaded to the service accounts google drive account in your own web version of Google drive unless you have the service account share the files with you.

Linda

Posted 15-Sep-17 5:48am

Linda Lawton

Updated 15-Sep-17 6:03am

Comments

Member 11930819 15-Sep-17 12:18pm

Well i can see all files in my own web version of Google drive, even those which i uploaded with the service account. But i can't list all files in my tool.

So, how can i share the service files and the "web files" that i don't work only in the "service field"?

Linda Lawton 15-Sep-17 12:39pm

The service account cant list files it doesn't have access to have you granted it access to the files in your dive account that its not listing?

Note: Sharing a folder with a service account does not always grant it permissions to see all new files added to said folder.