Describe the issue/error/question
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 is the error message (if any)?
ERROR: Bad request - please check your parameters
Please share the workflow
Share the output returned by the last node
Information on your n8n setup
n8n version: 1.9.0
Database you’re using (default: SQLite): SQLite
Running n8n with the execution process [own(default), main]: own
Running n8n via [Docker, npm, n8n.cloud, desktop app]: desktop app (Mac)
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
Hello @Jon , thanks a lot for your help!
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.
I appreciate your time though! Thanks a lot.
I have had a quick play and I have managed to get it working…
I found that a query string of
parents in '0B_yIMxAoFm31N1NrVkpvMnRXQzA' has allowed me to get the contents of this folder (but not sub folders)
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.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.