Firstly what @Jon_Smith gave is a right approach to the scenario as that makes more sense and easier
now coming to integration services connector and trigger few things here
- As per what you need ideally the filter should be status as new and duedate is less than now() and not greater than as you want the duedate to be passed
- Till getting items via api call is good but coming to triggers you cannot define less than and greater than…a trigger needs a parameter which could filter as greater than or less than specified time and get queueitems does not have a parameter like that so a trigger cannot be created for this case
Hope this helps
cheers
