i want to use the “Orchestrator HTTP Request” activity to get the QueueItems from a specific folder as a json-file. Our goal is to extract the data in order to import it to our data warehouse.
Is there a possibility to specify the data, for example to only get the QueueItems from last week or month? Now we are getting every QueueItem.
Thanks for your help!
There are two things you will need to ensure
Get All Queue Items
That your logic gets all queue items from the queue. To achieve this you can refer to the snippet from @sarikayaebru and the marketplace component Get All Queue Items - RPA Component | UiPath Marketplace | Overview
Filter required items
Within the snippet above, you will have to modify the time filters. These are of DateTime argument types
So if you are intrested in last week your filter on from will be
Now.AddDays(-7) for the last month the filter will be
Based on you situation, you may want to filter on
Item Status as well
Can you try this once
/odata/QueueItems?$filter=(EndProcessing eq 2023-08-01 and StartProcessing eq 2023-08-31)
Or refer below solution