Orchestrator API - How to get "@odata.count" via UiPathStudio

[Adrian_Star (Adrian Starukiewicz)]

Hi,
How to get @odata.count, which is visible in SWAGGER and is not available from the custom API library activity logic in UiPathStudio?



We have only 2 of 3 parameters to choose from:

• OdataContext and Value but not OdataCount.

I have managed this problem by applying logic:
out_queueItemCount = getQueueItemResponse.Value.Count.ToString

out_queueItemCount is String argument

Unfortunately it is not perfect. With large volumes of data available in the queue (over 100,000), the query takes a very very long time, because we get all transaction parameters in response.
And this counter counts the number of these cases after all data has been loaded.

I narrowed my search in the search parameters (Request Body) by adding a filter to "Status" in the Select position:

The response comes faster, but it still takes a long time, and I do not need the details of the transaction just the counter itself.

[AshwinS2 (Ashwin S)]

Hi @Adrian_Star

Check this

GET QueueItems by queue name in Orchestrator API

Hello all, is there a way to configure a GET request, among the Orchestrator API ones, to retrieve queueitems by the name of the queue itself ? Example: I have in my orchestrator 3 different queues, queuename1, queuename2, queuename3 and they all have their queueitems. How should i configure a https://platform.uipath.com/odata/QueueItems (method GET) request in order to retrieve only queuename3 items? Many thanks for suggestions!

Thanks
Ashwin S

[Adrian_Star (Adrian Starukiewicz)]

@AshwinS2,
Thanks for reply, but I need to get OData Count in UiPath Studio.

[AshwinS2 (Ashwin S)]

Hi @Adrian_Star

try this

Is there a way to know the possible response codes of an (Orchestrator) HTTP Request - In particular of "odata/Jobs/UiPath.Server.Configuration.OData.StartJobs"

Hi I’d like to know the possible response codes of the (Orchestrator) HTTP Requests. In particular of the “odata/Jobs/UiPath.Server.Configuration.OData.StartJobs” request. I tested for response code 200, but now it seems I get a 201 or a 409. I suppose that 201 means: dropped the job on the job queue in pending state and 409 means cannot drop the job on the job queue because there is already a job with the same name on the job queue in a pending state. But this is just a mere guess, based …

Thanks
Ashwin S

[Adrian_Star (Adrian Starukiewicz)]

Nope, it is not it.
I’m using custom library for API request and UiPath.Web.Activities activity in Studio (not POSTMAN and Orchestrator.HTTP.Request).

[Adrian_Star (Adrian Starukiewicz)]

Someone can help?

[byuli]

a bit late, but in case anyone is still looking. My rookie workaround to get the odata.count was to do the following:

Get the HTTP Request response string and parse it through the RegEx:

Assign
string variable = Trim(system.text.RegularExpressions.Regex.Match(strJSONResponse,"(?<=odata.count"":)(.*?)(?=(,|\s*<\,))").ToString)

Look out for an extra quote after odata.count to escape the required quote odata.count"".

I used this thread as an example to adapt to my requirement, but you can test too somewhere like http://regexstorm.net/tester, mine detected the count

The regex pattern is (?<=odata.count":)(.?)(?=(,|\s<,))

All the best,
byuli

[suraj3501 (Suraj)]

If anyone is looking for the solution:
Use ‘Deserialize JSON’ activity and pass HTTP request ‘response’ as input and output will be JsonObject.
JsonObject("@odata.count").ToString will give the required value.