How to make Group By cases in table API

[lucky6]

Hi Everyone,

How can we make group by cases in table API.

[Ankur Bawiskar]

Hi Lucky,

It would be something like this

api/now/table/sn_customerservice_case?sysparm_query=GROUPBYcontact&sysparm_fields=number,contact

Regards
Ankur

[lucky6]

Thanks for the response but it is not working..

[Ankur Bawiskar]

Hi,

please share your screenshots

Regards
Ankur

[Ankur Bawiskar]

Hi,

if that doesn't work you can use GlideAggregate API

Example below

Endpoint: https://instanceName.service-now.com/api/now/stats/incident?sysparm_query=active%3Dtrue%5Eassigned_to%3D6816f79cc0a8016401c5a33be04be441&sysparm_count=true&sysparm_group_by=assigned_to

Output from APi:

Output from instance:

Regards
Ankur