My Current Setup:
HTTP Make a Basic Auth Request Documentation:
My Goal: I am helping a non-profit animal shelter set up a website that hosts their dogs and cats using Webflow CMS. The way it works is that there is a Webflow collection that is designated for cats and dogs. They use Shelter Manager for their animal database. We want to pull animals from Shelter Manager and 1-2 times a day, use Make.com to send any new items to the CMS collection OR delete an animal from the CMS collection if it no longer appears in the Shelter Manager database. Related, I’d also like to update an existing Webflow CMS Item (animal) if there has been a change to that animal in Shelter Manager.
I want to add, update, and delete items to/from a specified Webflow CMS collection based on whether the data from the [HTTP Make a Basic Auth Request] module has been newly created, updated, or deleted. The [HTTP Make a Basic Auth Request] module produces about 105 bundles after it has been iterated through the [Iterator] module.
I am able to only do one of the above currently, which is to add items to a specified Webflow CMS collection. Every time I run the attached scenario, it will add new CMS items starting from the first iterated bundle by the [Iterator] module which is iterating data from the [HTTP Make a Basic Auth Request] module. This results in a new item being duplicated in the CMS collection that already contains said item.
I had thought that if I attached the unique IDs (20. ID:) coming from the [Iterator] module to a field (Pet ID:) in each Webflow CMS Item, I could then filter the data to go to one of three Webflow Create, Update, or Delete modules.
- Create an Item: If there is not currently a Webflow CMS Item with a matching (20. ID:) value in the (Pet ID:) Webflow CMS Item field.
- Update an Item: If there is currently a Webflow CMS Item with a matching (20. ID:) value in the (Pet ID:) Webflow CMS Item field AND the (20. ID:) still exists in the (20. ID) feed coming from the [Iterator] module (I wonder, though, since have gone through 15,000+ operations in three days trial and erroring that it might be best to just ignore rather than update? If this is possible)
- Delete an Item: If there is currently a Webflow CMS Item containing a value in the (Pet ID:) field that no longer exists as a (20. ID:) in the iterated data from the [HTTP Make a Basic Auth Request] module.
I have tried multiple filters, tools, and arrangments to try to make Update an Item and Delete an Item work but have been unsuccessful. I have also been unsuccessful in setting my scenario up in a way that prevents duplicate Webflow CMS Items from being created.
Could someone please give me a little direction here?