Chilkat Online Tools

Foxpro / Datadog API Collection / Get monthly usage attribution

Back to Collection Items

LOCAL loHttp
LOCAL lnSuccess
LOCAL loQueryParams
LOCAL loResp
LOCAL loSbResponseBody
LOCAL loJResp
LOCAL lnRespStatusCode
LOCAL lcAgg_type
LOCAL lcField
LOCAL lcValue
LOCAL lcMonth
LOCAL lcOrg_name
LOCAL lcPublic_id
LOCAL lcRegion
LOCAL lcTag_config_source
LOCAL lcUpdated_at
LOCAL lcApi_percentage
LOCAL lcApi_usage
LOCAL lcApm_fargate_percentage
LOCAL lcApm_fargate_usage
LOCAL lcApm_host_percentage
LOCAL lcApm_host_usage
LOCAL lcApm_usm_percentage
LOCAL lcApm_usm_usage
LOCAL lcAppsec_fargate_percentage
LOCAL lcAppsec_fargate_usage
LOCAL lcAppsec_percentage
LOCAL lcAppsec_usage
LOCAL lcBrowser_percentage
LOCAL lcBrowser_usage
LOCAL lcCi_visibility_itr_percentage
LOCAL lcCi_visibility_itr_usage
LOCAL lcContainer_excl_agent_percentage
LOCAL lcContainer_excl_agent_usage
LOCAL lcContainer_percentage
LOCAL lcContainer_usage
LOCAL lcCspm_containers_percentage
LOCAL lcCspm_containers_usage
LOCAL lcCspm_hosts_percentage
LOCAL lcCspm_hosts_usage
LOCAL lcCustom_ingested_timeseries_percentage
LOCAL lcCustom_ingested_timeseries_usage
LOCAL lcCustom_timeseries_percentage
LOCAL lcCustom_timeseries_usage
LOCAL lcCws_containers_percentage
LOCAL lcCws_containers_usage
LOCAL lcCws_hosts_percentage
LOCAL lcCws_hosts_usage
LOCAL lcDbm_hosts_percentage
LOCAL lcDbm_hosts_usage
LOCAL lcDbm_queries_percentage
LOCAL lcDbm_queries_usage
LOCAL lcEstimated_indexed_logs_percentage
LOCAL lcEstimated_indexed_logs_usage
LOCAL lcEstimated_indexed_spans_percentage
LOCAL lcEstimated_indexed_spans_usage
LOCAL lcEstimated_ingested_logs_percentage
LOCAL lcEstimated_ingested_logs_usage
LOCAL lcEstimated_ingested_spans_percentage
LOCAL lcEstimated_ingested_spans_usage
LOCAL lcEstimated_rum_sessions_percentage
LOCAL lcEstimated_rum_sessions_usage
LOCAL lcFargate_percentage
LOCAL lcFargate_usage
LOCAL lcFunctions_percentage
LOCAL lcFunctions_usage
LOCAL lcInfra_host_percentage
LOCAL lcInfra_host_usage
LOCAL lcInvocations_percentage
LOCAL lcInvocations_usage
LOCAL lcNpm_host_percentage
LOCAL lcNpm_host_usage
LOCAL lcObs_pipeline_bytes_percentage
LOCAL lcObs_pipeline_bytes_usage
LOCAL lcProfiled_container_percentage
LOCAL lcProfiled_container_usage
LOCAL lcProfiled_fargate_percentage
LOCAL lcProfiled_fargate_usage
LOCAL lcProfiled_host_percentage
LOCAL lcProfiled_host_usage
LOCAL lcSds_scanned_bytes_percentage
LOCAL lcSds_scanned_bytes_usage
LOCAL lcSnmp_percentage
LOCAL lcSnmp_usage
LOCAL lcUniversal_service_monitoring_percentage
LOCAL lcUniversal_service_monitoring_usage
LOCAL lcVuln_management_hosts_percentage
LOCAL lcVuln_management_hosts_usage
LOCAL j
LOCAL lnCount_j
LOCAL lcStrVal
LOCAL lcNext_record_id
LOCAL i
LOCAL lnCount_i

* This example assumes the Chilkat API to have been previously unlocked.
* See Global Unlock Sample for sample code.

loHttp = CreateObject('Chilkat_9_5_0.Http')

loQueryParams = CreateObject('Chilkat_9_5_0.JsonObject')
loQueryParams.UpdateString("start_month","1991-02-02T07:22:34.204Z")
loQueryParams.UpdateString("end_month","1991-02-02T07:22:34.204Z")
loQueryParams.UpdateString("fields","dbm_queries_usage")
loQueryParams.UpdateString("sort_direction","desc")
loQueryParams.UpdateString("sort_name","dbm_queries_usage")
loQueryParams.UpdateString("tag_breakdown_keys","tempor Ut sed velit")
loQueryParams.UpdateString("next_record_id","tempor Ut sed velit")
loQueryParams.UpdateString("include_descendants","true")

loHttp.SetRequestHeader("Accept","application/json;datetime-format=rfc3339")

loResp = loHttp.QuickRequestParams("GET","https://api.app.ddog-gov.com/api/v1/usage/monthly-attribution",loQueryParams)
IF (loHttp.LastMethodSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loQueryParams
    CANCEL
ENDIF

loSbResponseBody = CreateObject('Chilkat_9_5_0.StringBuilder')
loResp.GetBodySb(loSbResponseBody)

loJResp = CreateObject('Chilkat_9_5_0.JsonObject')
loJResp.LoadSb(loSbResponseBody)
loJResp.EmitCompact = 0

? "Response Body:"
? loJResp.Emit()

lnRespStatusCode = loResp.StatusCode
? "Response Status Code = " + STR(lnRespStatusCode)
IF (lnRespStatusCode >= 400) THEN
    ? "Response Header:"
    ? loResp.Header
    ? "Failed."
    RELEASE loResp
    RELEASE loHttp
    RELEASE loQueryParams
    RELEASE loSbResponseBody
    RELEASE loJResp
    CANCEL
ENDIF

RELEASE loResp

* Sample JSON response:
* (Sample code for parsing the JSON response is shown below)

* {
*   "metadata": {
*     "aggregates": [
*       {
*         "agg_type": "sum",
*         "field": "custom_timeseries_usage",
*         "value": -75872274.11279911
*       },
*       {
*         "agg_type": "sum",
*         "field": "custom_timeseries_usage",
*         "value": 62426608.270860344
*       }
*     ],
*     "pagination": {
*       "next_record_id": "in velit esse"
*     }
*   },
*   "usage": [
*     {
*       "month": "2002-08-13T15:07:13.466Z",
*       "org_name": "elit reprehenderit",
*       "public_id": "minim ipsum anim ",
*       "region": "eu incididunt sint ut",
*       "tag_config_source": "irure laboris culpa",
*       "tags": {
*         "dolore62": [
*           "datadog-integrations-lab",
*           "datadog-integrations-lab"
*         ]
*       },
*       "updated_at": "2006-01-20T21:37:20.788Z",
*       "values": {
*         "api_percentage": -42977723.76246902,
*         "api_usage": 95397982.7763887,
*         "apm_fargate_percentage": 98784807.55202839,
*         "apm_fargate_usage": -5570111.678832486,
*         "apm_host_percentage": -56965575.051769115,
*         "apm_host_usage": 6024527.554351345,
*         "apm_usm_percentage": -44347230.916792005,
*         "apm_usm_usage": -53614973.50940212,
*         "appsec_fargate_percentage": -63949646.084028535,
*         "appsec_fargate_usage": -13950059.836552203,
*         "appsec_percentage": 77503688.59718463,
*         "appsec_usage": -2749536.490563825,
*         "browser_percentage": -57610165.63884018,
*         "browser_usage": -61629554.27924777,
*         "ci_visibility_itr_percentage": 9801397.272425354,
*         "ci_visibility_itr_usage": 86901082.07052395,
*         "container_excl_agent_percentage": -94758211.3791813,
*         "container_excl_agent_usage": 47871386.536788315,
*         "container_percentage": 77684191.36010852,
*         "container_usage": 42244878.990811646,
*         "cspm_containers_percentage": -27358203.524139896,
*         "cspm_containers_usage": 7194834.822350323,
*         "cspm_hosts_percentage": -58400939.80376841,
*         "cspm_hosts_usage": -13088798.55443798,
*         "custom_ingested_timeseries_percentage": 25418473.141955733,
*         "custom_ingested_timeseries_usage": -6930274.896374792,
*         "custom_timeseries_percentage": 57087072.053094536,
*         "custom_timeseries_usage": -96533528.35676041,
*         "cws_containers_percentage": 38802199.2161935,
*         "cws_containers_usage": -48037945.78847249,
*         "cws_hosts_percentage": -38139753.73665444,
*         "cws_hosts_usage": 99175833.09167394,
*         "dbm_hosts_percentage": -89557128.20902187,
*         "dbm_hosts_usage": -2062788.2317033857,
*         "dbm_queries_percentage": -81088882.42935035,
*         "dbm_queries_usage": 1723401.8763353676,
*         "estimated_indexed_logs_percentage": 19494055.047132045,
*         "estimated_indexed_logs_usage": 10830691.252756879,
*         "estimated_indexed_spans_percentage": 62593562.02511239,
*         "estimated_indexed_spans_usage": -47185922.657971926,
*         "estimated_ingested_logs_percentage": 87624062.51598707,
*         "estimated_ingested_logs_usage": -35910323.49944707,
*         "estimated_ingested_spans_percentage": -26620688.87925279,
*         "estimated_ingested_spans_usage": -55965088.442498125,
*         "estimated_rum_sessions_percentage": -89351036.0053822,
*         "estimated_rum_sessions_usage": 69102190.52327245,
*         "fargate_percentage": 31062755.564841017,
*         "fargate_usage": 47033739.82451412,
*         "functions_percentage": 53367355.86064315,
*         "functions_usage": 11045136.755249456,
*         "infra_host_percentage": -54626318.30325018,
*         "infra_host_usage": 5481953.102816388,
*         "invocations_percentage": 27641232.88982962,
*         "invocations_usage": -23217061.12940158,
*         "npm_host_percentage": -70428889.89530578,
*         "npm_host_usage": 75035524.55544943,
*         "obs_pipeline_bytes_percentage": 95030078.61571154,
*         "obs_pipeline_bytes_usage": 16308063.424261168,
*         "profiled_container_percentage": -47294745.9171313,
*         "profiled_container_usage": 91333575.12025896,
*         "profiled_fargate_percentage": 1159081.2940575331,
*         "profiled_fargate_usage": 46737078.93751609,
*         "profiled_host_percentage": -16133546.561951116,
*         "profiled_host_usage": -55598728.99167555,
*         "sds_scanned_bytes_percentage": 41324136.36835453,
*         "sds_scanned_bytes_usage": 56766327.929751456,
*         "snmp_percentage": -88823427.70029327,
*         "snmp_usage": 32225665.615818232,
*         "universal_service_monitoring_percentage": -79287423.3883524,
*         "universal_service_monitoring_usage": -2355924.928932488,
*         "vuln_management_hosts_percentage": -16935520.54186198,
*         "vuln_management_hosts_usage": 74036018.8908129
*       }
*     },
*     {
*       "month": "1959-07-18T20:29:56.664Z",
*       "org_name": "aliquip magna dolor",
*       "public_id": "et iru",
*       "region": "ut est esse ex",
*       "tag_config_source": "sint",
*       "tags": {
*         "elit276": [
*           "datadog-integrations-lab",
*           "datadog-integrations-lab"
*         ],
*         "minim63": [
*           "datadog-integrations-lab",
*           "datadog-integrations-lab"
*         ],
*         "pariatur_d4": [
*           "datadog-integrations-lab",
*           "datadog-integrations-lab"
*         ]
*       },
*       "updated_at": "1950-10-12T07:16:52.126Z",
*       "values": {
*         "api_percentage": -67093975.89355124,
*         "api_usage": 22892492.134701967,
*         "apm_fargate_percentage": 86445539.6960246,
*         "apm_fargate_usage": 96626296.86785325,
*         "apm_host_percentage": -17829260.52661082,
*         "apm_host_usage": 99024863.04694226,
*         "apm_usm_percentage": 15052506.96019815,
*         "apm_usm_usage": -51446462.70068289,
*         "appsec_fargate_percentage": -59920029.75633368,
*         "appsec_fargate_usage": -12417338.286942497,
*         "appsec_percentage": 33591696.66073081,
*         "appsec_usage": 25137188.487309366,
*         "browser_percentage": 97940358.7215335,
*         "browser_usage": -52673885.905316986,
*         "ci_visibility_itr_percentage": -88219975.69687605,
*         "ci_visibility_itr_usage": -9447846.575050354,
*         "container_excl_agent_percentage": -46735760.53814248,
*         "container_excl_agent_usage": -73167643.29069096,
*         "container_percentage": 69642254.33344507,
*         "container_usage": 41091259.60962516,
*         "cspm_containers_percentage": 42210153.5692417,
*         "cspm_containers_usage": 75649568.34254551,
*         "cspm_hosts_percentage": 32418249.39784172,
*         "cspm_hosts_usage": 69540549.39095044,
*         "custom_ingested_timeseries_percentage": -68775982.9429293,
*         "custom_ingested_timeseries_usage": 76963891.89494428,
*         "custom_timeseries_percentage": 60837059.719377786,
*         "custom_timeseries_usage": -18989551.834226012,
*         "cws_containers_percentage": -72647861.32948461,
*         "cws_containers_usage": 99339681.5271622,
*         "cws_hosts_percentage": -83440078.50328308,
*         "cws_hosts_usage": 14084142.169001937,
*         "dbm_hosts_percentage": 82967791.28126338,
*         "dbm_hosts_usage": 25758868.864204437,
*         "dbm_queries_percentage": -66889696.73566167,
*         "dbm_queries_usage": 82584001.9588587,
*         "estimated_indexed_logs_percentage": 18445591.7106888,
*         "estimated_indexed_logs_usage": 95113838.43812409,
*         "estimated_indexed_spans_percentage": -60446633.38281309,
*         "estimated_indexed_spans_usage": -35817307.54312336,
*         "estimated_ingested_logs_percentage": -78223744.53046979,
*         "estimated_ingested_logs_usage": -69451886.32509902,
*         "estimated_ingested_spans_percentage": 40809724.25659558,
*         "estimated_ingested_spans_usage": -8599266.75406441,
*         "estimated_rum_sessions_percentage": -50403382.65600939,
*         "estimated_rum_sessions_usage": -56068159.05777034,
*         "fargate_percentage": -58215167.93972128,
*         "fargate_usage": 66587355.106164634,
*         "functions_percentage": -47256769.918816224,
*         "functions_usage": 1210604.9136780202,
*         "infra_host_percentage": -15651911.45215477,
*         "infra_host_usage": 83986438.03159028,
*         "invocations_percentage": -72916419.47570357,
*         "invocations_usage": -99391776.91322954,
*         "npm_host_percentage": -26689735.74485798,
*         "npm_host_usage": -58545960.56280492,
*         "obs_pipeline_bytes_percentage": -18838497.449270487,
*         "obs_pipeline_bytes_usage": -15181917.208459169,
*         "profiled_container_percentage": -69415049.22818953,
*         "profiled_container_usage": -22422349.354449615,
*         "profiled_fargate_percentage": -88757833.10218939,
*         "profiled_fargate_usage": -48134372.15719563,
*         "profiled_host_percentage": -82357525.04911637,
*         "profiled_host_usage": 50907558.67759526,
*         "sds_scanned_bytes_percentage": -72420339.71282078,
*         "sds_scanned_bytes_usage": 54343122.17874324,
*         "snmp_percentage": -38192297.57339508,
*         "snmp_usage": 26362518.073974475,
*         "universal_service_monitoring_percentage": -97356790.37923175,
*         "universal_service_monitoring_usage": -42030474.203919254,
*         "vuln_management_hosts_percentage": -74076816.34914787,
*         "vuln_management_hosts_usage": -25114557.39136301
*       }
*     }
*   ]
* }

* Sample code for parsing the JSON response...
* Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code

lcNext_record_id = loJResp.StringOf("metadata.pagination.next_record_id")
i = 0
lnCount_i = loJResp.SizeOfArray("metadata.aggregates")
DO WHILE i < lnCount_i
    loJResp.I = i
    lcAgg_type = loJResp.StringOf("metadata.aggregates[i].agg_type")
    lcField = loJResp.StringOf("metadata.aggregates[i].field")
    lcValue = loJResp.StringOf("metadata.aggregates[i].value")
    i = i + 1
ENDDO
i = 0
lnCount_i = loJResp.SizeOfArray("usage")
DO WHILE i < lnCount_i
    loJResp.I = i
    lcMonth = loJResp.StringOf("usage[i].month")
    lcOrg_name = loJResp.StringOf("usage[i].org_name")
    lcPublic_id = loJResp.StringOf("usage[i].public_id")
    lcRegion = loJResp.StringOf("usage[i].region")
    lcTag_config_source = loJResp.StringOf("usage[i].tag_config_source")
    lcUpdated_at = loJResp.StringOf("usage[i].updated_at")
    lcApi_percentage = loJResp.StringOf("usage[i].values.api_percentage")
    lcApi_usage = loJResp.StringOf("usage[i].values.api_usage")
    lcApm_fargate_percentage = loJResp.StringOf("usage[i].values.apm_fargate_percentage")
    lcApm_fargate_usage = loJResp.StringOf("usage[i].values.apm_fargate_usage")
    lcApm_host_percentage = loJResp.StringOf("usage[i].values.apm_host_percentage")
    lcApm_host_usage = loJResp.StringOf("usage[i].values.apm_host_usage")
    lcApm_usm_percentage = loJResp.StringOf("usage[i].values.apm_usm_percentage")
    lcApm_usm_usage = loJResp.StringOf("usage[i].values.apm_usm_usage")
    lcAppsec_fargate_percentage = loJResp.StringOf("usage[i].values.appsec_fargate_percentage")
    lcAppsec_fargate_usage = loJResp.StringOf("usage[i].values.appsec_fargate_usage")
    lcAppsec_percentage = loJResp.StringOf("usage[i].values.appsec_percentage")
    lcAppsec_usage = loJResp.StringOf("usage[i].values.appsec_usage")
    lcBrowser_percentage = loJResp.StringOf("usage[i].values.browser_percentage")
    lcBrowser_usage = loJResp.StringOf("usage[i].values.browser_usage")
    lcCi_visibility_itr_percentage = loJResp.StringOf("usage[i].values.ci_visibility_itr_percentage")
    lcCi_visibility_itr_usage = loJResp.StringOf("usage[i].values.ci_visibility_itr_usage")
    lcContainer_excl_agent_percentage = loJResp.StringOf("usage[i].values.container_excl_agent_percentage")
    lcContainer_excl_agent_usage = loJResp.StringOf("usage[i].values.container_excl_agent_usage")
    lcContainer_percentage = loJResp.StringOf("usage[i].values.container_percentage")
    lcContainer_usage = loJResp.StringOf("usage[i].values.container_usage")
    lcCspm_containers_percentage = loJResp.StringOf("usage[i].values.cspm_containers_percentage")
    lcCspm_containers_usage = loJResp.StringOf("usage[i].values.cspm_containers_usage")
    lcCspm_hosts_percentage = loJResp.StringOf("usage[i].values.cspm_hosts_percentage")
    lcCspm_hosts_usage = loJResp.StringOf("usage[i].values.cspm_hosts_usage")
    lcCustom_ingested_timeseries_percentage = loJResp.StringOf("usage[i].values.custom_ingested_timeseries_percentage")
    lcCustom_ingested_timeseries_usage = loJResp.StringOf("usage[i].values.custom_ingested_timeseries_usage")
    lcCustom_timeseries_percentage = loJResp.StringOf("usage[i].values.custom_timeseries_percentage")
    lcCustom_timeseries_usage = loJResp.StringOf("usage[i].values.custom_timeseries_usage")
    lcCws_containers_percentage = loJResp.StringOf("usage[i].values.cws_containers_percentage")
    lcCws_containers_usage = loJResp.StringOf("usage[i].values.cws_containers_usage")
    lcCws_hosts_percentage = loJResp.StringOf("usage[i].values.cws_hosts_percentage")
    lcCws_hosts_usage = loJResp.StringOf("usage[i].values.cws_hosts_usage")
    lcDbm_hosts_percentage = loJResp.StringOf("usage[i].values.dbm_hosts_percentage")
    lcDbm_hosts_usage = loJResp.StringOf("usage[i].values.dbm_hosts_usage")
    lcDbm_queries_percentage = loJResp.StringOf("usage[i].values.dbm_queries_percentage")
    lcDbm_queries_usage = loJResp.StringOf("usage[i].values.dbm_queries_usage")
    lcEstimated_indexed_logs_percentage = loJResp.StringOf("usage[i].values.estimated_indexed_logs_percentage")
    lcEstimated_indexed_logs_usage = loJResp.StringOf("usage[i].values.estimated_indexed_logs_usage")
    lcEstimated_indexed_spans_percentage = loJResp.StringOf("usage[i].values.estimated_indexed_spans_percentage")
    lcEstimated_indexed_spans_usage = loJResp.StringOf("usage[i].values.estimated_indexed_spans_usage")
    lcEstimated_ingested_logs_percentage = loJResp.StringOf("usage[i].values.estimated_ingested_logs_percentage")
    lcEstimated_ingested_logs_usage = loJResp.StringOf("usage[i].values.estimated_ingested_logs_usage")
    lcEstimated_ingested_spans_percentage = loJResp.StringOf("usage[i].values.estimated_ingested_spans_percentage")
    lcEstimated_ingested_spans_usage = loJResp.StringOf("usage[i].values.estimated_ingested_spans_usage")
    lcEstimated_rum_sessions_percentage = loJResp.StringOf("usage[i].values.estimated_rum_sessions_percentage")
    lcEstimated_rum_sessions_usage = loJResp.StringOf("usage[i].values.estimated_rum_sessions_usage")
    lcFargate_percentage = loJResp.StringOf("usage[i].values.fargate_percentage")
    lcFargate_usage = loJResp.StringOf("usage[i].values.fargate_usage")
    lcFunctions_percentage = loJResp.StringOf("usage[i].values.functions_percentage")
    lcFunctions_usage = loJResp.StringOf("usage[i].values.functions_usage")
    lcInfra_host_percentage = loJResp.StringOf("usage[i].values.infra_host_percentage")
    lcInfra_host_usage = loJResp.StringOf("usage[i].values.infra_host_usage")
    lcInvocations_percentage = loJResp.StringOf("usage[i].values.invocations_percentage")
    lcInvocations_usage = loJResp.StringOf("usage[i].values.invocations_usage")
    lcNpm_host_percentage = loJResp.StringOf("usage[i].values.npm_host_percentage")
    lcNpm_host_usage = loJResp.StringOf("usage[i].values.npm_host_usage")
    lcObs_pipeline_bytes_percentage = loJResp.StringOf("usage[i].values.obs_pipeline_bytes_percentage")
    lcObs_pipeline_bytes_usage = loJResp.StringOf("usage[i].values.obs_pipeline_bytes_usage")
    lcProfiled_container_percentage = loJResp.StringOf("usage[i].values.profiled_container_percentage")
    lcProfiled_container_usage = loJResp.StringOf("usage[i].values.profiled_container_usage")
    lcProfiled_fargate_percentage = loJResp.StringOf("usage[i].values.profiled_fargate_percentage")
    lcProfiled_fargate_usage = loJResp.StringOf("usage[i].values.profiled_fargate_usage")
    lcProfiled_host_percentage = loJResp.StringOf("usage[i].values.profiled_host_percentage")
    lcProfiled_host_usage = loJResp.StringOf("usage[i].values.profiled_host_usage")
    lcSds_scanned_bytes_percentage = loJResp.StringOf("usage[i].values.sds_scanned_bytes_percentage")
    lcSds_scanned_bytes_usage = loJResp.StringOf("usage[i].values.sds_scanned_bytes_usage")
    lcSnmp_percentage = loJResp.StringOf("usage[i].values.snmp_percentage")
    lcSnmp_usage = loJResp.StringOf("usage[i].values.snmp_usage")
    lcUniversal_service_monitoring_percentage = loJResp.StringOf("usage[i].values.universal_service_monitoring_percentage")
    lcUniversal_service_monitoring_usage = loJResp.StringOf("usage[i].values.universal_service_monitoring_usage")
    lcVuln_management_hosts_percentage = loJResp.StringOf("usage[i].values.vuln_management_hosts_percentage")
    lcVuln_management_hosts_usage = loJResp.StringOf("usage[i].values.vuln_management_hosts_usage")
    j = 0
    lnCount_j = loJResp.SizeOfArray("usage[i].tags.dolore62")
    DO WHILE j < lnCount_j
        loJResp.J = j
        lcStrVal = loJResp.StringOf("usage[i].tags.dolore62[j]")
        j = j + 1
    ENDDO
    j = 0
    lnCount_j = loJResp.SizeOfArray("usage[i].tags.elit276")
    DO WHILE j < lnCount_j
        loJResp.J = j
        lcStrVal = loJResp.StringOf("usage[i].tags.elit276[j]")
        j = j + 1
    ENDDO
    j = 0
    lnCount_j = loJResp.SizeOfArray("usage[i].tags.minim63")
    DO WHILE j < lnCount_j
        loJResp.J = j
        lcStrVal = loJResp.StringOf("usage[i].tags.minim63[j]")
        j = j + 1
    ENDDO
    j = 0
    lnCount_j = loJResp.SizeOfArray("usage[i].tags.pariatur_d4")
    DO WHILE j < lnCount_j
        loJResp.J = j
        lcStrVal = loJResp.StringOf("usage[i].tags.pariatur_d4[j]")
        j = j + 1
    ENDDO
    i = i + 1
ENDDO

RELEASE loHttp
RELEASE loQueryParams
RELEASE loSbResponseBody
RELEASE loJResp

Curl Command

curl -G -d "start_month=1991-02-02T07%3A22%3A34.204Z"
	-d "end_month=1991-02-02T07%3A22%3A34.204Z"
	-d "fields=dbm_queries_usage"
	-d "sort_direction=desc"
	-d "sort_name=dbm_queries_usage"
	-d "tag_breakdown_keys=tempor%20Ut%20sed%20velit"
	-d "next_record_id=tempor%20Ut%20sed%20velit"
	-d "include_descendants=true"
	-H "Accept: application/json;datetime-format=rfc3339"
https://api.app.ddog-gov.com/api/v1/usage/monthly-attribution

Postman Collection Item JSON

{
  "name": "Get monthly usage attribution",
  "request": {
    "method": "GET",
    "header": [
      {
        "key": "Accept",
        "value": "application/json;datetime-format=rfc3339"
      }
    ],
    "url": {
      "raw": "{{baseUrl}}/api/v1/usage/monthly-attribution?start_month=1991-02-02T07:22:34.204Z&end_month=1991-02-02T07:22:34.204Z&fields=dbm_queries_usage&sort_direction=desc&sort_name=dbm_queries_usage&tag_breakdown_keys=tempor Ut sed velit&next_record_id=tempor Ut sed velit&include_descendants=true",
      "host": [
        "{{baseUrl}}"
      ],
      "path": [
        "api",
        "v1",
        "usage",
        "monthly-attribution"
      ],
      "query": [
        {
          "key": "start_month",
          "value": "1991-02-02T07:22:34.204Z",
          "description": "(Required) Datetime in ISO-8601 format, UTC, precise to month: `[YYYY-MM]` for usage beginning in this month.\nMaximum of 15 months ago."
        },
        {
          "key": "end_month",
          "value": "1991-02-02T07:22:34.204Z",
          "description": "Datetime in ISO-8601 format, UTC, precise to month: `[YYYY-MM]` for usage ending this month."
        },
        {
          "key": "fields",
          "value": "dbm_queries_usage",
          "description": "(Required) Comma-separated list of usage types to return, or `*` for all usage types."
        },
        {
          "key": "sort_direction",
          "value": "desc",
          "description": "The direction to sort by: `[desc, asc]`."
        },
        {
          "key": "sort_name",
          "value": "dbm_queries_usage",
          "description": "The field to sort by."
        },
        {
          "key": "tag_breakdown_keys",
          "value": "tempor Ut sed velit",
          "description": "Comma separated list of tag keys used to group usage. If no value is provided the usage will not be broken down by tags.\n\nTo see which tags are available, look for the value of `tag_config_source` in the API response."
        },
        {
          "key": "next_record_id",
          "value": "tempor Ut sed velit",
          "description": "List following results with a next_record_id provided in the previous query."
        },
        {
          "key": "include_descendants",
          "value": "true",
          "description": "Include child org usage in the response. Defaults to `true`."
        }
      ]
    },
    "description": "Get monthly usage attribution. Multi-region data is available starting March 1, 2023.\n\nThis API endpoint is paginated. To make sure you receive all records, check if the value of `next_record_id` is\nset in the response. If it is, make another request and pass `next_record_id` as a parameter.\nPseudo code example:\n\n```\nresponse := GetMonthlyUsageAttribution(start_month)\ncursor := response.metadata.pagination.next_record_id\nWHILE cursor != null BEGIN\n  sleep(5 seconds)  # Avoid running into rate limit\n  response := GetMonthlyUsageAttribution(start_month, next_record_id=cursor)\n  cursor := response.metadata.pagination.next_record_id\nEND\n```"
  },
  "response": [
    {
      "name": "OK",
      "originalRequest": {
        "method": "GET",
        "header": [
          {
            "key": "Accept",
            "value": "application/json;datetime-format=rfc3339"
          },
          {
            "description": "Added as a part of security scheme: apikey",
            "key": "DD-API-KEY",
            "value": "<API Key>"
          }
        ],
        "url": {
          "raw": "{{baseUrl}}/api/v1/usage/monthly-attribution?start_month=1991-02-02T07:22:34.204Z&end_month=1991-02-02T07:22:34.204Z&fields=dbm_queries_usage&sort_direction=desc&sort_name=dbm_queries_usage&tag_breakdown_keys=tempor Ut sed velit&next_record_id=tempor Ut sed velit&include_descendants=true",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "v1",
            "usage",
            "monthly-attribution"
          ],
          "query": [
            {
              "key": "start_month",
              "value": "1991-02-02T07:22:34.204Z",
              "description": "(Required) Datetime in ISO-8601 format, UTC, precise to month: `[YYYY-MM]` for usage beginning in this month.\nMaximum of 15 months ago."
            },
            {
              "key": "end_month",
              "value": "1991-02-02T07:22:34.204Z",
              "description": "Datetime in ISO-8601 format, UTC, precise to month: `[YYYY-MM]` for usage ending this month."
            },
            {
              "key": "fields",
              "value": "dbm_queries_usage",
              "description": "(Required) Comma-separated list of usage types to return, or `*` for all usage types."
            },
            {
              "key": "sort_direction",
              "value": "desc",
              "description": "The direction to sort by: `[desc, asc]`."
            },
            {
              "key": "sort_name",
              "value": "dbm_queries_usage",
              "description": "The field to sort by."
            },
            {
              "key": "tag_breakdown_keys",
              "value": "tempor Ut sed velit",
              "description": "Comma separated list of tag keys used to group usage. If no value is provided the usage will not be broken down by tags.\n\nTo see which tags are available, look for the value of `tag_config_source` in the API response."
            },
            {
              "key": "next_record_id",
              "value": "tempor Ut sed velit",
              "description": "List following results with a next_record_id provided in the previous query."
            },
            {
              "key": "include_descendants",
              "value": "true",
              "description": "Include child org usage in the response. Defaults to `true`."
            }
          ]
        }
      },
      "status": "OK",
      "code": 200,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Content-Type",
          "value": "application/json;datetime-format=rfc3339"
        }
      ],
      "cookie": [
      ],
      "body": "{\n  \"metadata\": {\n    \"aggregates\": [\n      {\n        \"agg_type\": \"sum\",\n        \"field\": \"custom_timeseries_usage\",\n        \"value\": -75872274.11279911\n      },\n      {\n        \"agg_type\": \"sum\",\n        \"field\": \"custom_timeseries_usage\",\n        \"value\": 62426608.270860344\n      }\n    ],\n    \"pagination\": {\n      \"next_record_id\": \"in velit esse\"\n    }\n  },\n  \"usage\": [\n    {\n      \"month\": \"2002-08-13T15:07:13.466Z\",\n      \"org_name\": \"elit reprehenderit\",\n      \"public_id\": \"minim ipsum anim \",\n      \"region\": \"eu incididunt sint ut\",\n      \"tag_config_source\": \"irure laboris culpa\",\n      \"tags\": {\n        \"dolore62\": [\n          \"datadog-integrations-lab\",\n          \"datadog-integrations-lab\"\n        ]\n      },\n      \"updated_at\": \"2006-01-20T21:37:20.788Z\",\n      \"values\": {\n        \"api_percentage\": -42977723.76246902,\n        \"api_usage\": 95397982.7763887,\n        \"apm_fargate_percentage\": 98784807.55202839,\n        \"apm_fargate_usage\": -5570111.678832486,\n        \"apm_host_percentage\": -56965575.051769115,\n        \"apm_host_usage\": 6024527.554351345,\n        \"apm_usm_percentage\": -44347230.916792005,\n        \"apm_usm_usage\": -53614973.50940212,\n        \"appsec_fargate_percentage\": -63949646.084028535,\n        \"appsec_fargate_usage\": -13950059.836552203,\n        \"appsec_percentage\": 77503688.59718463,\n        \"appsec_usage\": -2749536.490563825,\n        \"browser_percentage\": -57610165.63884018,\n        \"browser_usage\": -61629554.27924777,\n        \"ci_visibility_itr_percentage\": 9801397.272425354,\n        \"ci_visibility_itr_usage\": 86901082.07052395,\n        \"container_excl_agent_percentage\": -94758211.3791813,\n        \"container_excl_agent_usage\": 47871386.536788315,\n        \"container_percentage\": 77684191.36010852,\n        \"container_usage\": 42244878.990811646,\n        \"cspm_containers_percentage\": -27358203.524139896,\n        \"cspm_containers_usage\": 7194834.822350323,\n        \"cspm_hosts_percentage\": -58400939.80376841,\n        \"cspm_hosts_usage\": -13088798.55443798,\n        \"custom_ingested_timeseries_percentage\": 25418473.141955733,\n        \"custom_ingested_timeseries_usage\": -6930274.896374792,\n        \"custom_timeseries_percentage\": 57087072.053094536,\n        \"custom_timeseries_usage\": -96533528.35676041,\n        \"cws_containers_percentage\": 38802199.2161935,\n        \"cws_containers_usage\": -48037945.78847249,\n        \"cws_hosts_percentage\": -38139753.73665444,\n        \"cws_hosts_usage\": 99175833.09167394,\n        \"dbm_hosts_percentage\": -89557128.20902187,\n        \"dbm_hosts_usage\": -2062788.2317033857,\n        \"dbm_queries_percentage\": -81088882.42935035,\n        \"dbm_queries_usage\": 1723401.8763353676,\n        \"estimated_indexed_logs_percentage\": 19494055.047132045,\n        \"estimated_indexed_logs_usage\": 10830691.252756879,\n        \"estimated_indexed_spans_percentage\": 62593562.02511239,\n        \"estimated_indexed_spans_usage\": -47185922.657971926,\n        \"estimated_ingested_logs_percentage\": 87624062.51598707,\n        \"estimated_ingested_logs_usage\": -35910323.49944707,\n        \"estimated_ingested_spans_percentage\": -26620688.87925279,\n        \"estimated_ingested_spans_usage\": -55965088.442498125,\n        \"estimated_rum_sessions_percentage\": -89351036.0053822,\n        \"estimated_rum_sessions_usage\": 69102190.52327245,\n        \"fargate_percentage\": 31062755.564841017,\n        \"fargate_usage\": 47033739.82451412,\n        \"functions_percentage\": 53367355.86064315,\n        \"functions_usage\": 11045136.755249456,\n        \"infra_host_percentage\": -54626318.30325018,\n        \"infra_host_usage\": 5481953.102816388,\n        \"invocations_percentage\": 27641232.88982962,\n        \"invocations_usage\": -23217061.12940158,\n        \"npm_host_percentage\": -70428889.89530578,\n        \"npm_host_usage\": 75035524.55544943,\n        \"obs_pipeline_bytes_percentage\": 95030078.61571154,\n        \"obs_pipeline_bytes_usage\": 16308063.424261168,\n        \"profiled_container_percentage\": -47294745.9171313,\n        \"profiled_container_usage\": 91333575.12025896,\n        \"profiled_fargate_percentage\": 1159081.2940575331,\n        \"profiled_fargate_usage\": 46737078.93751609,\n        \"profiled_host_percentage\": -16133546.561951116,\n        \"profiled_host_usage\": -55598728.99167555,\n        \"sds_scanned_bytes_percentage\": 41324136.36835453,\n        \"sds_scanned_bytes_usage\": 56766327.929751456,\n        \"snmp_percentage\": -88823427.70029327,\n        \"snmp_usage\": 32225665.615818232,\n        \"universal_service_monitoring_percentage\": -79287423.3883524,\n        \"universal_service_monitoring_usage\": -2355924.928932488,\n        \"vuln_management_hosts_percentage\": -16935520.54186198,\n        \"vuln_management_hosts_usage\": 74036018.8908129\n      }\n    },\n    {\n      \"month\": \"1959-07-18T20:29:56.664Z\",\n      \"org_name\": \"aliquip magna dolor\",\n      \"public_id\": \"et iru\",\n      \"region\": \"ut est esse ex\",\n      \"tag_config_source\": \"sint\",\n      \"tags\": {\n        \"elit276\": [\n          \"datadog-integrations-lab\",\n          \"datadog-integrations-lab\"\n        ],\n        \"minim63\": [\n          \"datadog-integrations-lab\",\n          \"datadog-integrations-lab\"\n        ],\n        \"pariatur_d4\": [\n          \"datadog-integrations-lab\",\n          \"datadog-integrations-lab\"\n        ]\n      },\n      \"updated_at\": \"1950-10-12T07:16:52.126Z\",\n      \"values\": {\n        \"api_percentage\": -67093975.89355124,\n        \"api_usage\": 22892492.134701967,\n        \"apm_fargate_percentage\": 86445539.6960246,\n        \"apm_fargate_usage\": 96626296.86785325,\n        \"apm_host_percentage\": -17829260.52661082,\n        \"apm_host_usage\": 99024863.04694226,\n        \"apm_usm_percentage\": 15052506.96019815,\n        \"apm_usm_usage\": -51446462.70068289,\n        \"appsec_fargate_percentage\": -59920029.75633368,\n        \"appsec_fargate_usage\": -12417338.286942497,\n        \"appsec_percentage\": 33591696.66073081,\n        \"appsec_usage\": 25137188.487309366,\n        \"browser_percentage\": 97940358.7215335,\n        \"browser_usage\": -52673885.905316986,\n        \"ci_visibility_itr_percentage\": -88219975.69687605,\n        \"ci_visibility_itr_usage\": -9447846.575050354,\n        \"container_excl_agent_percentage\": -46735760.53814248,\n        \"container_excl_agent_usage\": -73167643.29069096,\n        \"container_percentage\": 69642254.33344507,\n        \"container_usage\": 41091259.60962516,\n        \"cspm_containers_percentage\": 42210153.5692417,\n        \"cspm_containers_usage\": 75649568.34254551,\n        \"cspm_hosts_percentage\": 32418249.39784172,\n        \"cspm_hosts_usage\": 69540549.39095044,\n        \"custom_ingested_timeseries_percentage\": -68775982.9429293,\n        \"custom_ingested_timeseries_usage\": 76963891.89494428,\n        \"custom_timeseries_percentage\": 60837059.719377786,\n        \"custom_timeseries_usage\": -18989551.834226012,\n        \"cws_containers_percentage\": -72647861.32948461,\n        \"cws_containers_usage\": 99339681.5271622,\n        \"cws_hosts_percentage\": -83440078.50328308,\n        \"cws_hosts_usage\": 14084142.169001937,\n        \"dbm_hosts_percentage\": 82967791.28126338,\n        \"dbm_hosts_usage\": 25758868.864204437,\n        \"dbm_queries_percentage\": -66889696.73566167,\n        \"dbm_queries_usage\": 82584001.9588587,\n        \"estimated_indexed_logs_percentage\": 18445591.7106888,\n        \"estimated_indexed_logs_usage\": 95113838.43812409,\n        \"estimated_indexed_spans_percentage\": -60446633.38281309,\n        \"estimated_indexed_spans_usage\": -35817307.54312336,\n        \"estimated_ingested_logs_percentage\": -78223744.53046979,\n        \"estimated_ingested_logs_usage\": -69451886.32509902,\n        \"estimated_ingested_spans_percentage\": 40809724.25659558,\n        \"estimated_ingested_spans_usage\": -8599266.75406441,\n        \"estimated_rum_sessions_percentage\": -50403382.65600939,\n        \"estimated_rum_sessions_usage\": -56068159.05777034,\n        \"fargate_percentage\": -58215167.93972128,\n        \"fargate_usage\": 66587355.106164634,\n        \"functions_percentage\": -47256769.918816224,\n        \"functions_usage\": 1210604.9136780202,\n        \"infra_host_percentage\": -15651911.45215477,\n        \"infra_host_usage\": 83986438.03159028,\n        \"invocations_percentage\": -72916419.47570357,\n        \"invocations_usage\": -99391776.91322954,\n        \"npm_host_percentage\": -26689735.74485798,\n        \"npm_host_usage\": -58545960.56280492,\n        \"obs_pipeline_bytes_percentage\": -18838497.449270487,\n        \"obs_pipeline_bytes_usage\": -15181917.208459169,\n        \"profiled_container_percentage\": -69415049.22818953,\n        \"profiled_container_usage\": -22422349.354449615,\n        \"profiled_fargate_percentage\": -88757833.10218939,\n        \"profiled_fargate_usage\": -48134372.15719563,\n        \"profiled_host_percentage\": -82357525.04911637,\n        \"profiled_host_usage\": 50907558.67759526,\n        \"sds_scanned_bytes_percentage\": -72420339.71282078,\n        \"sds_scanned_bytes_usage\": 54343122.17874324,\n        \"snmp_percentage\": -38192297.57339508,\n        \"snmp_usage\": 26362518.073974475,\n        \"universal_service_monitoring_percentage\": -97356790.37923175,\n        \"universal_service_monitoring_usage\": -42030474.203919254,\n        \"vuln_management_hosts_percentage\": -74076816.34914787,\n        \"vuln_management_hosts_usage\": -25114557.39136301\n      }\n    }\n  ]\n}"
    },
    {
      "name": "Forbidden - User is not authorized",
      "originalRequest": {
        "method": "GET",
        "header": [
          {
            "key": "Accept",
            "value": "application/json;datetime-format=rfc3339"
          },
          {
            "description": "Added as a part of security scheme: apikey",
            "key": "DD-API-KEY",
            "value": "<API Key>"
          }
        ],
        "url": {
          "raw": "{{baseUrl}}/api/v1/usage/monthly-attribution?start_month=1991-02-02T07:22:34.204Z&end_month=1991-02-02T07:22:34.204Z&fields=dbm_queries_usage&sort_direction=desc&sort_name=dbm_queries_usage&tag_breakdown_keys=tempor Ut sed velit&next_record_id=tempor Ut sed velit&include_descendants=true",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "v1",
            "usage",
            "monthly-attribution"
          ],
          "query": [
            {
              "key": "start_month",
              "value": "1991-02-02T07:22:34.204Z",
              "description": "(Required) Datetime in ISO-8601 format, UTC, precise to month: `[YYYY-MM]` for usage beginning in this month.\nMaximum of 15 months ago."
            },
            {
              "key": "end_month",
              "value": "1991-02-02T07:22:34.204Z",
              "description": "Datetime in ISO-8601 format, UTC, precise to month: `[YYYY-MM]` for usage ending this month."
            },
            {
              "key": "fields",
              "value": "dbm_queries_usage",
              "description": "(Required) Comma-separated list of usage types to return, or `*` for all usage types."
            },
            {
              "key": "sort_direction",
              "value": "desc",
              "description": "The direction to sort by: `[desc, asc]`."
            },
            {
              "key": "sort_name",
              "value": "dbm_queries_usage",
              "description": "The field to sort by."
            },
            {
              "key": "tag_breakdown_keys",
              "value": "tempor Ut sed velit",
              "description": "Comma separated list of tag keys used to group usage. If no value is provided the usage will not be broken down by tags.\n\nTo see which tags are available, look for the value of `tag_config_source` in the API response."
            },
            {
              "key": "next_record_id",
              "value": "tempor Ut sed velit",
              "description": "List following results with a next_record_id provided in the previous query."
            },
            {
              "key": "include_descendants",
              "value": "true",
              "description": "Include child org usage in the response. Defaults to `true`."
            }
          ]
        }
      },
      "status": "Forbidden",
      "code": 403,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Content-Type",
          "value": "application/json;datetime-format=rfc3339"
        }
      ],
      "cookie": [
      ],
      "body": "{\n  \"errors\": [\n    \"Bad Request\",\n    \"Bad Request\"\n  ]\n}"
    },
    {
      "name": "Too many requests",
      "originalRequest": {
        "method": "GET",
        "header": [
          {
            "key": "Accept",
            "value": "application/json;datetime-format=rfc3339"
          },
          {
            "description": "Added as a part of security scheme: apikey",
            "key": "DD-API-KEY",
            "value": "<API Key>"
          }
        ],
        "url": {
          "raw": "{{baseUrl}}/api/v1/usage/monthly-attribution?start_month=1991-02-02T07:22:34.204Z&end_month=1991-02-02T07:22:34.204Z&fields=dbm_queries_usage&sort_direction=desc&sort_name=dbm_queries_usage&tag_breakdown_keys=tempor Ut sed velit&next_record_id=tempor Ut sed velit&include_descendants=true",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "v1",
            "usage",
            "monthly-attribution"
          ],
          "query": [
            {
              "key": "start_month",
              "value": "1991-02-02T07:22:34.204Z",
              "description": "(Required) Datetime in ISO-8601 format, UTC, precise to month: `[YYYY-MM]` for usage beginning in this month.\nMaximum of 15 months ago."
            },
            {
              "key": "end_month",
              "value": "1991-02-02T07:22:34.204Z",
              "description": "Datetime in ISO-8601 format, UTC, precise to month: `[YYYY-MM]` for usage ending this month."
            },
            {
              "key": "fields",
              "value": "dbm_queries_usage",
              "description": "(Required) Comma-separated list of usage types to return, or `*` for all usage types."
            },
            {
              "key": "sort_direction",
              "value": "desc",
              "description": "The direction to sort by: `[desc, asc]`."
            },
            {
              "key": "sort_name",
              "value": "dbm_queries_usage",
              "description": "The field to sort by."
            },
            {
              "key": "tag_breakdown_keys",
              "value": "tempor Ut sed velit",
              "description": "Comma separated list of tag keys used to group usage. If no value is provided the usage will not be broken down by tags.\n\nTo see which tags are available, look for the value of `tag_config_source` in the API response."
            },
            {
              "key": "next_record_id",
              "value": "tempor Ut sed velit",
              "description": "List following results with a next_record_id provided in the previous query."
            },
            {
              "key": "include_descendants",
              "value": "true",
              "description": "Include child org usage in the response. Defaults to `true`."
            }
          ]
        }
      },
      "status": "Too Many Requests",
      "code": 429,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Content-Type",
          "value": "application/json;datetime-format=rfc3339"
        }
      ],
      "cookie": [
      ],
      "body": "{\n  \"errors\": [\n    \"Bad Request\",\n    \"Bad Request\"\n  ]\n}"
    }
  ]
}