I’m having some trouble updating an item in the CMS Database, as I can’t figure out what Zapier wants in the “item” field, or how to get this information as Webflow doesn’t seem to have a CMS search function.
What I’m setting up is a multi path webhook zap that looks at the transaction type and does one of 2 things.
- If the transaction is a new subscription it creates an entry in the CMS for that customer. (This works perfectly fine and was super easy to get working.)
- If the transaction type is a subscription cancelation then change the customers status to “Subscription Canceled” and archive the item. (This is where I’m stuck)
In the second flow I can’t figure out how to query the CMS. I have set the customers slug to be their customer ID from Foxycart, but how to I find the “item” with that, then input that into the “item” field?
Any help with this would be great. Thanks