Technical Latest content Contact forms Forums Blogs Resources

How to get only count(xx) in REST

lock
push_pin
done
Answered
2
1

I tried many things but I am unable to get only the count of documents that is belonging to a given contactId.

This is my REST: /v1/Archive/FindDocument?$select count(documentId):HideDetail:Footer&$filter=contactId=38

But not only do I get all documents on the contactId=38, but I don't get the count as a column, which I expected. Of cause RowCount works but that was not the idea.

Can someone help?

Martin Andersen
16 Feb 2026 | 02:14 PM

All Replies (1)

Pretty sure you need a groupby clause here?  'GroupBy(columnName):Footer' (docs)

 

David Hollegien
17 Feb 2026 | 09:58 AM
Yes, you are right. Thank you. I found the help I needed here: https://docs.superoffice.com/en/api/netserver/archive-providers/aggregate-groupby.html
I used a different approch and used a Post with body, the key is these columns:

"Columns": [
"Count(documentId):HideDetail",
"GroupBy(contactId):Footer,HideDetail"
]
And then the restriction set on contactId = 38

The result is then (and yes the count is 39):
(Just what I needed, at least almost, I would have liked a single column with the count 39, but this is good enough)

[
{
"EntityName": "footer:1",
"PrimaryKey": 1,
"ColumnData": {
"GroupBy(contactId):Footer,HideDetail": {
"DisplayValue": "[I:38]",
"TooltipHint": "{document_id=21891}",
"LinkHint": ""
},
"Count(documentId):HideDetail": {
"DisplayValue": "[I:39]",
"TooltipHint": "",
"LinkHint": ""
}
},
"LinkHint": "DrillDown=contactId|[I:38]§contactId_id|[I:38]",
"StyleHint": "footer",
"TableRight": {
"Mask": "Select, Update, Insert, Delete",
"Reason": ""
},
"FieldProperties": {}
}
]
Martin Andersen
17 Feb 2026 | 10:39 AM

Add reply