When I use Google Cloud Firestore / Query documents I get no output no matter what I try.
I recommend you recheck the inputs provided in the module. Also, refer to the below link to know about the module in detail:
https://www.make.com/en/help/app/google-cloud-firestore#query-documents
MSquare Support
Visit us here
Youtube Channel
1 Like
@Pdx I have the same issue. Did you manage to solve it?
I did not solve the issue with a query and the advice given by @Msquare_Automation was like saying “Have you tried turning it off and on again?”.
The Google Cloud Firestore / Query documents function seems useless and no matter what I tried I could not get it to work, however, I found a workaround that provided me with a solution - I did this instead…
- Use Google Cloud Firestore / List documents
- Add a Router
- Add an Iterator to the router (or whatever you require)
- Between the Router and Iterator filter the results from the List documents command.
- Do what you need to do next
I’ll add an image so you can see what I mean, let me know if this works for you or if you have a better ide.
Thanks for the quick reply @Pdx
The query module does not work in the way you would expect although I have had some success when I set the collectionID to * (it says it can be blank but that always throws an error). The challenge is that the output is always blank
I don’t think the query module works or if it does there is no example anywhere.
Thanks for sharing your idea although I don’t think it will solve what I am trying to do. I am trying to join to three Firestore collections. I can get it to join two using something similar to what you show but the third collection uses a different key.
@Gary_Luton I agree that the query module does not work in the way expected no matter how closely you follow the documentation.
It is possible that we are having the issue as maybe you can’t query a collection as you want but it is there to query specific documents, you could try using that logic for your join when you know the key but need to query the data.
@Gary_Luton Hi guys,
Have you been able to figure out how to use the WHERE field to filter a query in the firebase module?
Who at Make is in charge of debugging this module and as importantly improving the documentation? Because this
isn’t enough.
I must agree to @Fredx, the documentation isn’t working for me either. I want to filter a query collection on a reference field. I did get the query to run without an error after an hour of trying. But the query returns zero rows where I know there are several matches.
It looks like the REST API is being used in the background as it expects this syntax for the reference field on which I want to filter: projects/{my-project}/databases/(my-database}/documents/{my-document}/{document-id} although I’m not sure because this returns zero results.
Isn’t there any MAKE guru out there that can give some examples on how to do a decent firebase query (on a reference field (foreign key))?