I have a process which updates NetSuite Sales Order data from a MySQL data. Before updating, I have to check if a Sales Order in NetSuit has been created after a specific date (January 1st, 2016) and status is Open, only then update the Sales Order.
I was planning to use decision shape and do a connector call and pass parameters (@internalID and hardcoded date parameter)to check to see if I should be updating record or not. However, this does not look as straigt forward as doing a SQL query. Can anyone provide some ideas or a link to a example or a video to help me out here?