Not a customer? Click the 'Start a free trial' link to begin a 30-day SaaS trial of our product and to join our community.
Existing Cisco AppDynamics customers should click the 'Sign In' button to authenticate to access the community
11-19-2023 11:31 AM - last edited on 04-02-2024 06:11 PM by Ryan.Paredez
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" } ]
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form