Hey Everyone, I created this question because I could not find an existing post and thought there must be others running into this same issue or others that have run into it in the past. Thanks for your help!
High Level Goal:
Listen for new updates to a Firestore Collection, extract the email, add to a mailchimp list.
Problem:
Using the below query, I receive an error that certain filters are not supported in Firestore v1beta1. It says to upgrade to v1.
What I need help with:
I know that I have to somehow upgrade to use Firestore v1, however, I cannot for the life of me figure out where to do this. My best guess is that v1beta1 is the internal Zap endpoint being used and I’ll likely just have to wait until they update Firebase to use the latest version.
Details on my Zap
Query
"where": {
"fieldFilter": {
"field": {
"fieldPath": "email"
},
"op": "NOT_IN",
"value": {
"stringValue": ""
}
}
},
"orderBy": o{
"field": {
"fieldPath": "followedUp?"
},
"direction": "DESCENDING"
}]
Error received when testing
Unable to pull records
Please reload the page. If the issue persists, troubleshoot error or contact Support.
Error code: Error while retrieving: Error code 400:
4{
"error": {
"code": 400,
"message": "'NOT_IN' filters are not supported in Firestore v1beta1, please upgrade to v1.",
"status": "INVALID_ARGUMENT"
}
}]
Thank you,
Richard