Orchestrator QueueItems API - Select sub property in QueueDefinition data

Hi,

I am querying QueueItems API and trying to select name and key property after expanding QueueDefinition data,

The below ODATA query runs fine in swagger,

https://cloud.uipath.com/<client/tenant>/orchestrator_/odata/QueueItems?
$expand=QueueDefinition($select=Name,Key)&$top=10

However, the response does not include the QueueDefinition data, it is marked as null. Please refer the attached screenshot.

image

How to build ODATA query to select sub property after expanding the data?

Thanks
VJ

https://cloud.uipath.com/<client/tenant>/orchestrator_/odata/QueueItems?$select=QueueDefinition$expand=QueueDefinition($select=Name,Key)&$top=10

Add a $select and include the QueueDefinition along with whatever other top level properties you want from the queue item.

Hi Paul

I tried to add QueueDefinition and Key in $select, though I am still getting null response for QueueDefinition data.

Swagger ran ODATA Query below,
https://cloud.uipath.com/<client/tenant>/orchestrator_/odata/QueueItems?$expand=QueueDefinition($select=Name)&$select=QueueDefinition,key

image

Regards
VJ

Try it without the ($select=Name) see if you get anything for QueueDefinition.

In the end you may just have to do a second API call to get the Queue details.

Hi Paul,

The ODATA Query works fine when $select parameter is removed and it includes all the properties of QueueDefinition.

I am trying to get limited properties in the response for QueueDefinition.

Thanks
VJ

What happens if you don’t use the $expand property?

Hi Paul

QueueDefinition does not show up in QueueItems response by default, If it is not added in $expand parameter, it is not possible to access the properties in QueueDefinition data.

Thanks
VJ