Dynatrace API - 按服务名称提取每个服务的请求计数（成功、4xx、5xx）
我正在尝试提取项目下每个 Web 服务的请求计数请求计数（成功、4xx、5xx）。我尝试了下面的查询，但它没有给出我所期望的。
builtin:service.requestCount.total 指标键
https://www.dynatrace.xx.com/e/12345-6539-4ea3-aab8-a9985ae713d4/api/v2/metrics/query?metricSelector=builtin:service.requestCount.total&entitySelector=type(SERVICE)&from=now-6h&resolution=3w&api-token=<token_name>
builtin:service.keyRequest.total.count 指标键
https://www.dynatrace.xx.com/e/1234-6539-4ea3-aab8-a9985ae713d4/api/v2/metrics/query?metricSelector=builtin:service.keyRequest.total.count&entitySelector=type(SERVICE)&from=now-6h&resolution=3w&api-token=<token_name>
在多维分析图表中我可以正确地看到计数
有人可以帮我进行 API 查询吗，我可以在请求中将服务名称作为参数传递并获取与该服务请求关联的请求计数。
编辑： 请在下面找到查询的 API 响应
> {
> "totalCount": 2,
> "nextPageKey": null,
> "resolution": "3m",
> "result": [
> {
> "metricId": "builtin:service.requestCount.total:filter(and(in(\"dt.entity.service\",entitySelector(\"type(service),entityName(~\"ControllerName~\")\")))):splitBy(\"dt.entity.service\"):avg:auto:sort(value(avg,descending)):limit(100)",
> "data": [
> {
> "dimensions": [
> "SERVICE-376AE4987839A1D7"
> ],
> "dimensionMap": {
> "dt.entity.service": "SERVICE-376AE4987839A1D7"
> },
> "timestamps": [
> 1645673400000,
> 1645673580000,
> 1645673760000,
> 1645673940000,
> 1645674120000,
> 1645674300000,
> 1645674480000,
> 1645674660000,
> 1645674840000,
> 1645675020000,
> 1645675200000,
> 1645675380000,
> 1645675560000,
> 1645675740000,
> 1645675920000,
> 1645676100000,
> 1645676280000,
> 1645676460000,
> 1645676640000,
> 1645676820000,
> 1645677000000,
> 1645677180000,
> 1645677360000,
> 1645677540000,
> 1645677720000,
> 1645677900000,
> 1645678080000,
> 1645678260000,
> 1645678440000,
> 1645678620000,
> 1645678800000,
> 1645678980000,
> 1645679160000,
> 1645679340000,
> 1645679520000,
> 1645679700000,
> 1645679880000,
> 1645680060000,
> 1645680240000,
> 1645680420000,
> 1645680600000,
> 1645680780000,
> 1645680960000,
> 1645681140000,
> 1645681320000,
> 1645681500000,
> 1645681680000,
> 1645681860000,
> 1645682040000,
> 1645682220000,
> 1645682400000,
> 1645682580000,
> 1645682760000,
> 1645682940000,
> 1645683120000,
> 1645683300000,
> 1645683480000,
> 1645683660000,
> 1645683840000,
> 1645684020000,
> 1645684200000,
> 1645684380000,
> 1645684560000,
> 1645684740000,
> 1645684920000,
> 1645685100000,
> 1645685280000,
> 1645685460000,
> 1645685640000,
> 1645685820000,
> 1645686000000,
> 1645686180000,
> 1645686360000,
> 1645686540000,
> 1645686720000,
> 1645686900000,
> 1645687080000,
> 1645687260000,
> 1645687440000,
> 1645687620000,
> 1645687800000,
> 1645687980000,
> 1645688160000,
> 1645688340000,
> 1645688520000,
> 1645688700000,
> 1645688880000,
> 1645689060000,
> 1645689240000,
> 1645689420000,
> 1645689600000,
> 1645689780000,
> 1645689960000,
> 1645690140000,
> 1645690320000,
> 1645690500000,
> 1645690680000,
> 1645690860000,
> 1645691040000,
> 1645691220000,
> 1645691400000,
> 1645691580000,
> 1645691760000,
> 1645691940000,
> 1645692120000,
> 1645692300000,
> 1645692480000,
> 1645692660000,
> 1645692840000,
> 1645693020000,
> 1645693200000,
> 1645693380000,
> 1645693560000,
> 1645693740000,
> 1645693920000,
> 1645694100000,
> 1645694280000,
> 1645694460000,
> 1645694640000,
> 1645694820000,
> 1645695000000
> ],
> "values": [
> 6,
> null,
> null,
> 1,
> 1,
> null,
> null,
> 2,
> null,
> null,
> 2,
> null,
> null,
> 2,
> 1,
> null,
> null,
> 5,
> 1,
> 4,
> 1,
> 2,
> 6,
> 2,
> 5,
> 7,
> 1,
> 3,
> 3,
> 4,
> null,
> 5,
> 9,
> 8,
> 3,
> 3,
> 4,
> null,
> 3,
> 1,
> 2,
> 3,
> 1,
> 5,
> 2,
> 5,
> null,
> 1,
> 4,
> 1,
> null,
> 2,
> 2,
> 1,
> 1,
> 2,
> 1,
> null,
> 1,
> null,
> null,
> 5,
> 1,
> null,
> null,
> 1,
> 1,
> 4,
> 1,
> null,
> null,
> 2,
> 3,
> null,
> null,
> 2,
> null,
> null,
> 2,
> null,
> 1,
> null,
> 2,
> 2,
> null,
> 2,
> 7,
> 1,
> 1,
> null,
> null,
> 1,
> 1,
> 1,
> 4,
> null,
> null,
> 1,
> null,
> null,
> null,
> 4,
> null,
> 1,
> null,
> 1,
> null,
> null,
> 1,
> null,
> null,
> 5,
> 2,
> 6,
> 5,
> null,
> null,
> 3,
> 2,
> 3,
> null
> ]
> },
> {
> "dimensions": [
> "SERVICE-BC7B97C170AF3FD6"
> ],
> "dimensionMap": {
> "dt.entity.service": "SERVICE-BC7B97C170AF3FD6"
> },
> "timestamps": [
> 1645673400000,
> 1645673580000,
> 1645673760000,
> 1645673940000,
> 1645674120000,
> 1645674300000,
> 1645674480000,
> 1645674660000,
> 1645674840000,
> 1645675020000,
> 1645675200000,
> 1645675380000,
> 1645675560000,
> 1645675740000,
> 1645675920000,
> 1645676100000,
> 1645676280000,
> 1645676460000,
> 1645676640000,
> 1645676820000,
> 1645677000000,
> 1645677180000,
> 1645677360000,
> 1645677540000,
> 1645677720000,
> 1645677900000,
> 1645678080000,
> 1645678260000,
> 1645678440000,
> 1645678620000,
> 1645678800000,
> 1645678980000,
> 1645679160000,
> 1645679340000,
> 1645679520000,
> 1645679700000,
> 1645679880000,
> 1645680060000,
> 1645680240000,
> 1645680420000,
> 1645680600000,
> 1645680780000,
> 1645680960000,
> 1645681140000,
> 1645681320000,
> 1645681500000,
> 1645681680000,
> 1645681860000,
> 1645682040000,
> 1645682220000,
> 1645682400000,
> 1645682580000,
> 1645682760000,
> 1645682940000,
> 1645683120000,
> 1645683300000,
> 1645683480000,
> 1645683660000,
> 1645683840000,
> 1645684020000,
> 1645684200000,
> 1645684380000,
> 1645684560000,
> 1645684740000,
> 1645684920000,
> 1645685100000,
> 1645685280000,
> 1645685460000,
> 1645685640000,
> 1645685820000,
> 1645686000000,
> 1645686180000,
> 1645686360000,
> 1645686540000,
> 1645686720000,
> 1645686900000,
> 1645687080000,
> 1645687260000,
> 1645687440000,
> 1645687620000,
> 1645687800000,
> 1645687980000,
> 1645688160000,
> 1645688340000,
> 1645688520000,
> 1645688700000,
> 1645688880000,
> 1645689060000,
> 1645689240000,
> 1645689420000,
> 1645689600000,
> 1645689780000,
> 1645689960000,
> 1645690140000,
> 1645690320000,
> 1645690500000,
> 1645690680000,
> 1645690860000,
> 1645691040000,
> 1645691220000,
> 1645691400000,
> 1645691580000,
> 1645691760000,
> 1645691940000,
> 1645692120000,
> 1645692300000,
> 1645692480000,
> 1645692660000,
> 1645692840000,
> 1645693020000,
> 1645693200000,
> 1645693380000,
> 1645693560000,
> 1645693740000,
> 1645693920000,
> 1645694100000,
> 1645694280000,
> 1645694460000,
> 1645694640000,
> 1645694820000,
> 1645695000000
> ],
> "values": [
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> 1,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> 1,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> 1,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> 1,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> 1,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> 1,
> null,
> null,
> null,
> null
> ]
> }
> ]
> }
> ] }
I am trying to extract the request count request count(success, 4xx, 5xx) for each web service under my project. I tried below query , but it is not giving what I am expected.
builtin:service.requestCount.total metric key
https://www.dynatrace.xx.com/e/12345-6539-4ea3-aab8-a9985ae713d4/api/v2/metrics/query?metricSelector=builtin:service.requestCount.total&entitySelector=type(SERVICE)&from=now-6h&resolution=3w&api-token=<token_name>
builtin:service.keyRequest.total.count metric key
https://www.dynatrace.xx.com/e/1234-6539-4ea3-aab8-a9985ae713d4/api/v2/metrics/query?metricSelector=builtin:service.keyRequest.total.count&entitySelector=type(SERVICE)&from=now-6h&resolution=3w&api-token=<token_name>
In multi dimensional analysis chart I could see the count correctly
Can someone help me with the API query, where I can pass the service name as parameter in request and get the request count associated with that service request.
Edited :
Please find below API response for the query
> {
> "totalCount": 2,
> "nextPageKey": null,
> "resolution": "3m",
> "result": [
> {
> "metricId": "builtin:service.requestCount.total:filter(and(in(\"dt.entity.service\",entitySelector(\"type(service),entityName(~\"ControllerName~\")\")))):splitBy(\"dt.entity.service\"):avg:auto:sort(value(avg,descending)):limit(100)",
> "data": [
> {
> "dimensions": [
> "SERVICE-376AE4987839A1D7"
> ],
> "dimensionMap": {
> "dt.entity.service": "SERVICE-376AE4987839A1D7"
> },
> "timestamps": [
> 1645673400000,
> 1645673580000,
> 1645673760000,
> 1645673940000,
> 1645674120000,
> 1645674300000,
> 1645674480000,
> 1645674660000,
> 1645674840000,
> 1645675020000,
> 1645675200000,
> 1645675380000,
> 1645675560000,
> 1645675740000,
> 1645675920000,
> 1645676100000,
> 1645676280000,
> 1645676460000,
> 1645676640000,
> 1645676820000,
> 1645677000000,
> 1645677180000,
> 1645677360000,
> 1645677540000,
> 1645677720000,
> 1645677900000,
> 1645678080000,
> 1645678260000,
> 1645678440000,
> 1645678620000,
> 1645678800000,
> 1645678980000,
> 1645679160000,
> 1645679340000,
> 1645679520000,
> 1645679700000,
> 1645679880000,
> 1645680060000,
> 1645680240000,
> 1645680420000,
> 1645680600000,
> 1645680780000,
> 1645680960000,
> 1645681140000,
> 1645681320000,
> 1645681500000,
> 1645681680000,
> 1645681860000,
> 1645682040000,
> 1645682220000,
> 1645682400000,
> 1645682580000,
> 1645682760000,
> 1645682940000,
> 1645683120000,
> 1645683300000,
> 1645683480000,
> 1645683660000,
> 1645683840000,
> 1645684020000,
> 1645684200000,
> 1645684380000,
> 1645684560000,
> 1645684740000,
> 1645684920000,
> 1645685100000,
> 1645685280000,
> 1645685460000,
> 1645685640000,
> 1645685820000,
> 1645686000000,
> 1645686180000,
> 1645686360000,
> 1645686540000,
> 1645686720000,
> 1645686900000,
> 1645687080000,
> 1645687260000,
> 1645687440000,
> 1645687620000,
> 1645687800000,
> 1645687980000,
> 1645688160000,
> 1645688340000,
> 1645688520000,
> 1645688700000,
> 1645688880000,
> 1645689060000,
> 1645689240000,
> 1645689420000,
> 1645689600000,
> 1645689780000,
> 1645689960000,
> 1645690140000,
> 1645690320000,
> 1645690500000,
> 1645690680000,
> 1645690860000,
> 1645691040000,
> 1645691220000,
> 1645691400000,
> 1645691580000,
> 1645691760000,
> 1645691940000,
> 1645692120000,
> 1645692300000,
> 1645692480000,
> 1645692660000,
> 1645692840000,
> 1645693020000,
> 1645693200000,
> 1645693380000,
> 1645693560000,
> 1645693740000,
> 1645693920000,
> 1645694100000,
> 1645694280000,
> 1645694460000,
> 1645694640000,
> 1645694820000,
> 1645695000000
> ],
> "values": [
> 6,
> null,
> null,
> 1,
> 1,
> null,
> null,
> 2,
> null,
> null,
> 2,
> null,
> null,
> 2,
> 1,
> null,
> null,
> 5,
> 1,
> 4,
> 1,
> 2,
> 6,
> 2,
> 5,
> 7,
> 1,
> 3,
> 3,
> 4,
> null,
> 5,
> 9,
> 8,
> 3,
> 3,
> 4,
> null,
> 3,
> 1,
> 2,
> 3,
> 1,
> 5,
> 2,
> 5,
> null,
> 1,
> 4,
> 1,
> null,
> 2,
> 2,
> 1,
> 1,
> 2,
> 1,
> null,
> 1,
> null,
> null,
> 5,
> 1,
> null,
> null,
> 1,
> 1,
> 4,
> 1,
> null,
> null,
> 2,
> 3,
> null,
> null,
> 2,
> null,
> null,
> 2,
> null,
> 1,
> null,
> 2,
> 2,
> null,
> 2,
> 7,
> 1,
> 1,
> null,
> null,
> 1,
> 1,
> 1,
> 4,
> null,
> null,
> 1,
> null,
> null,
> null,
> 4,
> null,
> 1,
> null,
> 1,
> null,
> null,
> 1,
> null,
> null,
> 5,
> 2,
> 6,
> 5,
> null,
> null,
> 3,
> 2,
> 3,
> null
> ]
> },
> {
> "dimensions": [
> "SERVICE-BC7B97C170AF3FD6"
> ],
> "dimensionMap": {
> "dt.entity.service": "SERVICE-BC7B97C170AF3FD6"
> },
> "timestamps": [
> 1645673400000,
> 1645673580000,
> 1645673760000,
> 1645673940000,
> 1645674120000,
> 1645674300000,
> 1645674480000,
> 1645674660000,
> 1645674840000,
> 1645675020000,
> 1645675200000,
> 1645675380000,
> 1645675560000,
> 1645675740000,
> 1645675920000,
> 1645676100000,
> 1645676280000,
> 1645676460000,
> 1645676640000,
> 1645676820000,
> 1645677000000,
> 1645677180000,
> 1645677360000,
> 1645677540000,
> 1645677720000,
> 1645677900000,
> 1645678080000,
> 1645678260000,
> 1645678440000,
> 1645678620000,
> 1645678800000,
> 1645678980000,
> 1645679160000,
> 1645679340000,
> 1645679520000,
> 1645679700000,
> 1645679880000,
> 1645680060000,
> 1645680240000,
> 1645680420000,
> 1645680600000,
> 1645680780000,
> 1645680960000,
> 1645681140000,
> 1645681320000,
> 1645681500000,
> 1645681680000,
> 1645681860000,
> 1645682040000,
> 1645682220000,
> 1645682400000,
> 1645682580000,
> 1645682760000,
> 1645682940000,
> 1645683120000,
> 1645683300000,
> 1645683480000,
> 1645683660000,
> 1645683840000,
> 1645684020000,
> 1645684200000,
> 1645684380000,
> 1645684560000,
> 1645684740000,
> 1645684920000,
> 1645685100000,
> 1645685280000,
> 1645685460000,
> 1645685640000,
> 1645685820000,
> 1645686000000,
> 1645686180000,
> 1645686360000,
> 1645686540000,
> 1645686720000,
> 1645686900000,
> 1645687080000,
> 1645687260000,
> 1645687440000,
> 1645687620000,
> 1645687800000,
> 1645687980000,
> 1645688160000,
> 1645688340000,
> 1645688520000,
> 1645688700000,
> 1645688880000,
> 1645689060000,
> 1645689240000,
> 1645689420000,
> 1645689600000,
> 1645689780000,
> 1645689960000,
> 1645690140000,
> 1645690320000,
> 1645690500000,
> 1645690680000,
> 1645690860000,
> 1645691040000,
> 1645691220000,
> 1645691400000,
> 1645691580000,
> 1645691760000,
> 1645691940000,
> 1645692120000,
> 1645692300000,
> 1645692480000,
> 1645692660000,
> 1645692840000,
> 1645693020000,
> 1645693200000,
> 1645693380000,
> 1645693560000,
> 1645693740000,
> 1645693920000,
> 1645694100000,
> 1645694280000,
> 1645694460000,
> 1645694640000,
> 1645694820000,
> 1645695000000
> ],
> "values": [
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> 1,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> 1,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> 1,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> 1,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> 1,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> null,
> 1,
> null,
> null,
> null,
> null
> ]
> }
> ]
> }
> ] }
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
这些指标有一个维度
service，即您可以通过服务名称上的filter按某些服务进行过滤。您可以在 UI 中构建、测试和优化查询：
然后使用选项卡
Code查看您也可以在 REST API 中使用的指标选择器：<一个href="https://i.sstatic.net/n2v19.png" rel="nofollow noreferrer">
The metrics have a dimension
service, i.e. you can filter by certain services via thefilteron the service-name.You can build, test and refine the query in the UI:
And then use the tab
Codeto see the metric-selector that you can also use in the REST API:我不知道你最终是否明白了，但
它的响应是一个包含基于时间戳的每个点的数组，类似于动态图。为了获得总金额，您需要执行一些操作：
使用
fold:(sum)，响应一个值（您正在使用添加操作）。常见的数据操作（如中位数、平均值、最大值）也可以工作 - dynatrace 将它们称为聚合；检查文档。
I don't know if you finally figured out, but
Yhe response of this is an array containing each point based on a timestamp, similar to a dynatrace chart. In order to get the total amount, you need to do some operations:
Using
fold:(sum), one single value is responded (you are using an add operation).Common data operations like median, average, máximum works as well—dynatrace call them aggregations; check the documentation.