Firestore document query on a subcollection

[EmeraldHerald]

Hi @Ronan Welcome to the community

You should in theory be able to use a full JSON payload to achieve this - check out this post from my teammate @MutedJam :

Firestore JSON Where Query "And-Condition"

Hi @Userply, welcome to the community You can use Firestore’s CompositeFilter for the job. If you are searching for a document with first_name = Patrick and last_name = Star, the JSON query could look like below. Document: [image] Query: { "structuredQuery": { "where": { "compositeFilter": { "op": "AND", "filters": [{ "fieldFilter": { "field": { "fieldPath": "first_name" }, "op": "EQUAL", …

I was trying to look into how to get sub-collections for you for a bit - but I’m afraid I’m honestly fairly stuck I thought that this would be the way to go: StructuredQuery  |  Firebase

But even with that selector, I was only able to get the main collection’s data. Perhaps someone with a better understanding of Firestore can jump in here for you - I tried to also pull in @MutedJam on this one, and sadly he isn’t too sure either.

My best advice as well would be to disable the “simplify” option on the Firebase node as you play around, too. If you’re trying to run these queries, n8n logic may not output the data in the way you want.