delphiDll / Datadog API Collection / Get cost across multi-org account
Back to Collection Items
var
http: HCkHttp;
success: Boolean;
queryParams: HCkJsonObject;
resp: HCkHttpResponse;
sbResponseBody: HCkStringBuilder;
jResp: HCkJsonObject;
respStatusCode: Integer;
Date: PWideChar;
Org_name: PWideChar;
Public_id: PWideChar;
Region: PWideChar;
Total_cost: PWideChar;
id: PWideChar;
v_type: PWideChar;
j: Integer;
count_j: Integer;
charge_type: PWideChar;
cost: PWideChar;
product_name: PWideChar;
i: Integer;
count_i: Integer;
begin
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
http := CkHttp_Create();
queryParams := CkJsonObject_Create();
CkJsonObject_UpdateString(queryParams,'start_month','<dateTime>');
CkJsonObject_UpdateString(queryParams,'end_month','<dateTime>');
CkHttp_SetRequestHeader(http,'Accept','application/json;datetime-format=rfc3339');
resp := CkHttp_QuickRequestParams(http,'GET','https://api.app.ddog-gov.com/api/v2/usage/cost_by_org',queryParams);
if (CkHttp_getLastMethodSuccess(http) = False) then
begin
Memo1.Lines.Add(CkHttp__lastErrorText(http));
Exit;
end;
sbResponseBody := CkStringBuilder_Create();
CkHttpResponse_GetBodySb(resp,sbResponseBody);
jResp := CkJsonObject_Create();
CkJsonObject_LoadSb(jResp,sbResponseBody);
CkJsonObject_putEmitCompact(jResp,False);
Memo1.Lines.Add('Response Body:');
Memo1.Lines.Add(CkJsonObject__emit(jResp));
respStatusCode := CkHttpResponse_getStatusCode(resp);
Memo1.Lines.Add('Response Status Code = ' + IntToStr(respStatusCode));
if (respStatusCode >= 400) then
begin
Memo1.Lines.Add('Response Header:');
Memo1.Lines.Add(CkHttpResponse__header(resp));
Memo1.Lines.Add('Failed.');
CkHttpResponse_Dispose(resp);
Exit;
end;
CkHttpResponse_Dispose(resp);
// Sample JSON response:
// (Sample code for parsing the JSON response is shown below)
// {
// "data": [
// {
// "attributes": {
// "charges": [
// {
// "charge_type": "<string>",
// "cost": "<double>",
// "product_name": "<string>"
// },
// {
// "charge_type": "<string>",
// "cost": "<double>",
// "product_name": "<string>"
// }
// ],
// "date": "<dateTime>",
// "org_name": "<string>",
// "public_id": "<string>",
// "region": "<string>",
// "total_cost": "<double>"
// },
// "id": "<string>",
// "type": "cost_by_org"
// },
// {
// "attributes": {
// "charges": [
// {
// "charge_type": "<string>",
// "cost": "<double>",
// "product_name": "<string>"
// },
// {
// "charge_type": "<string>",
// "cost": "<double>",
// "product_name": "<string>"
// }
// ],
// "date": "<dateTime>",
// "org_name": "<string>",
// "public_id": "<string>",
// "region": "<string>",
// "total_cost": "<double>"
// },
// "id": "<string>",
// "type": "cost_by_org"
// }
// ]
// }
// Sample code for parsing the JSON response...
// Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
i := 0;
count_i := CkJsonObject_SizeOfArray(jResp,'data');
while i < count_i do
begin
CkJsonObject_putI(jResp,i);
Date := CkJsonObject__stringOf(jResp,'data[i].attributes.date');
Org_name := CkJsonObject__stringOf(jResp,'data[i].attributes.org_name');
Public_id := CkJsonObject__stringOf(jResp,'data[i].attributes.public_id');
Region := CkJsonObject__stringOf(jResp,'data[i].attributes.region');
Total_cost := CkJsonObject__stringOf(jResp,'data[i].attributes.total_cost');
id := CkJsonObject__stringOf(jResp,'data[i].id');
v_type := CkJsonObject__stringOf(jResp,'data[i].type');
j := 0;
count_j := CkJsonObject_SizeOfArray(jResp,'data[i].attributes.charges');
while j < count_j do
begin
CkJsonObject_putJ(jResp,j);
charge_type := CkJsonObject__stringOf(jResp,'data[i].attributes.charges[j].charge_type');
cost := CkJsonObject__stringOf(jResp,'data[i].attributes.charges[j].cost');
product_name := CkJsonObject__stringOf(jResp,'data[i].attributes.charges[j].product_name');
j := j + 1;
end;
i := i + 1;
end;
CkHttp_Dispose(http);
CkJsonObject_Dispose(queryParams);
CkStringBuilder_Dispose(sbResponseBody);
CkJsonObject_Dispose(jResp);
Curl Command
curl -G -d "start_month=%3CdateTime%3E"
-d "end_month=%3CdateTime%3E"
-H "Accept: application/json;datetime-format=rfc3339"
https://api.app.ddog-gov.com/api/v2/usage/cost_by_org
Postman Collection Item JSON
{
"name": "Get cost across multi-org account",
"request": {
"method": "GET",
"header": [
{
"key": "Accept",
"value": "application/json;datetime-format=rfc3339"
}
],
"url": {
"raw": "{{baseUrl}}/api/v2/usage/cost_by_org?start_month=<dateTime>&end_month=<dateTime>",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v2",
"usage",
"cost_by_org"
],
"query": [
{
"key": "start_month",
"value": "<dateTime>",
"description": "(Required) Datetime in ISO-8601 format, UTC, precise to month: `[YYYY-MM]` for cost beginning this month."
},
{
"key": "end_month",
"value": "<dateTime>",
"description": "Datetime in ISO-8601 format, UTC, precise to month: `[YYYY-MM]` for cost ending this month."
}
]
},
"description": "Get cost across multi-org account.\nCost by org data for a given month becomes available no later than the 16th of the following month.\n**Note:** This endpoint has been deprecated. Please use the new endpoint\n[`/historical_cost`](https://docs.datadoghq.com/api/latest/usage-metering/#get-historical-cost-across-your-account)\ninstead."
},
"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/v2/usage/cost_by_org?start_month=<dateTime>&end_month=<dateTime>",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v2",
"usage",
"cost_by_org"
],
"query": [
{
"key": "start_month",
"value": "<dateTime>",
"description": "(Required) Datetime in ISO-8601 format, UTC, precise to month: `[YYYY-MM]` for cost beginning this month."
},
{
"key": "end_month",
"value": "<dateTime>",
"description": "Datetime in ISO-8601 format, UTC, precise to month: `[YYYY-MM]` for cost ending this month."
}
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json;datetime-format=rfc3339"
}
],
"cookie": [
],
"body": "{\n \"data\": [\n {\n \"attributes\": {\n \"charges\": [\n {\n \"charge_type\": \"<string>\",\n \"cost\": \"<double>\",\n \"product_name\": \"<string>\"\n },\n {\n \"charge_type\": \"<string>\",\n \"cost\": \"<double>\",\n \"product_name\": \"<string>\"\n }\n ],\n \"date\": \"<dateTime>\",\n \"org_name\": \"<string>\",\n \"public_id\": \"<string>\",\n \"region\": \"<string>\",\n \"total_cost\": \"<double>\"\n },\n \"id\": \"<string>\",\n \"type\": \"cost_by_org\"\n },\n {\n \"attributes\": {\n \"charges\": [\n {\n \"charge_type\": \"<string>\",\n \"cost\": \"<double>\",\n \"product_name\": \"<string>\"\n },\n {\n \"charge_type\": \"<string>\",\n \"cost\": \"<double>\",\n \"product_name\": \"<string>\"\n }\n ],\n \"date\": \"<dateTime>\",\n \"org_name\": \"<string>\",\n \"public_id\": \"<string>\",\n \"region\": \"<string>\",\n \"total_cost\": \"<double>\"\n },\n \"id\": \"<string>\",\n \"type\": \"cost_by_org\"\n }\n ]\n}"
},
{
"name": "Bad Request",
"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/v2/usage/cost_by_org?start_month=<dateTime>&end_month=<dateTime>",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v2",
"usage",
"cost_by_org"
],
"query": [
{
"key": "start_month",
"value": "<dateTime>",
"description": "(Required) Datetime in ISO-8601 format, UTC, precise to month: `[YYYY-MM]` for cost beginning this month."
},
{
"key": "end_month",
"value": "<dateTime>",
"description": "Datetime in ISO-8601 format, UTC, precise to month: `[YYYY-MM]` for cost ending this month."
}
]
}
},
"status": "Bad Request",
"code": 400,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json;datetime-format=rfc3339"
}
],
"cookie": [
],
"body": "{\n \"errors\": [\n \"<string>\",\n \"<string>\"\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/v2/usage/cost_by_org?start_month=<dateTime>&end_month=<dateTime>",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v2",
"usage",
"cost_by_org"
],
"query": [
{
"key": "start_month",
"value": "<dateTime>",
"description": "(Required) Datetime in ISO-8601 format, UTC, precise to month: `[YYYY-MM]` for cost beginning this month."
},
{
"key": "end_month",
"value": "<dateTime>",
"description": "Datetime in ISO-8601 format, UTC, precise to month: `[YYYY-MM]` for cost ending this month."
}
]
}
},
"status": "Forbidden",
"code": 403,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json;datetime-format=rfc3339"
}
],
"cookie": [
],
"body": "{\n \"errors\": [\n \"<string>\",\n \"<string>\"\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/v2/usage/cost_by_org?start_month=<dateTime>&end_month=<dateTime>",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v2",
"usage",
"cost_by_org"
],
"query": [
{
"key": "start_month",
"value": "<dateTime>",
"description": "(Required) Datetime in ISO-8601 format, UTC, precise to month: `[YYYY-MM]` for cost beginning this month."
},
{
"key": "end_month",
"value": "<dateTime>",
"description": "Datetime in ISO-8601 format, UTC, precise to month: `[YYYY-MM]` for cost ending this month."
}
]
}
},
"status": "Too Many Requests",
"code": 429,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json;datetime-format=rfc3339"
}
],
"cookie": [
],
"body": "{\n \"errors\": [\n \"<string>\",\n \"<string>\"\n ]\n}"
}
]
}
