Alteryx API - Run Length

matthewbechard

Hello-

Is there a "run length" field in the api  or both a start_time and a end_time field that can be used to calculate "run length"? 

Using the API endpoint /admin/v1/workflows/jobs/ ,  I only can seem to see createDate field. I am missing a field that would show the end time.

I am basically looking for this field shown below.

Any help would be appreciated.

Thanks,

Matt 

MattH

Hi @matthewbechard,

@joshuaburkhow is correct.  Currently the API does not report the completion time of a workflow run.  Also, as mentioned above, this information can be pulled from your MongoDB instance, on the AlteryxService database and in the AS_Queue and AS_Results tables. To find workflows run through the API, you will need to filter on the IsHidden field (set it to filter on True) in the AS_Queue collection.  Please note, if you have the functionality to allow users to run workflows without signing in, these will also be reported.  If this is the case, you can also add a filter to match the username to the the SubscriptionID that houses the workflows.

Attached is a sample workflow I use to get Run and Queue times for workflows running through the Gallery that you can use.  Just swap out the server name and passwords in the MongoDB Input tools

QueueTime.yxzp