GET /api/2.2/jobs/list Ordering

[AlexMc]

Hi there!

I am calling the job list API (via the Python SDK):

GET /api/2.2/jobs/list

docs.databricks.com/api/workspace/jobs/list

Does anyone know what ordering is applied / calculated for the list of jobs? 
Is it consistent or random?
Is it by creation time?

Thanks,
Alex

[BigRoux]

The API documentation does not explicitly specify the order in which jobs are returned. Anecdotal evidence suggests that the default ordering is descending by creation time. Additionally, such ordering seems to remain consistent across API calls unless altered by pagination or filtering.

To verify this, I also reviewed internal (non-public facing) documentation, which states:
"The response from the Databricks Jobs API /api/2.2/jobs/list does not explicitly define the ordering of jobs in the returned list within the provided documentation. There is no confirmed indication in the referenced materials whether jobs are ordered consistently or by specific fields such as creation time. Hence, it is likely that the ordering could be either random or implementation-dependent."

I hope this information proves helpful.

Best regards,
Louis

[AlexMc]

Hi Louis,

Thanks very much for the timely and helpful response!

I had a follow up question, if I may.
With the tasks list in the jobs, is that ordered in any particular way eg. creation time etc

Kind regards,
Alex

[aayrm5]

Hey @AlexMc 
Per my experience with Rest APIs, the job or task list would be random. I couldn't see if there's any pattern or sorting by runtime or anything.

Thanks,

[BigRoux]

I suspect that if the jobs are random then the tasks within a job will be random too. Louis

[AlexMc · Accepted solution]

Thanks both - this was very helpful!

[BigRoux]

If you have a chance pluse "like" and if you are satisfied accept this as a solution. Cheers, Louis.