Hello! I’m trying to retrieve the list of files I have within a folder in Google Drive to a Google Sheets. It seems to give me a 400 error on the folder name I input, but I’ve tried several different names and none of the work - always come back with the same 400 bad request error.
What happens if you remove the ' from the query string? Is the query correct as well? Normally I would expect it to be something like term operator value so parents in 'your-id' you can find more info on the query strings here: Search query terms and operators | Google Drive | Google Developers
Unfortunately no success yet. I tried several forms of putting the folder name, as well as picking other folders to see if worked with any other folder but no luck. I’ve also tried to change the authentication method and the way of writing the query string as you suggested.
The thing I need to do is list the all the file names I have within a specific folder. I have over 300 files with random names I need to transfer them to a spreadsheet… Don’t know if there’s any other way of doing it.
It might sound odd but does the user you authenticated with have access to the folder? I can’t really think of anything else that would cause the issue.
