When running a query with distinctcount in the UI it works as expected and returns multiple results. But when run via API I only get 20 results no matter the limit:
curl --location --request POST 'https://analytics.api.appdynamics.com/events/query?end=1700243357711&limit=100&start=1700239757711' \
--header 'PRIVATE-TOKEN: glpat-cQefeyVa51vG__mLtqM6' \
--header 'X-Events-API-Key: $API_KEY' \
--header 'X-Events-API-AccountName: $ACCOUNT_NAME' \
--header 'Content-Type: application/vnd.appd.events+json;v=2' \
--header 'Accept: application/vnd.appd.events+json;v=2' \
--header 'Authorization: Basic <bearer>' \
--data-raw '{"query":"SELECT toString(eventTimestamp), segments.node, requestGUID, distinctcount(segments.tier) FROM transactions","mode":"scroll"}
result:
[
{
"label": "0",
"fields": [
{
"label": "toString(eventTimestamp)",
"field": "toString(eventTimestamp)",
"type": "string"
},
{
"label": "segments.node",
"field": "segments.node",
"type": "string"
},
{
"label": "requestGUID",
"field": "requestGUID",
"type": "string"
},
{
"label": "distinctcount(segments.tier)",
"field": "segments.tier",
"type": "integer",
"aggregation": "distinctcount"
}
],
"results": [
[
"2023-11-17T16:55:14.472Z",
"node--1",
"82bbb595-88b7-4e81-9ded-56cb5a42c251",
1
],
[
"2023-11-17T16:55:14.472Z",
"node--7",
"c7785e77-deb9-4aff-93fe-35efa7299871",
1
],
[
"2023-11-17T16:55:22.777Z",
"node--7",
"3c22d9dd-74a3-496c-b8b9-1c4ce48a6b1f",
1
],
[
"2023-11-17T16:55:22.777Z",
"node--7",
"d86e97ff-91c8-45f9-832e-ec6f06ffff26",
1
],
[
"2023-11-17T16:55:29.959Z",
"node--1",
"44abeb53-30e6-4973-8afb-f7cfc52a9ba7",
1
],
[
"2023-11-17T16:55:29.959Z",
"node--1",
"b577b0b0-2d41-4dfa-aceb-e42b5bb39348",
1
],
[
"2023-11-17T16:56:55.468Z",
"node--1",
"2f92e785-8cd0-4028-acd7-21fa794eb004",
1
],
[
"2023-11-17T16:56:55.468Z",
"node--1",
"af7ca09b-c4fc-4c73-8502-26d92b2b5835",
1
],
[
"2023-11-17T16:58:13.694Z",
"node--1",
"4a04304b-f48f-4c8d-9034-922077dfcdb4",
1
],
[
"2023-11-17T16:58:13.694Z",
"node--7",
"22755c60-efa0-434f-be73-0f02f0222021",
1
],
[
"2023-11-17T17:00:36.983Z",
"node--1",
"b6386249-6408-4517-812c-ca3d5e6c304c",
1
],
[
"2023-11-17T17:00:36.983Z",
"node--1",
"f7c63152-b569-42bf-8d37-32bb181d7028",
1
],
[
"2023-11-17T17:05:50.737Z",
"node--1",
"306c7cb3-0eff-440e-96e1-4ad61ce01a0c",
1
],
[
"2023-11-17T17:05:50.737Z",
"node--1",
"b33c04bd-dfd6-452a-b425-7639dad0422d",
1
],
[
"2023-11-17T17:08:24.554Z",
"node--7",
"0ed8c3a6-a59c-4fee-a10e-e542c239aa94",
1
],
[
"2023-11-17T17:08:24.554Z",
"node--7",
"c0e6f198-d388-49da-96a6-d9d95868c40f",
1
],
[
"2023-11-17T17:10:06.483Z",
"node--1",
"cf3caef6-2688-4eac-a2a1-b2edb55f0569",
1
],
[
"2023-11-17T17:10:06.483Z",
"node--7",
"40f5a786-e12d-4b0c-a54e-a330e7b7afd1",
1
],
[
"2023-11-17T17:11:47.167Z",
"node--7",
"02c3a025-6def-499d-9315-68551df639d4",
1
],
[
"2023-11-17T17:11:47.167Z",
"node--7",
"f19df1e3-983d-4a72-a5e0-a3f9ffbb7afe",
1
]
],
"moreData": true,
"schema": "biz_txn_v1"
}
]
