Chilkat Online Tools

VB6 / Datadog API Collection / Get all SLO corrections

Back to Collection Items

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

Dim http As New ChilkatHttp
Dim success As Long

Dim queryParams As New ChilkatJsonObject
success = queryParams.UpdateInt("offset",-62147425)
success = queryParams.UpdateInt("limit",-62147425)

http.SetRequestHeader "Accept","application/json"

Dim resp As ChilkatHttpResponse
Set resp = http.QuickRequestParams("GET","https://api.app.ddog-gov.com/api/v1/slo/correction",queryParams)
If (http.LastMethodSuccess = 0) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim sbResponseBody As New ChilkatStringBuilder
success = resp.GetBodySb(sbResponseBody)

Dim jResp As New ChilkatJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = 0

Debug.Print "Response Body:"
Debug.Print jResp.Emit()

Dim respStatusCode As Long
respStatusCode = resp.StatusCode
Debug.Print "Response Status Code = " & respStatusCode
If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print resp.Header
    Debug.Print "Failed."

    Exit Sub
End If

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

' {
'   "data": [
'     {
'       "attributes": {
'         "category": "Scheduled Maintenance",
'         "created_at": -74919575,
'         "creator": {
'           "email": "ex veniam",
'           "handle": "velit",
'           "name": "voluptate in sit veniam Lorem"
'         },
'         "description": "veniam laboris",
'         "duration": 3600,
'         "end": -8908818,
'         "modified_at": 5115488,
'         "modifier": {
'           "email": "sit consequat",
'           "handle": "magna irure consequat",
'           "name": "labore aliquip consequat fugiat"
'         },
'         "rrule": "FREQ=DAILY;INTERVAL=10;COUNT=5",
'         "slo_id": "labore commodo",
'         "start": 6104289,
'         "timezone": "consectetur fugiat elit laborum deserunt"
'       },
'       "id": "anim",
'       "type": "correction"
'     },
'     {
'       "attributes": {
'         "category": "Scheduled Maintenance",
'         "created_at": -50145390,
'         "creator": {
'           "email": "aliquip amet",
'           "handle": "amet ex",
'           "name": "sed non proident"
'         },
'         "description": "laborum reprehenderit",
'         "duration": 3600,
'         "end": -50463285,
'         "modified_at": -64168623,
'         "modifier": {
'           "email": "in minim s",
'           "handle": "id aliqua",
'           "name": "officia do fugiat"
'         },
'         "rrule": "FREQ=DAILY;INTERVAL=10;COUNT=5",
'         "slo_id": "sit nost",
'         "start": 47690351,
'         "timezone": "consequat ipsum quis ut"
'       },
'       "id": "incididunt eiusmod id",
'       "type": "correction"
'     }
'   ],
'   "meta": {
'     "page": {
'       "total_count": -1541220,
'       "total_filtered_count": -20550176
'     }
'   }
' }

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

Dim Category As String
Dim Created_at As Long
Dim v_Email As String
Dim Handle As String
Dim Name As String
Dim Description As String
Dim Duration As Long
Dim v_End As Long
Dim Modified_at As Long
Dim ModifierEmail As String
Dim ModifierHandle As String
Dim ModifierName As String
Dim Rrule As String
Dim Slo_id As String
Dim Start As Long
Dim Timezone As String
Dim id As String
Dim v_type As String

Dim Total_count As Long
Total_count = jResp.IntOf("meta.page.total_count")
Dim Total_filtered_count As Long
Total_filtered_count = jResp.IntOf("meta.page.total_filtered_count")
Dim i As Long
i = 0
Dim count_i As Long
count_i = jResp.SizeOfArray("data")
Do While i < count_i
    jResp.I = i
    Category = jResp.StringOf("data[i].attributes.category")
    Created_at = jResp.IntOf("data[i].attributes.created_at")
    v_Email = jResp.StringOf("data[i].attributes.creator.email")
    Handle = jResp.StringOf("data[i].attributes.creator.handle")
    Name = jResp.StringOf("data[i].attributes.creator.name")
    Description = jResp.StringOf("data[i].attributes.description")
    Duration = jResp.IntOf("data[i].attributes.duration")
    v_End = jResp.IntOf("data[i].attributes.end")
    Modified_at = jResp.IntOf("data[i].attributes.modified_at")
    ModifierEmail = jResp.StringOf("data[i].attributes.modifier.email")
    ModifierHandle = jResp.StringOf("data[i].attributes.modifier.handle")
    ModifierName = jResp.StringOf("data[i].attributes.modifier.name")
    Rrule = jResp.StringOf("data[i].attributes.rrule")
    Slo_id = jResp.StringOf("data[i].attributes.slo_id")
    Start = jResp.IntOf("data[i].attributes.start")
    Timezone = jResp.StringOf("data[i].attributes.timezone")
    id = jResp.StringOf("data[i].id")
    v_type = jResp.StringOf("data[i].type")
    i = i + 1
Loop

Curl Command

curl -G -d "offset=-62147425"
	-d "limit=-62147425"
	-H "Accept: application/json"
https://api.app.ddog-gov.com/api/v1/slo/correction

Postman Collection Item JSON

{
  "name": "Get all SLO corrections",
  "request": {
    "method": "GET",
    "header": [
      {
        "key": "Accept",
        "value": "application/json"
      }
    ],
    "url": {
      "raw": "{{baseUrl}}/api/v1/slo/correction?offset=-62147425&limit=-62147425",
      "host": [
        "{{baseUrl}}"
      ],
      "path": [
        "api",
        "v1",
        "slo",
        "correction"
      ],
      "query": [
        {
          "key": "offset",
          "value": "-62147425",
          "description": "The specific offset to use as the beginning of the returned response."
        },
        {
          "key": "limit",
          "value": "-62147425",
          "description": "The number of SLO corrections to return in the response. Default is 25."
        }
      ]
    },
    "description": "Get all Service Level Objective corrections."
  },
  "response": [
    {
      "name": "OK",
      "originalRequest": {
        "method": "GET",
        "header": [
          {
            "key": "Accept",
            "value": "application/json"
          },
          {
            "description": "Added as a part of security scheme: apikey",
            "key": "DD-API-KEY",
            "value": "<API Key>"
          }
        ],
        "url": {
          "raw": "{{baseUrl}}/api/v1/slo/correction?offset=-62147425&limit=-62147425",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "v1",
            "slo",
            "correction"
          ],
          "query": [
            {
              "key": "offset",
              "value": "-62147425",
              "description": "The specific offset to use as the beginning of the returned response."
            },
            {
              "key": "limit",
              "value": "-62147425",
              "description": "The number of SLO corrections to return in the response. Default is 25."
            }
          ]
        }
      },
      "status": "OK",
      "code": 200,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Content-Type",
          "value": "application/json"
        }
      ],
      "cookie": [
      ],
      "body": "{\n  \"data\": [\n    {\n      \"attributes\": {\n        \"category\": \"Scheduled Maintenance\",\n        \"created_at\": -74919575,\n        \"creator\": {\n          \"email\": \"ex veniam\",\n          \"handle\": \"velit\",\n          \"name\": \"voluptate in sit veniam Lorem\"\n        },\n        \"description\": \"veniam laboris\",\n        \"duration\": 3600,\n        \"end\": -8908818,\n        \"modified_at\": 5115488,\n        \"modifier\": {\n          \"email\": \"sit consequat\",\n          \"handle\": \"magna irure consequat\",\n          \"name\": \"labore aliquip consequat fugiat\"\n        },\n        \"rrule\": \"FREQ=DAILY;INTERVAL=10;COUNT=5\",\n        \"slo_id\": \"labore commodo\",\n        \"start\": 6104289,\n        \"timezone\": \"consectetur fugiat elit laborum deserunt\"\n      },\n      \"id\": \"anim\",\n      \"type\": \"correction\"\n    },\n    {\n      \"attributes\": {\n        \"category\": \"Scheduled Maintenance\",\n        \"created_at\": -50145390,\n        \"creator\": {\n          \"email\": \"aliquip amet\",\n          \"handle\": \"amet ex\",\n          \"name\": \"sed non proident\"\n        },\n        \"description\": \"laborum reprehenderit\",\n        \"duration\": 3600,\n        \"end\": -50463285,\n        \"modified_at\": -64168623,\n        \"modifier\": {\n          \"email\": \"in minim s\",\n          \"handle\": \"id aliqua\",\n          \"name\": \"officia do fugiat\"\n        },\n        \"rrule\": \"FREQ=DAILY;INTERVAL=10;COUNT=5\",\n        \"slo_id\": \"sit nost\",\n        \"start\": 47690351,\n        \"timezone\": \"consequat ipsum quis ut\"\n      },\n      \"id\": \"incididunt eiusmod id\",\n      \"type\": \"correction\"\n    }\n  ],\n  \"meta\": {\n    \"page\": {\n      \"total_count\": -1541220,\n      \"total_filtered_count\": -20550176\n    }\n  }\n}"
    },
    {
      "name": "Forbidden",
      "originalRequest": {
        "method": "GET",
        "header": [
          {
            "key": "Accept",
            "value": "application/json"
          },
          {
            "description": "Added as a part of security scheme: apikey",
            "key": "DD-API-KEY",
            "value": "<API Key>"
          }
        ],
        "url": {
          "raw": "{{baseUrl}}/api/v1/slo/correction?offset=-62147425&limit=-62147425",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "v1",
            "slo",
            "correction"
          ],
          "query": [
            {
              "key": "offset",
              "value": "-62147425",
              "description": "The specific offset to use as the beginning of the returned response."
            },
            {
              "key": "limit",
              "value": "-62147425",
              "description": "The number of SLO corrections to return in the response. Default is 25."
            }
          ]
        }
      },
      "status": "Forbidden",
      "code": 403,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Content-Type",
          "value": "application/json"
        }
      ],
      "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"
          },
          {
            "description": "Added as a part of security scheme: apikey",
            "key": "DD-API-KEY",
            "value": "<API Key>"
          }
        ],
        "url": {
          "raw": "{{baseUrl}}/api/v1/slo/correction?offset=-62147425&limit=-62147425",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "v1",
            "slo",
            "correction"
          ],
          "query": [
            {
              "key": "offset",
              "value": "-62147425",
              "description": "The specific offset to use as the beginning of the returned response."
            },
            {
              "key": "limit",
              "value": "-62147425",
              "description": "The number of SLO corrections to return in the response. Default is 25."
            }
          ]
        }
      },
      "status": "Too Many Requests",
      "code": 429,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Content-Type",
          "value": "application/json"
        }
      ],
      "cookie": [
      ],
      "body": "{\n  \"errors\": [\n    \"Bad Request\",\n    \"Bad Request\"\n  ]\n}"
    }
  ]
}