Question

How to write a structured query for firebase

  • 2 June 2024
  • 1 reply
  • 22 views

Trying to find a firestore document in firebase. Structured queries were tough to figure out. Documentation takes a lot for granted. Here is how i got it to work. The WHERE property is required, and other properties (e.g., FROM, SELECT, LIMIT) are handled by zapier on their end. 

 

Replace “itemLookupCode” with the name of the field you want to query

Replace “234212221” with the value you want to query by

 

{
  "where": {
    "fieldFilter": {
      "field": {
        "fieldPath": "itemLookupCode"
      },
      "op": "EQUAL",
      "value": {
        "stringValue": "234212221"
      }
    }
  }
}


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @Dovelement LLC 

For others, help articles for using Firebase / Firestore in Zaps: https://zapier.com/apps/firebase/help