Ignore processed order
There are 3 nodes that I mapped:
Add line item
Create sales transaction
What are you using for a data source type? If you use changes only, it will only bring over the orders that have changed.
The following link will have additional details on setting up a Change Table.
I’m using MS CRM query as my database. I’ve updated CRM order as fulfilled/completed so the query should be refreshed, no?
SC IS re-running the query every time you run the map (as you’ve noticed).
If you want to restrict out records, you’d have to modify your query by adding restrictions that would filter out these fulfilled/completed – SmartConnect isn’t going to do that for you. How would it know you wanted to do that?
If you cannot restrict out the records on the initial CRM query, you could also create a Restriction in the mapping and restrict out any data for any reason that you want so SC won’t re-process it. It is more efficient to do this on the query/server side vs the client side but both would work.
If you would like to submit an answer or comment, please sign in to the eOne portal.