Query nested object in Firestore REST API

Question

I'm stuck with querying Firestore REST API. I can figure out how to filter by a regular key but I can't figure out how to query by nested object key.

Basically, in the browser client, I can do

firestore.collection("channels")
   .where("members.[memberID]", "==", true)
   .get()

However, when I try to do the same in the REST API, it said Invalid Argument. I was trying to do

{
 "structuredQuery": {
  "where": {
   "fieldFilter": {
    "field": {
     "fieldPath": "members.[memberID]"
    },
    "op": "EQUAL",
    "value": {
       booleanValue: "true"
    }
   }
  },
  "from": [
   {
    "collectionId": "channels"
   }
  ]
 }
}

but it gives me "Invalid Argument" error on fieldPath. Does anybody know how to query Firestore REST API based on nested object?

Thank you!

What I may have to do is convert it to a string using JSONModel and then convert it back. Which seems a bit ugly. — Saviz
– Saviz, Commented Dec 5, 2017 at 2:36
Sorry for the dumb question but where do you pass this object with the structured query? I am passing it as request body and it does not work at all. Could someone share a whole example? Would be helpful. — Georgi Arnaudov
– Georgi Arnaudov, Commented Mar 25, 2018 at 14:00
@GeorgiArnaudov you need to pass the whole structuredQuery object in the request body, what I have above is the request body — OmomSun
– OmomSun, Commented Mar 26, 2018 at 14:46

OmomSun · Accepted Answer · 2017-12-06 19:38:43Z

12

I asked for Firebase support and they said special characters in fieldPath such as "-" in my case can be escaped using back tick or back slash. It is mentioned in the documentation. In my case, I'll need to do

members.`[memberID]`

I hope this is helpful for you guys.

answered Dec 6, 2017 at 19:38

OmomSun

3372 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Query nested object in Firestore REST API

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related