I am working on extracting data from Orchestrator through the API and am having some trouble when it comes to joining the Jobs endpoint with the Queue Items.
Currently, I can retrieve the Jobs and Releases data, which shows the execution status of a given run, similar to what you see in Orchestrator > Automations > Jobs. I want to also retrieve all the queue items associated with that specific job execution.
I’m using a custom library that logs transactions to a SQL table rather than directly pulling data from the Queue Items endpoint. The data I capture from this method is similar to what’s available in the Queue Items endpoint. It doesn’t seem like there’s a direct key or ID that I can use to join the Jobs to the Queue Items. Other than the job’s start and end time, is there any unique key or identifier in the Queue Items that I can use to link them to a specific job on the Jobs endpoint?
I decided to take a different approach which seems to be working so far. I created an integer asset which is grabbed and subsequently incremented by the same automation. This way I can join queue items from my custom library to the automation job upon completion.