Chilkat Online Tools

VBScript / Anypoint Platform APIs / Get csv formatted audit logs

Back to Collection Items

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

' 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")
set http = CreateObject("Chilkat.Http")

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.HttpRequest")
set req = CreateObject("Chilkat.HttpRequest")
req.AddParam "startDate","2021-04-20T12:24:36.971Z"
req.AddParam "endDate","2021-04-21T12:24:36.971Z"
req.AddParam "ascending","false"

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set jsonParam4 = CreateObject("Chilkat.JsonObject")
req.AddParam "accessToken",jsonParam4.Emit()

req.AddHeader "Authorization","Bearer {{token}}"

' resp is a Chilkat.HttpResponse
Set resp = http.PostUrlEncoded("https://domain.com/audit/v2/organizations/{{organization_id}}/query.csv",req)
If (http.LastMethodSuccess = 0) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

outFile.WriteLine(resp.StatusCode)
outFile.WriteLine(resp.BodyStr)


outFile.Close

Curl Command

curl -X POST
	-H "Authorization: Bearer {{token}}"
	--data-urlencode 'startDate=2021-04-20T12:24:36.971Z'
	--data-urlencode 'endDate=2021-04-21T12:24:36.971Z'
	--data-urlencode 'ascending=false'
	--data-urlencode 'accessToken={{token}}'
https://domain.com/audit/v2/organizations/{{organization_id}}/query.csv

Postman Collection Item JSON

{
  "name": "Get csv formatted audit logs",
  "request": {
    "method": "POST",
    "header": [
      {
        "key": "Authorization",
        "value": "Bearer {{token}}",
        "type": "text"
      }
    ],
    "body": {
      "mode": "urlencoded",
      "urlencoded": [
        {
          "key": "startDate",
          "value": "2021-04-20T12:24:36.971Z",
          "type": "text"
        },
        {
          "key": "endDate",
          "value": "2021-04-21T12:24:36.971Z",
          "type": "text"
        },
        {
          "key": "ascending",
          "value": "false",
          "type": "text"
        },
        {
          "key": "accessToken",
          "value": "{{token}}",
          "type": "text"
        }
      ]
    },
    "url": {
      "raw": "{{url}}/audit/v2/organizations/{{organization_id}}/query.csv",
      "host": [
        "{{url}}"
      ],
      "path": [
        "audit",
        "v2",
        "organizations",
        "{{organization_id}}",
        "query.csv"
      ]
    }
  },
  "response": [
  ]
}