Chilkat Online Tools

PowerBuilder / Datadog API Collection / Get monthly usage attribution

Back to Collection Items

integer li_rc
oleobject loo_Http
integer li_Success
oleobject loo_QueryParams
oleobject loo_Resp
oleobject loo_SbResponseBody
oleobject loo_JResp
integer li_RespStatusCode
string ls_Agg_type
string ls_Field
string ls_Value
string ls_Month
string ls_Org_name
string ls_Public_id
string ls_Region
string ls_Tag_config_source
string ls_Updated_at
string ls_Api_percentage
string ls_Api_usage
string ls_Apm_fargate_percentage
string ls_Apm_fargate_usage
string ls_Apm_host_percentage
string ls_Apm_host_usage
string ls_Apm_usm_percentage
string ls_Apm_usm_usage
string ls_Appsec_fargate_percentage
string ls_Appsec_fargate_usage
string ls_Appsec_percentage
string ls_Appsec_usage
string ls_Browser_percentage
string ls_Browser_usage
string ls_Ci_visibility_itr_percentage
string ls_Ci_visibility_itr_usage
string ls_Container_excl_agent_percentage
string ls_Container_excl_agent_usage
string ls_Container_percentage
string ls_Container_usage
string ls_Cspm_containers_percentage
string ls_Cspm_containers_usage
string ls_Cspm_hosts_percentage
string ls_Cspm_hosts_usage
string ls_Custom_ingested_timeseries_percentage
string ls_Custom_ingested_timeseries_usage
string ls_Custom_timeseries_percentage
string ls_Custom_timeseries_usage
string ls_Cws_containers_percentage
string ls_Cws_containers_usage
string ls_Cws_hosts_percentage
string ls_Cws_hosts_usage
string ls_Dbm_hosts_percentage
string ls_Dbm_hosts_usage
string ls_Dbm_queries_percentage
string ls_Dbm_queries_usage
string ls_Estimated_indexed_logs_percentage
string ls_Estimated_indexed_logs_usage
string ls_Estimated_indexed_spans_percentage
string ls_Estimated_indexed_spans_usage
string ls_Estimated_ingested_logs_percentage
string ls_Estimated_ingested_logs_usage
string ls_Estimated_ingested_spans_percentage
string ls_Estimated_ingested_spans_usage
string ls_Estimated_rum_sessions_percentage
string ls_Estimated_rum_sessions_usage
string ls_Fargate_percentage
string ls_Fargate_usage
string ls_Functions_percentage
string ls_Functions_usage
string ls_Infra_host_percentage
string ls_Infra_host_usage
string ls_Invocations_percentage
string ls_Invocations_usage
string ls_Npm_host_percentage
string ls_Npm_host_usage
string ls_Obs_pipeline_bytes_percentage
string ls_Obs_pipeline_bytes_usage
string ls_Profiled_container_percentage
string ls_Profiled_container_usage
string ls_Profiled_fargate_percentage
string ls_Profiled_fargate_usage
string ls_Profiled_host_percentage
string ls_Profiled_host_usage
string ls_Sds_scanned_bytes_percentage
string ls_Sds_scanned_bytes_usage
string ls_Snmp_percentage
string ls_Snmp_usage
string ls_Universal_service_monitoring_percentage
string ls_Universal_service_monitoring_usage
string ls_Vuln_management_hosts_percentage
string ls_Vuln_management_hosts_usage
integer j
integer li_Count_j
string ls_StrVal
string ls_Next_record_id
integer i
integer li_Count_i

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

loo_Http = create oleobject
// Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")
if li_rc < 0 then
    destroy loo_Http
    MessageBox("Error","Connecting to COM object failed")
    return
end if

loo_QueryParams = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
li_rc = loo_QueryParams.ConnectToNewObject("Chilkat.JsonObject")

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

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

loo_Resp = loo_Http.QuickRequestParams("GET","https://api.app.ddog-gov.com/api/v1/usage/monthly-attribution",loo_QueryParams)
if loo_Http.LastMethodSuccess = 0 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    destroy loo_QueryParams
    return
end if

loo_SbResponseBody = create oleobject
// Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
li_rc = loo_SbResponseBody.ConnectToNewObject("Chilkat.StringBuilder")

loo_Resp.GetBodySb(loo_SbResponseBody)

loo_JResp = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
li_rc = loo_JResp.ConnectToNewObject("Chilkat.JsonObject")

loo_JResp.LoadSb(loo_SbResponseBody)
loo_JResp.EmitCompact = 0

Write-Debug "Response Body:"
Write-Debug loo_JResp.Emit()

li_RespStatusCode = loo_Resp.StatusCode
Write-Debug "Response Status Code = " + string(li_RespStatusCode)
if li_RespStatusCode >= 400 then
    Write-Debug "Response Header:"
    Write-Debug loo_Resp.Header
    Write-Debug "Failed."
    destroy loo_Resp
    destroy loo_Http
    destroy loo_QueryParams
    destroy loo_SbResponseBody
    destroy loo_JResp
    return
end if

destroy loo_Resp

// 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

ls_Next_record_id = loo_JResp.StringOf("metadata.pagination.next_record_id")
i = 0
li_Count_i = loo_JResp.SizeOfArray("metadata.aggregates")
do while i < li_Count_i
    loo_JResp.I = i
    ls_Agg_type = loo_JResp.StringOf("metadata.aggregates[i].agg_type")
    ls_Field = loo_JResp.StringOf("metadata.aggregates[i].field")
    ls_Value = loo_JResp.StringOf("metadata.aggregates[i].value")
    i = i + 1
loop
i = 0
li_Count_i = loo_JResp.SizeOfArray("usage")
do while i < li_Count_i
    loo_JResp.I = i
    ls_Month = loo_JResp.StringOf("usage[i].month")
    ls_Org_name = loo_JResp.StringOf("usage[i].org_name")
    ls_Public_id = loo_JResp.StringOf("usage[i].public_id")
    ls_Region = loo_JResp.StringOf("usage[i].region")
    ls_Tag_config_source = loo_JResp.StringOf("usage[i].tag_config_source")
    ls_Updated_at = loo_JResp.StringOf("usage[i].updated_at")
    ls_Api_percentage = loo_JResp.StringOf("usage[i].values.api_percentage")
    ls_Api_usage = loo_JResp.StringOf("usage[i].values.api_usage")
    ls_Apm_fargate_percentage = loo_JResp.StringOf("usage[i].values.apm_fargate_percentage")
    ls_Apm_fargate_usage = loo_JResp.StringOf("usage[i].values.apm_fargate_usage")
    ls_Apm_host_percentage = loo_JResp.StringOf("usage[i].values.apm_host_percentage")
    ls_Apm_host_usage = loo_JResp.StringOf("usage[i].values.apm_host_usage")
    ls_Apm_usm_percentage = loo_JResp.StringOf("usage[i].values.apm_usm_percentage")
    ls_Apm_usm_usage = loo_JResp.StringOf("usage[i].values.apm_usm_usage")
    ls_Appsec_fargate_percentage = loo_JResp.StringOf("usage[i].values.appsec_fargate_percentage")
    ls_Appsec_fargate_usage = loo_JResp.StringOf("usage[i].values.appsec_fargate_usage")
    ls_Appsec_percentage = loo_JResp.StringOf("usage[i].values.appsec_percentage")
    ls_Appsec_usage = loo_JResp.StringOf("usage[i].values.appsec_usage")
    ls_Browser_percentage = loo_JResp.StringOf("usage[i].values.browser_percentage")
    ls_Browser_usage = loo_JResp.StringOf("usage[i].values.browser_usage")
    ls_Ci_visibility_itr_percentage = loo_JResp.StringOf("usage[i].values.ci_visibility_itr_percentage")
    ls_Ci_visibility_itr_usage = loo_JResp.StringOf("usage[i].values.ci_visibility_itr_usage")
    ls_Container_excl_agent_percentage = loo_JResp.StringOf("usage[i].values.container_excl_agent_percentage")
    ls_Container_excl_agent_usage = loo_JResp.StringOf("usage[i].values.container_excl_agent_usage")
    ls_Container_percentage = loo_JResp.StringOf("usage[i].values.container_percentage")
    ls_Container_usage = loo_JResp.StringOf("usage[i].values.container_usage")
    ls_Cspm_containers_percentage = loo_JResp.StringOf("usage[i].values.cspm_containers_percentage")
    ls_Cspm_containers_usage = loo_JResp.StringOf("usage[i].values.cspm_containers_usage")
    ls_Cspm_hosts_percentage = loo_JResp.StringOf("usage[i].values.cspm_hosts_percentage")
    ls_Cspm_hosts_usage = loo_JResp.StringOf("usage[i].values.cspm_hosts_usage")
    ls_Custom_ingested_timeseries_percentage = loo_JResp.StringOf("usage[i].values.custom_ingested_timeseries_percentage")
    ls_Custom_ingested_timeseries_usage = loo_JResp.StringOf("usage[i].values.custom_ingested_timeseries_usage")
    ls_Custom_timeseries_percentage = loo_JResp.StringOf("usage[i].values.custom_timeseries_percentage")
    ls_Custom_timeseries_usage = loo_JResp.StringOf("usage[i].values.custom_timeseries_usage")
    ls_Cws_containers_percentage = loo_JResp.StringOf("usage[i].values.cws_containers_percentage")
    ls_Cws_containers_usage = loo_JResp.StringOf("usage[i].values.cws_containers_usage")
    ls_Cws_hosts_percentage = loo_JResp.StringOf("usage[i].values.cws_hosts_percentage")
    ls_Cws_hosts_usage = loo_JResp.StringOf("usage[i].values.cws_hosts_usage")
    ls_Dbm_hosts_percentage = loo_JResp.StringOf("usage[i].values.dbm_hosts_percentage")
    ls_Dbm_hosts_usage = loo_JResp.StringOf("usage[i].values.dbm_hosts_usage")
    ls_Dbm_queries_percentage = loo_JResp.StringOf("usage[i].values.dbm_queries_percentage")
    ls_Dbm_queries_usage = loo_JResp.StringOf("usage[i].values.dbm_queries_usage")
    ls_Estimated_indexed_logs_percentage = loo_JResp.StringOf("usage[i].values.estimated_indexed_logs_percentage")
    ls_Estimated_indexed_logs_usage = loo_JResp.StringOf("usage[i].values.estimated_indexed_logs_usage")
    ls_Estimated_indexed_spans_percentage = loo_JResp.StringOf("usage[i].values.estimated_indexed_spans_percentage")
    ls_Estimated_indexed_spans_usage = loo_JResp.StringOf("usage[i].values.estimated_indexed_spans_usage")
    ls_Estimated_ingested_logs_percentage = loo_JResp.StringOf("usage[i].values.estimated_ingested_logs_percentage")
    ls_Estimated_ingested_logs_usage = loo_JResp.StringOf("usage[i].values.estimated_ingested_logs_usage")
    ls_Estimated_ingested_spans_percentage = loo_JResp.StringOf("usage[i].values.estimated_ingested_spans_percentage")
    ls_Estimated_ingested_spans_usage = loo_JResp.StringOf("usage[i].values.estimated_ingested_spans_usage")
    ls_Estimated_rum_sessions_percentage = loo_JResp.StringOf("usage[i].values.estimated_rum_sessions_percentage")
    ls_Estimated_rum_sessions_usage = loo_JResp.StringOf("usage[i].values.estimated_rum_sessions_usage")
    ls_Fargate_percentage = loo_JResp.StringOf("usage[i].values.fargate_percentage")
    ls_Fargate_usage = loo_JResp.StringOf("usage[i].values.fargate_usage")
    ls_Functions_percentage = loo_JResp.StringOf("usage[i].values.functions_percentage")
    ls_Functions_usage = loo_JResp.StringOf("usage[i].values.functions_usage")
    ls_Infra_host_percentage = loo_JResp.StringOf("usage[i].values.infra_host_percentage")
    ls_Infra_host_usage = loo_JResp.StringOf("usage[i].values.infra_host_usage")
    ls_Invocations_percentage = loo_JResp.StringOf("usage[i].values.invocations_percentage")
    ls_Invocations_usage = loo_JResp.StringOf("usage[i].values.invocations_usage")
    ls_Npm_host_percentage = loo_JResp.StringOf("usage[i].values.npm_host_percentage")
    ls_Npm_host_usage = loo_JResp.StringOf("usage[i].values.npm_host_usage")
    ls_Obs_pipeline_bytes_percentage = loo_JResp.StringOf("usage[i].values.obs_pipeline_bytes_percentage")
    ls_Obs_pipeline_bytes_usage = loo_JResp.StringOf("usage[i].values.obs_pipeline_bytes_usage")
    ls_Profiled_container_percentage = loo_JResp.StringOf("usage[i].values.profiled_container_percentage")
    ls_Profiled_container_usage = loo_JResp.StringOf("usage[i].values.profiled_container_usage")
    ls_Profiled_fargate_percentage = loo_JResp.StringOf("usage[i].values.profiled_fargate_percentage")
    ls_Profiled_fargate_usage = loo_JResp.StringOf("usage[i].values.profiled_fargate_usage")
    ls_Profiled_host_percentage = loo_JResp.StringOf("usage[i].values.profiled_host_percentage")
    ls_Profiled_host_usage = loo_JResp.StringOf("usage[i].values.profiled_host_usage")
    ls_Sds_scanned_bytes_percentage = loo_JResp.StringOf("usage[i].values.sds_scanned_bytes_percentage")
    ls_Sds_scanned_bytes_usage = loo_JResp.StringOf("usage[i].values.sds_scanned_bytes_usage")
    ls_Snmp_percentage = loo_JResp.StringOf("usage[i].values.snmp_percentage")
    ls_Snmp_usage = loo_JResp.StringOf("usage[i].values.snmp_usage")
    ls_Universal_service_monitoring_percentage = loo_JResp.StringOf("usage[i].values.universal_service_monitoring_percentage")
    ls_Universal_service_monitoring_usage = loo_JResp.StringOf("usage[i].values.universal_service_monitoring_usage")
    ls_Vuln_management_hosts_percentage = loo_JResp.StringOf("usage[i].values.vuln_management_hosts_percentage")
    ls_Vuln_management_hosts_usage = loo_JResp.StringOf("usage[i].values.vuln_management_hosts_usage")
    j = 0
    li_Count_j = loo_JResp.SizeOfArray("usage[i].tags.dolore62")
    do while j < li_Count_j
        loo_JResp.J = j
        ls_StrVal = loo_JResp.StringOf("usage[i].tags.dolore62[j]")
        j = j + 1
    loop
    j = 0
    li_Count_j = loo_JResp.SizeOfArray("usage[i].tags.elit276")
    do while j < li_Count_j
        loo_JResp.J = j
        ls_StrVal = loo_JResp.StringOf("usage[i].tags.elit276[j]")
        j = j + 1
    loop
    j = 0
    li_Count_j = loo_JResp.SizeOfArray("usage[i].tags.minim63")
    do while j < li_Count_j
        loo_JResp.J = j
        ls_StrVal = loo_JResp.StringOf("usage[i].tags.minim63[j]")
        j = j + 1
    loop
    j = 0
    li_Count_j = loo_JResp.SizeOfArray("usage[i].tags.pariatur_d4")
    do while j < li_Count_j
        loo_JResp.J = j
        ls_StrVal = loo_JResp.StringOf("usage[i].tags.pariatur_d4[j]")
        j = j + 1
    loop
    i = i + 1
loop


destroy loo_Http
destroy loo_QueryParams
destroy loo_SbResponseBody
destroy loo_JResp

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}"
    }
  ]
}