HOW TO: Pick up item fulfillments using delta flows

To pick up item fulfillments using delta:

In your export, make sure the Export Type is set to Delta. For Delta flows, the first lastExportDateTime will always be the current timestamp when it initially runs its first scheduled job of the flow. To change this variable to something different, you'll need to manually run the flow, which will prompt you to set the value of the Year, Month, Date, and Time. This is recommended if you're developing your flow and need to test it.
If you want to use the All export type, you can use the dateAdd handlebar to subtract a number of milliseconds from the first date value. For example, to have the start date be 24 hours prior to the current timestamp, use:

{{dateAdd (timeStamp) "-86400000"}}

If you need to subtract 24 hours, then format the final value, use this:

{{dateFormat "YYYY-MM-DD HH:mm:ss" (dateAdd (timeStamp) "-86400000")}}

These work from the inside out, so it is processed like this:

We call the "timeStamp" handlebar to get the current timestamp.
Then we call the "dateAdd" handlebar to subtract 86400000ms (24 hours) from the timestamp.
Finally, we use the "dateFormat" handlebar to format the final value as needed.

Comments