Update config with a value from last processed queue item

Help Activities
, ,
1

Hi

I need to download an excel file everyday and add to queue For further processing.
Each day need to start reading the excel
starting from unprocessed row, as the excel get appended it will have already added data too.

How do I get the ID value( ID is one of the column) from last processed queue item ? Is it like after performer completes processing one queue item , take the ID column value and update the config of dispatcher each time ? Or find the last q item , take the ID from that and update the config ?

Or keep ID as unique ref and add the whole excel ?

Thank you

2

The simplest is just to use Unique Reference on the queue. Just make sure you don’t have Bulk Add Queue Items set to “all or nothing.”

Slightly less simple would be to store the last processed ID in an Asset.

I wouldn’t recommend having an automation update its own config file.

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.