PowerBuilder / Monitoring API / Summarizes and returns metrics data filtered using the provided query expression and compartmentId.
Back to Collection Items
integer li_rc
oleobject loo_Http
integer li_Success
oleobject loo_Json
oleobject loo_Resp
oleobject loo_SbResponseBody
oleobject loo_JarrResp
integer li_RespStatusCode
oleobject loo_Json
string ls_CompartmentId
string ls_Name
string ls_Namespace
string ls_Resolution
string ls_ResourceGroup
integer j
integer li_Count_j
string ls_Timestamp
string ls_Value
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
li_rc = loo_Http.ConnectToNewObject("Chilkat_9_5_0.Http")
if li_rc < 0 then
destroy loo_Http
MessageBox("Error","Connecting to COM object failed")
return
end if
// Use this online tool to generate code from sample JSON: Generate Code to Create JSON
// The following JSON is sent in the request body.
// {
// "namespace": "ipsum velit",
// "query": "enim sint cupidatat",
// "endTime": "1970-02-17T08:36:22.342Z",
// "resolution": "ad culpa officia",
// "resourceGroup": "exercitat",
// "startTime": "1960-03-31T20:00:02.377Z"
// }
loo_Json = create oleobject
li_rc = loo_Json.ConnectToNewObject("Chilkat_9_5_0.JsonObject")
loo_Json.UpdateString("namespace","ipsum velit")
loo_Json.UpdateString("query","enim sint cupidatat")
loo_Json.UpdateString("endTime","1970-02-17T08:36:22.342Z")
loo_Json.UpdateString("resolution","ad culpa officia")
loo_Json.UpdateString("resourceGroup","exercitat")
loo_Json.UpdateString("startTime","1960-03-31T20:00:02.377Z")
loo_Http.SetRequestHeader("opc-request-id","pariatur nostrud eiusmod")
loo_Http.SetRequestHeader("Content-Type","application/json")
loo_Http.SetRequestHeader("x-content-sha256","{{content_sha256}}")
loo_Http.SetRequestHeader("Authorization","{{signature}}")
loo_Http.SetRequestHeader("Date","{{date}}")
loo_Resp = loo_Http.PostJson3("https://telemetry-ingestion.{{region}}.oraclecloud.com/20180401/metrics/actions/summarizeMetricsData?compartmentId={{compartment_ocid}}&compartmentIdInSubtree=true","application/json",loo_Json)
if loo_Http.LastMethodSuccess = 0 then
Write-Debug loo_Http.LastErrorText
destroy loo_Http
destroy loo_Json
return
end if
loo_SbResponseBody = create oleobject
li_rc = loo_SbResponseBody.ConnectToNewObject("Chilkat_9_5_0.StringBuilder")
loo_Resp.GetBodySb(loo_SbResponseBody)
loo_JarrResp = create oleobject
li_rc = loo_JarrResp.ConnectToNewObject("Chilkat_9_5_0.JsonArray")
loo_JarrResp.LoadSb(loo_SbResponseBody)
loo_JarrResp.EmitCompact = 0
Write-Debug "Response Body:"
Write-Debug loo_JarrResp.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_Json
destroy loo_SbResponseBody
destroy loo_JarrResp
return
end if
destroy loo_Resp
// Sample JSON response:
// (Sample code for parsing the JSON response is shown below)
// [
// {
// "aggregatedDatapoints": [
// {
// "timestamp": "1985-06-19T12:01:12.090Z",
// "value": -32623933.259507656
// }
// ],
// "compartmentId": "ocid1.compartment.oc1..exampleuniqueID",
// "dimensions": {},
// "name": "et",
// "namespace": "ea deserunt Duis",
// "metadata": {},
// "resolution": "veniam proident ullamco esse qui",
// "resourceGroup": "elit Duis"
// },
// {
// "aggregatedDatapoints": [
// {
// "timestamp": "2003-08-02T12:17:20.221Z",
// "value": 54399970.60984036
// }
// ],
// "compartmentId": "ocid1.compartment.oc1..exampleuniqueID",
// "dimensions": {},
// "name": "adipisicing fugiat",
// "namespace": "proident sunt veniam",
// "metadata": {},
// "resolution": "fugiat ullamco Lorem laborum est",
// "resourceGroup": "ut adipisicing exercitation magna Ut"
// }
// ]
// Sample code for parsing the JSON response...
// Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
i = 0
li_Count_i = loo_JarrResp.Size
do while i < li_Count_i
loo_Json = loo_JarrResp.ObjectAt(i)
ls_CompartmentId = loo_Json.StringOf("compartmentId")
ls_Name = loo_Json.StringOf("name")
ls_Namespace = loo_Json.StringOf("namespace")
ls_Resolution = loo_Json.StringOf("resolution")
ls_ResourceGroup = loo_Json.StringOf("resourceGroup")
j = 0
li_Count_j = loo_Json.SizeOfArray("aggregatedDatapoints")
do while j < li_Count_j
loo_Json.J = j
ls_Timestamp = loo_Json.StringOf("aggregatedDatapoints[j].timestamp")
ls_Value = loo_Json.StringOf("aggregatedDatapoints[j].value")
j = j + 1
loop
destroy loo_Json
i = i + 1
loop
destroy loo_Http
destroy loo_Json
destroy loo_SbResponseBody
destroy loo_JarrResp
Curl Command
curl -X POST
-H "opc-request-id: pariatur nostrud eiusmod"
-H "Content-Type: application/json"
-H "Date: {{date}}"
-H "Authorization: {{signature}}"
-H "x-content-sha256: {{content_sha256}}"
-d '{
"namespace": "ipsum velit",
"query": "enim sint cupidatat",
"endTime": "1970-02-17T08:36:22.342Z",
"resolution": "ad culpa officia",
"resourceGroup": "exercitat",
"startTime": "1960-03-31T20:00:02.377Z"
}'
https://telemetry-ingestion.{{region}}.oraclecloud.com/20180401/metrics/actions/summarizeMetricsData?compartmentId={{compartment_ocid}}&compartmentIdInSubtree=true
Postman Collection Item JSON
{
"name": "Summarizes and returns metrics data filtered using the provided query expression and compartmentId.",
"request": {
"method": "POST",
"header": [
{
"description": "Customer part of the request identifier token. If you need to contact Oracle about a particular\nrequest, please provide the complete request ID.\n",
"key": "opc-request-id",
"value": "pariatur nostrud eiusmod"
},
{
"key": "Content-Type",
"value": "application/json"
},
{
"key": "Date",
"value": "{{date}}",
"description": "(Required) Current Date",
"type": "text"
},
{
"key": "Authorization",
"value": "{{signature}}",
"description": "(Required) Signature Authentication on Authorization header",
"type": "text"
},
{
"key": "x-content-sha256",
"value": "{{content_sha256}}",
"description": "(Required) Content sha256 for POST, PUT and PATCH operations",
"type": "text"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"namespace\": \"ipsum velit\",\n \"query\": \"enim sint cupidatat\",\n \"endTime\": \"1970-02-17T08:36:22.342Z\",\n \"resolution\": \"ad culpa officia\",\n \"resourceGroup\": \"exercitat\",\n \"startTime\": \"1960-03-31T20:00:02.377Z\"\n}"
},
"url": {
"raw": "{{baseUrlIngestion}}/metrics/actions/summarizeMetricsData?compartmentId={{compartment_ocid}}&compartmentIdInSubtree=true",
"host": [
"{{baseUrlIngestion}}"
],
"path": [
"metrics",
"actions",
"summarizeMetricsData"
],
"query": [
{
"key": "compartmentId",
"value": "{{compartment_ocid}}",
"description": "(Required) The [OCID](https://docs.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the compartment containing the\nresources monitored by the metric that you are searching for. Use tenancyId to search in\nthe root compartment.\n\nExample: `ocid1.compartment.oc1..exampleuniqueID`\n"
},
{
"key": "compartmentIdInSubtree",
"value": "true",
"description": "When true, returns resources from all compartments and subcompartments. The parameter can\nonly be set to true when compartmentId is the tenancy OCID (the tenancy is the root compartment).\nA true value requires the user to have tenancy-level permissions. If this requirement is not met,\nthen the call is rejected. When false, returns resources from only the compartment specified in\ncompartmentId. Default is false.\n"
}
]
},
"description": "Returns aggregated data that match the criteria specified in the request. Compartment OCID required.\nFor information on metric queries, see [Building Metric Queries](https://docs.oracle.com/iaas/Content/Monitoring/Tasks/buildingqueries.htm).\nFor important limits information, see [Limits on Monitoring](https://docs.oracle.com/iaas/Content/Monitoring/Concepts/monitoringoverview.htm#Limits).\n\nTransactions Per Second (TPS) per-tenancy limit for this operation: 10.\n"
},
"response": [
{
"name": "The metric data was successfully retrieved.\nResults are not paginated.\n",
"originalRequest": {
"method": "POST",
"header": [
{
"description": "Customer part of the request identifier token. If you need to contact Oracle about a particular\nrequest, please provide the complete request ID.\n",
"key": "opc-request-id",
"value": "pariatur nostrud eiusmod"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"namespace\": \"ipsum velit\",\n \"query\": \"enim sint cupidatat\",\n \"endTime\": \"1970-02-17T08:36:22.342Z\",\n \"resolution\": \"ad culpa officia\",\n \"resourceGroup\": \"exercitat\",\n \"startTime\": \"1960-03-31T20:00:02.377Z\"\n}"
},
"url": {
"raw": "{{baseUrl}}/metrics/actions/summarizeMetricsData?compartmentId=mollit in Duis enim&compartmentIdInSubtree=true",
"host": [
"{{baseUrl}}"
],
"path": [
"metrics",
"actions",
"summarizeMetricsData"
],
"query": [
{
"key": "compartmentId",
"value": "mollit in Duis enim"
},
{
"key": "compartmentIdInSubtree",
"value": "true"
}
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "opc-request-id",
"value": "pariatur nostrud eiusmod",
"description": "Unique Oracle-assigned identifier for the request. If you need to contact Oracle about\na particular request, please provide the request ID.\n"
},
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "[\n {\n \"aggregatedDatapoints\": [\n {\n \"timestamp\": \"1985-06-19T12:01:12.090Z\",\n \"value\": -32623933.259507656\n }\n ],\n \"compartmentId\": \"ocid1.compartment.oc1..exampleuniqueID\",\n \"dimensions\": {},\n \"name\": \"et\",\n \"namespace\": \"ea deserunt Duis\",\n \"metadata\": {},\n \"resolution\": \"veniam proident ullamco esse qui\",\n \"resourceGroup\": \"elit Duis\"\n },\n {\n \"aggregatedDatapoints\": [\n {\n \"timestamp\": \"2003-08-02T12:17:20.221Z\",\n \"value\": 54399970.60984036\n }\n ],\n \"compartmentId\": \"ocid1.compartment.oc1..exampleuniqueID\",\n \"dimensions\": {},\n \"name\": \"adipisicing fugiat\",\n \"namespace\": \"proident sunt veniam\",\n \"metadata\": {},\n \"resolution\": \"fugiat ullamco Lorem laborum est\",\n \"resourceGroup\": \"ut adipisicing exercitation magna Ut\"\n }\n]"
},
{
"name": "Bad Request",
"originalRequest": {
"method": "POST",
"header": [
{
"description": "Customer part of the request identifier token. If you need to contact Oracle about a particular\nrequest, please provide the complete request ID.\n",
"key": "opc-request-id",
"value": "pariatur nostrud eiusmod"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"namespace\": \"ipsum velit\",\n \"query\": \"enim sint cupidatat\",\n \"endTime\": \"1970-02-17T08:36:22.342Z\",\n \"resolution\": \"ad culpa officia\",\n \"resourceGroup\": \"exercitat\",\n \"startTime\": \"1960-03-31T20:00:02.377Z\"\n}"
},
"url": {
"raw": "{{baseUrl}}/metrics/actions/summarizeMetricsData?compartmentId=mollit in Duis enim&compartmentIdInSubtree=true",
"host": [
"{{baseUrl}}"
],
"path": [
"metrics",
"actions",
"summarizeMetricsData"
],
"query": [
{
"key": "compartmentId",
"value": "mollit in Duis enim"
},
{
"key": "compartmentIdInSubtree",
"value": "true"
}
]
}
},
"status": "Bad Request",
"code": 400,
"_postman_previewlanguage": "json",
"header": [
{
"key": "opc-request-id",
"value": "pariatur nostrud eiusmod",
"description": "Unique Oracle-assigned identifier for the request. If you need to contact Oracle about\na particular request, please provide the request ID.\n"
},
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"code\": \"qui anim ut\",\n \"message\": \"esse proident\"\n}"
},
{
"name": "Unauthorized",
"originalRequest": {
"method": "POST",
"header": [
{
"description": "Customer part of the request identifier token. If you need to contact Oracle about a particular\nrequest, please provide the complete request ID.\n",
"key": "opc-request-id",
"value": "pariatur nostrud eiusmod"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"namespace\": \"ipsum velit\",\n \"query\": \"enim sint cupidatat\",\n \"endTime\": \"1970-02-17T08:36:22.342Z\",\n \"resolution\": \"ad culpa officia\",\n \"resourceGroup\": \"exercitat\",\n \"startTime\": \"1960-03-31T20:00:02.377Z\"\n}"
},
"url": {
"raw": "{{baseUrl}}/metrics/actions/summarizeMetricsData?compartmentId=mollit in Duis enim&compartmentIdInSubtree=true",
"host": [
"{{baseUrl}}"
],
"path": [
"metrics",
"actions",
"summarizeMetricsData"
],
"query": [
{
"key": "compartmentId",
"value": "mollit in Duis enim"
},
{
"key": "compartmentIdInSubtree",
"value": "true"
}
]
}
},
"status": "Unauthorized",
"code": 401,
"_postman_previewlanguage": "json",
"header": [
{
"key": "opc-request-id",
"value": "pariatur nostrud eiusmod",
"description": "Unique Oracle-assigned identifier for the request. If you need to contact Oracle about\na particular request, please provide the request ID.\n"
},
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"code\": \"qui anim ut\",\n \"message\": \"esse proident\"\n}"
},
{
"name": "Not Authorized Or Not Found",
"originalRequest": {
"method": "POST",
"header": [
{
"description": "Customer part of the request identifier token. If you need to contact Oracle about a particular\nrequest, please provide the complete request ID.\n",
"key": "opc-request-id",
"value": "pariatur nostrud eiusmod"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"namespace\": \"ipsum velit\",\n \"query\": \"enim sint cupidatat\",\n \"endTime\": \"1970-02-17T08:36:22.342Z\",\n \"resolution\": \"ad culpa officia\",\n \"resourceGroup\": \"exercitat\",\n \"startTime\": \"1960-03-31T20:00:02.377Z\"\n}"
},
"url": {
"raw": "{{baseUrl}}/metrics/actions/summarizeMetricsData?compartmentId=mollit in Duis enim&compartmentIdInSubtree=true",
"host": [
"{{baseUrl}}"
],
"path": [
"metrics",
"actions",
"summarizeMetricsData"
],
"query": [
{
"key": "compartmentId",
"value": "mollit in Duis enim"
},
{
"key": "compartmentIdInSubtree",
"value": "true"
}
]
}
},
"status": "Not Found",
"code": 404,
"_postman_previewlanguage": "json",
"header": [
{
"key": "opc-request-id",
"value": "pariatur nostrud eiusmod",
"description": "Unique Oracle-assigned identifier for the request. If you need to contact Oracle about\na particular request, please provide the request ID.\n"
},
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"code\": \"qui anim ut\",\n \"message\": \"esse proident\"\n}"
},
{
"name": "Client is getting throttled, please retry with backoff.",
"originalRequest": {
"method": "POST",
"header": [
{
"description": "Customer part of the request identifier token. If you need to contact Oracle about a particular\nrequest, please provide the complete request ID.\n",
"key": "opc-request-id",
"value": "pariatur nostrud eiusmod"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"namespace\": \"ipsum velit\",\n \"query\": \"enim sint cupidatat\",\n \"endTime\": \"1970-02-17T08:36:22.342Z\",\n \"resolution\": \"ad culpa officia\",\n \"resourceGroup\": \"exercitat\",\n \"startTime\": \"1960-03-31T20:00:02.377Z\"\n}"
},
"url": {
"raw": "{{baseUrl}}/metrics/actions/summarizeMetricsData?compartmentId=mollit in Duis enim&compartmentIdInSubtree=true",
"host": [
"{{baseUrl}}"
],
"path": [
"metrics",
"actions",
"summarizeMetricsData"
],
"query": [
{
"key": "compartmentId",
"value": "mollit in Duis enim"
},
{
"key": "compartmentIdInSubtree",
"value": "true"
}
]
}
},
"status": "Too Many Requests",
"code": 429,
"_postman_previewlanguage": "json",
"header": [
{
"key": "opc-request-id",
"value": "pariatur nostrud eiusmod",
"description": "Unique Oracle-assigned identifier for the request. If you need to contact Oracle about\na particular request, please provide the request ID.\n"
},
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"code\": \"qui anim ut\",\n \"message\": \"esse proident\"\n}"
},
{
"name": "Internal Server Error",
"originalRequest": {
"method": "POST",
"header": [
{
"description": "Customer part of the request identifier token. If you need to contact Oracle about a particular\nrequest, please provide the complete request ID.\n",
"key": "opc-request-id",
"value": "pariatur nostrud eiusmod"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"namespace\": \"ipsum velit\",\n \"query\": \"enim sint cupidatat\",\n \"endTime\": \"1970-02-17T08:36:22.342Z\",\n \"resolution\": \"ad culpa officia\",\n \"resourceGroup\": \"exercitat\",\n \"startTime\": \"1960-03-31T20:00:02.377Z\"\n}"
},
"url": {
"raw": "{{baseUrl}}/metrics/actions/summarizeMetricsData?compartmentId=mollit in Duis enim&compartmentIdInSubtree=true",
"host": [
"{{baseUrl}}"
],
"path": [
"metrics",
"actions",
"summarizeMetricsData"
],
"query": [
{
"key": "compartmentId",
"value": "mollit in Duis enim"
},
{
"key": "compartmentIdInSubtree",
"value": "true"
}
]
}
},
"status": "Internal Server Error",
"code": 500,
"_postman_previewlanguage": "json",
"header": [
{
"key": "opc-request-id",
"value": "pariatur nostrud eiusmod",
"description": "Unique Oracle-assigned identifier for the request. If you need to contact Oracle about\na particular request, please provide the request ID.\n"
},
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"code\": \"qui anim ut\",\n \"message\": \"esse proident\"\n}"
},
{
"name": "An error has occurred.",
"originalRequest": {
"method": "POST",
"header": [
{
"description": "Customer part of the request identifier token. If you need to contact Oracle about a particular\nrequest, please provide the complete request ID.\n",
"key": "opc-request-id",
"value": "pariatur nostrud eiusmod"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"namespace\": \"ipsum velit\",\n \"query\": \"enim sint cupidatat\",\n \"endTime\": \"1970-02-17T08:36:22.342Z\",\n \"resolution\": \"ad culpa officia\",\n \"resourceGroup\": \"exercitat\",\n \"startTime\": \"1960-03-31T20:00:02.377Z\"\n}"
},
"url": {
"raw": "{{baseUrl}}/metrics/actions/summarizeMetricsData?compartmentId=mollit in Duis enim&compartmentIdInSubtree=true",
"host": [
"{{baseUrl}}"
],
"path": [
"metrics",
"actions",
"summarizeMetricsData"
],
"query": [
{
"key": "compartmentId",
"value": "mollit in Duis enim"
},
{
"key": "compartmentIdInSubtree",
"value": "true"
}
]
}
},
"status": "Internal Server Error",
"code": 500,
"_postman_previewlanguage": "json",
"header": [
{
"key": "opc-request-id",
"value": "pariatur nostrud eiusmod",
"description": "Unique Oracle-assigned identifier for the request. If you need to contact Oracle about\na particular request, please provide the request ID.\n"
},
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"code\": \"qui anim ut\",\n \"message\": \"esse proident\"\n}"
}
]
}
