I believe n8n is very powerful and allows one to do things without resorting to complex coding. And I am starting to like it.
I would request experts to advise me how to implement complex logic.
The logic that I want to use is as follows.
Call an API that will return around 100 items at each call depending on the criteria provided.
For every data item fetched using API I want to check if that item exist in database or not. If the data item exist in the database I want to check if its status and the status in the data received from API is same or different.
If the status is different then I want to check the database to see if any user is registered to the data item or not. Here there will be multiple users registered to one single data item. And one user can register to multiple data items.
If a user is registered to a data item I want to send the user a well formatted email informing the user that the status of the data item the user has registered to has been updated.
Then I will update the content in database.
My questions are:
What is the best way to implement such a complex login in a workflow?