Chilkat Online Tools

Foxpro / Squadcast API V3 / Incident Export

Back to Collection Items

LOCAL loHttp
LOCAL lnSuccess
LOCAL loQueryParams
LOCAL loResp

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

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Http')
loHttp = CreateObject('Chilkat.Http')

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loQueryParams = CreateObject('Chilkat.JsonObject')
loQueryParams.UpdateString("start_time","2020-08-16T11:43:51.947Z")
loQueryParams.UpdateString("end_time","2020-08-16T11:43:51.947Z")
loQueryParams.UpdateString("status","resolved")
loQueryParams.UpdateString("type","csv")
loQueryParams.UpdateString("services","5c7cf6bff8dde3001282aa56")
loQueryParams.UpdateString("services","5c7cf6bff8dde3001282aa57")
loQueryParams.UpdateString("assigned_to","5c7cf6bff8dde3001282aa33")

* Adds the "Authorization: Bearer <access_token>" header.
loHttp.AuthToken = "<access_token>"

loResp = loHttp.QuickRequestParams("GET","https://api.squadcast.com/v3/incidents/export/",loQueryParams)
IF (loHttp.LastMethodSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loQueryParams
    CANCEL
ENDIF

? STR(loResp.StatusCode)
? loResp.BodyStr
RELEASE loResp

RELEASE loHttp
RELEASE loQueryParams

Curl Command

curl -G -d "start_time=2020-08-16T11%3A43%3A51.947Z"
	-d "end_time=2020-08-16T11%3A43%3A51.947Z"
	-d "status=resolved"
	-d "type=csv"
	-d "services=5c7cf6bff8dde3001282aa56"
	-d "services=5c7cf6bff8dde3001282aa57"
	-d "assigned_to=5c7cf6bff8dde3001282aa33"
	-H "Authorization: Bearer <access_token>"
https://api.squadcast.com/v3/incidents/export/

Postman Collection Item JSON

{
  "name": "Incident Export",
  "request": {
    "auth": {
      "type": "bearer",
      "bearer": [
        {
          "key": "token",
          "value": "{{sq_pb_auth_header}}",
          "type": "string"
        }
      ]
    },
    "method": "GET",
    "header": [
    ],
    "url": {
      "raw": "{{baseUrl}}/incidents/export/?start_time=2020-08-16T11:43:51.947Z&end_time=2020-08-16T11:43:51.947Z&status=resolved&type=csv&services=5c7cf6bff8dde3001282aa56&services=5c7cf6bff8dde3001282aa57&assigned_to=5c7cf6bff8dde3001282aa33",
      "host": [
        "{{baseUrl}}"
      ],
      "path": [
        "incidents",
        "export",
        ""
      ],
      "query": [
        {
          "key": "start_time",
          "value": "2020-08-16T11:43:51.947Z"
        },
        {
          "key": "end_time",
          "value": "2020-08-16T11:43:51.947Z"
        },
        {
          "key": "status",
          "value": "resolved"
        },
        {
          "key": "type",
          "value": "csv"
        },
        {
          "key": "services",
          "value": "5c7cf6bff8dde3001282aa56"
        },
        {
          "key": "services",
          "value": "5c7cf6bff8dde3001282aa57"
        },
        {
          "key": "assigned_to",
          "value": "5c7cf6bff8dde3001282aa33"
        }
      ]
    },
    "description": "- This endpoint is used to export the incident details into a `csv` or `json` file.\n- Requires `access_token` as a `Bearer {{token}}` in the `Authorization` header.\n- Header field/value: `Content-Type`: `text/csv`\n\n\nQuery Params:\n```\ntype: csv or json\n\nstart_time: filter by date range\n\nend_time: filter by date range\n\nservices: filter by services\n\nsources: filter by alert sources\n\nassigned_to: filter by assignee\n\nstatus: filter by incident status\n```"
  },
  "response": [
    {
      "name": "200 OK",
      "originalRequest": {
        "method": "GET",
        "header": [
        ],
        "url": {
          "raw": "{{baseUrl}}/incidents/export/?start_time=2020-08-16T11:43:51.947Z&end_time=2020-08-16T11:43:51.947Z&status=resolved&type=csv&services=5c7cf6bff8dde3001282aa56&services=5c7cf6bff8dde3001282aa57&assigned_to=5c7cf6bff8dde3001282aa33",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "incidents",
            "export",
            ""
          ],
          "query": [
            {
              "key": "start_time",
              "value": "2020-08-16T11:43:51.947Z"
            },
            {
              "key": "end_time",
              "value": "2020-08-16T11:43:51.947Z"
            },
            {
              "key": "status",
              "value": "resolved"
            },
            {
              "key": "type",
              "value": "csv"
            },
            {
              "key": "services",
              "value": "5c7cf6bff8dde3001282aa56"
            },
            {
              "key": "services",
              "value": "5c7cf6bff8dde3001282aa57"
            },
            {
              "key": "assigned_to",
              "value": "5c7cf6bff8dde3001282aa33"
            }
          ]
        }
      },
      "_postman_previewlanguage": null,
      "header": null,
      "cookie": [
      ],
      "body": null
    },
    {
      "name": "401 Unauthorized",
      "originalRequest": {
        "method": "GET",
        "header": [
        ],
        "url": {
          "raw": "{{baseUrl}}/incidents/export/?start_time=2020-08-16T11:43:51.947Z&end_time=2020-08-16T11:43:51.947Z&status=resolved&type=csv&services=5c7cf6bff8dde3001282aa56&services=5c7cf6bff8dde3001282aa57&assigned_to=5c7cf6bff8dde3001282aa33",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "incidents",
            "export",
            ""
          ],
          "query": [
            {
              "key": "start_time",
              "value": "2020-08-16T11:43:51.947Z"
            },
            {
              "key": "end_time",
              "value": "2020-08-16T11:43:51.947Z"
            },
            {
              "key": "status",
              "value": "resolved"
            },
            {
              "key": "type",
              "value": "csv"
            },
            {
              "key": "services",
              "value": "5c7cf6bff8dde3001282aa56"
            },
            {
              "key": "services",
              "value": "5c7cf6bff8dde3001282aa57"
            },
            {
              "key": "assigned_to",
              "value": "5c7cf6bff8dde3001282aa33"
            }
          ]
        }
      },
      "_postman_previewlanguage": null,
      "header": null,
      "cookie": [
      ],
      "body": null
    },
    {
      "name": "400 Bad Request",
      "originalRequest": {
        "method": "GET",
        "header": [
        ],
        "url": {
          "raw": "{{baseUrl}}/incidents/export/?start_time=2020-08-16T11:43:51.947Z&end_time=2020-08-16T11:43:51.947Z&status=resolved&type=csv&services=5c7cf6bff8dde3001282aa56&services=5c7cf6bff8dde3001282aa57&assigned_to=5c7cf6bff8dde3001282aa33",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "incidents",
            "export",
            ""
          ],
          "query": [
            {
              "key": "start_time",
              "value": "2020-08-16T11:43:51.947Z"
            },
            {
              "key": "end_time",
              "value": "2020-08-16T11:43:51.947Z"
            },
            {
              "key": "status",
              "value": "resolved"
            },
            {
              "key": "type",
              "value": "csv"
            },
            {
              "key": "services",
              "value": "5c7cf6bff8dde3001282aa56"
            },
            {
              "key": "services",
              "value": "5c7cf6bff8dde3001282aa57"
            },
            {
              "key": "assigned_to",
              "value": "5c7cf6bff8dde3001282aa33"
            }
          ]
        }
      },
      "_postman_previewlanguage": null,
      "header": null,
      "cookie": [
      ],
      "body": null
    }
  ]
}