Him thanks for the help in advance. I have a worflow that will run a weekly to login into a system extract data and put in into a datatable. The datatable is to be stored in a queue in orchestrator . So each row is a new item in the queue.
Now my problem is that the data can change often and i need my processs to take that into account and update the queue accordingly
Here is what i am trying to accomplish . I already have the process built to the point where it sends the data to the queue but i dont want duplicates the next week and the weeks after when it runs and i want the following
• I want my process to retrieve all the items first In the Queue if any and set them to successful, then
• I want the process to check for the existence of the item first by using the reference string which I made the row(0).ToString value
o If the item exists, then check and compare the data in the item.
If something changes, then update the item.
If not, then go to the next item.
o If it is a new item , then add it to the queue, and set the status to new