I have an RSS feeding into the “Adoptable Animals (Shelter Boss)” CMS collection. It’s set so that each dog has its own item in an RSS feed, and those items are either turned into a CMS item in webflow or updated if the item has already been published. This is accomplished by using a Data Store which collects both the RSS URL and the corresponding CMS item ID. I’d like for the dogs already in the collection who are no longer coming over from the RSS feed to unpublish in webflow. How do I automate this? Read-only site address is below. Thanks you!
You’ll need to flag your records as loading so that you can identify the ones that weren’t touched by the add/update process.
You could do that either by adding a Processed boolean field, set it to false for all records, and then update it as records are added or updated. Or you could do a similar thing by drafting all, and then undrafting as you update- however your automation would need to be quite reliable.
The process would be something like this-
Load your RSS feed into a data store
Iterate through your CMS items, clear the “processed” flag or possibly Draft them all.
Iterate through your data store
Add new dogs, and un-draft / flag them
Update existing dogs, and un-draft / flag them
Iterate through your CMS items, and do any cleanup, like Drafting those that were not processed
Note as a backup, I’d add a datetime field and update that whenever a record is added/updated. That makes it relatively easy later if you need to fix anything, you can just sort descending by date and you know which should be published and which shouldn’t.