Search code examples
firebasegoogle-cloud-firestorezapier

Zapier Firebase markup

I'm attempting to link my Zapier account to my Firebase account to trigger once a new entry is seen within a collection.

I've been having issues with this, and I think this is because of the query I'm using:

"orderBy": [{
    "field": {
        "fieldPath": "startDateInMilliseconds"
    },
    "direction": "DESCENDING"
}]

(this is the default example given in documentation, with my field filled in). I believe the issue stems from the fieldPath, as the field for the collection I'm ordering by is under a subcategory "d".

Here's a picture of the data that works with the above query.

enter image description here

He's a picture of the data I'm working with, this one does not work.

enter image description here

Image with the start date field.

Without this subcategory, the query works fine in testing, but within this category, the query returns an error, saying it's unable to find any documents.

Does anyone know how to change the query to work for my situation? Thanks.

Solution

  • If you're trying to query a property of the d field map, you will need to use dot notation to find it.

    "orderBy": [{
    "field": {
        "fieldPath": "d.dateInMilliseconds"
    },
    "direction": "DESCENDING"
}]