Chilkat Online Tools

Perl / Zoom API / Get chat messages reports

Back to Collection Items

use chilkat();

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

$http = chilkat::CkHttp->new();

$queryParams = chilkat::CkJsonObject->new();
$queryParams->UpdateString("from","1989-05-07");
$queryParams->UpdateString("to","1989-05-07");
$queryParams->UpdateInt("page_size",30);
$queryParams->UpdateString("next_page_token","quis officia in reprehenderit");
$queryParams->UpdateString("include_fields","deleted_messages");

# Adds the "Authorization: Bearer <access_token>" header.
$http->put_AuthToken("<access_token>");

# resp is a HttpResponse
$resp = $http->QuickRequestParams("GET","https://api.zoom.us/v2/report/chat/sessions/:sessionId",$queryParams);
if ($http->get_LastMethodSuccess() == 0) {
    print $http->lastErrorText() . "\r\n";
    exit;
}

$sbResponseBody = chilkat::CkStringBuilder->new();
$resp->GetBodySb($sbResponseBody);

$jResp = chilkat::CkJsonObject->new();
$jResp->LoadSb($sbResponseBody);
$jResp->put_EmitCompact(0);

print "Response Body:" . "\r\n";
print $jResp->emit() . "\r\n";

$respStatusCode = $resp->get_StatusCode();
print "Response Status Code = " . $respStatusCode . "\r\n";
if ($respStatusCode >= 400) {
    print "Response Header:" . "\r\n";
    print $resp->header() . "\r\n";
    print "Failed." . "\r\n";

    exit;
}

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

# {
#   "from": "string [date]",
#   "to": "string [date]",
#   "page_size": "integer",
#   "next_page_token": "string",
#   "messages": [
#     {
#       "id": "0fbd238a0519d3abb0e4ce",
#       "message": "I am good.",
#       "sender": "user@example.com",
#       "date_time": "2019-09-17T20:25:17Z",
#       "reply_main_message_id": "{52400403-DA96-4D7B-9E05-C1C399FF0725}",
#       "reply_main_message_timestamp": "1568751917976"
#     },
#     {
#       "id": "38a0fbd205abb0e4ce19d3",
#       "message": "user has sent you a file",
#       "sender": "user@example.com",
#       "date_time": "2019-09-17T20:25:18Z",
#       "reply_main_message_id": "{52400403-DA96-4D7B-9E05-C1C399FF0726}",
#       "reply_main_message_timestamp": "1568751917976",
#       "files": [
#         {
#           "file_id": "LqfULZp2SIWBGe_GNgrRFw",
#           "file_name": "example.txt",
#           "file_size": 14358,
#           "download_url": "https://example.com/file/download/LqfULZp2SIWBGe_GNgrRFw"
#         }
#       ]
#     }
#   ],
#   "edited_messages": [
#     {
#       "id": "0fbd238a0519d3abb0e4ce",
#       "message": "I am good.",
#       "sender": "user@example.com",
#       "date_time": "2019-09-17T20:25:17Z",
#       "reply_main_message_id": "{52400403-DA96-4D7B-9E05-C1C399FF0725}",
#       "reply_main_message_timestamp": "1568751917976"
#     },
#     {
#       "id": "38a0fbd205abb0e4ce19d3",
#       "message": "user has sent you a file",
#       "sender": "user@example.com",
#       "date_time": "2019-09-17T20:25:18Z",
#       "reply_main_message_id": "{52400403-DA96-4D7B-9E05-C1C399FF0726}",
#       "reply_main_message_timestamp": "1568751917976",
#       "files": [
#         {
#           "file_id": "LqfULZp2SIWBGe_GNgrRFw",
#           "file_name": "example.txt",
#           "file_size": 14358,
#           "download_url": "https://example.com/file/download/LqfULZp2SIWBGe_GNgrRFw"
#         }
#       ]
#     }
#   ],
#   "deleted_messages": [
#     {
#       "id": "0fbd238a0519d3abb0e4ce",
#       "message": "I am good.",
#       "sender": "user@example.com",
#       "date_time": "2019-09-17T20:25:17Z",
#       "reply_main_message_id": "{52400403-DA96-4D7B-9E05-C1C399FF0725}",
#       "reply_main_message_timestamp": "1568751917976"
#     },
#     {
#       "id": "38a0fbd205abb0e4ce19d3",
#       "message": "user has sent you a file",
#       "sender": "user@example.com",
#       "date_time": "2019-09-17T20:25:18Z",
#       "reply_main_message_id": "{52400403-DA96-4D7B-9E05-C1C399FF0726}",
#       "reply_main_message_timestamp": "1568751917976",
#       "files": [
#         {
#           "file_id": "LqfULZp2SIWBGe_GNgrRFw",
#           "file_name": "example.txt",
#           "file_size": 14358,
#           "download_url": "https://example.com/file/download/LqfULZp2SIWBGe_GNgrRFw"
#         }
#       ]
#     }
#   ]
# }

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

$date_time = chilkat::CkDtObj->new();

$from = $jResp->stringOf("from");
$v_to = $jResp->stringOf("to");
$page_size = $jResp->stringOf("page_size");
$next_page_token = $jResp->stringOf("next_page_token");
$i = 0;
$count_i = $jResp->SizeOfArray("messages");
while ($i < $count_i) {
    $jResp->put_I($i);
    $id = $jResp->stringOf("messages[i].id");
    $message = $jResp->stringOf("messages[i].message");
    $sender = $jResp->stringOf("messages[i].sender");
    $jResp->DtOf("messages[i].date_time",0,$date_time);
    $reply_main_message_id = $jResp->stringOf("messages[i].reply_main_message_id");
    $reply_main_message_timestamp = $jResp->stringOf("messages[i].reply_main_message_timestamp");
    $j = 0;
    $count_j = $jResp->SizeOfArray("messages[i].files");
    while ($j < $count_j) {
        $jResp->put_J($j);
        $file_id = $jResp->stringOf("messages[i].files[j].file_id");
        $file_name = $jResp->stringOf("messages[i].files[j].file_name");
        $file_size = $jResp->IntOf("messages[i].files[j].file_size");
        $download_url = $jResp->stringOf("messages[i].files[j].download_url");
        $j = $j + 1;
    }

    $i = $i + 1;
}

$i = 0;
$count_i = $jResp->SizeOfArray("edited_messages");
while ($i < $count_i) {
    $jResp->put_I($i);
    $id = $jResp->stringOf("edited_messages[i].id");
    $message = $jResp->stringOf("edited_messages[i].message");
    $sender = $jResp->stringOf("edited_messages[i].sender");
    $jResp->DtOf("edited_messages[i].date_time",0,$date_time);
    $reply_main_message_id = $jResp->stringOf("edited_messages[i].reply_main_message_id");
    $reply_main_message_timestamp = $jResp->stringOf("edited_messages[i].reply_main_message_timestamp");
    $j = 0;
    $count_j = $jResp->SizeOfArray("edited_messages[i].files");
    while ($j < $count_j) {
        $jResp->put_J($j);
        $file_id = $jResp->stringOf("edited_messages[i].files[j].file_id");
        $file_name = $jResp->stringOf("edited_messages[i].files[j].file_name");
        $file_size = $jResp->IntOf("edited_messages[i].files[j].file_size");
        $download_url = $jResp->stringOf("edited_messages[i].files[j].download_url");
        $j = $j + 1;
    }

    $i = $i + 1;
}

$i = 0;
$count_i = $jResp->SizeOfArray("deleted_messages");
while ($i < $count_i) {
    $jResp->put_I($i);
    $id = $jResp->stringOf("deleted_messages[i].id");
    $message = $jResp->stringOf("deleted_messages[i].message");
    $sender = $jResp->stringOf("deleted_messages[i].sender");
    $jResp->DtOf("deleted_messages[i].date_time",0,$date_time);
    $reply_main_message_id = $jResp->stringOf("deleted_messages[i].reply_main_message_id");
    $reply_main_message_timestamp = $jResp->stringOf("deleted_messages[i].reply_main_message_timestamp");
    $j = 0;
    $count_j = $jResp->SizeOfArray("deleted_messages[i].files");
    while ($j < $count_j) {
        $jResp->put_J($j);
        $file_id = $jResp->stringOf("deleted_messages[i].files[j].file_id");
        $file_name = $jResp->stringOf("deleted_messages[i].files[j].file_name");
        $file_size = $jResp->IntOf("deleted_messages[i].files[j].file_size");
        $download_url = $jResp->stringOf("deleted_messages[i].files[j].download_url");
        $j = $j + 1;
    }

    $i = $i + 1;
}

Curl Command

curl -G -d "from=1989-05-07"
	-d "to=1989-05-07"
	-d "page_size=30"
	-d "next_page_token=quis%20officia%20in%20reprehenderit"
	-d "include_fields=deleted_messages"
	-H "Authorization: Bearer <access_token>"
https://api.zoom.us/v2/report/chat/sessions/:sessionId

Postman Collection Item JSON

{
  "name": "Get chat messages reports",
  "request": {
    "method": "GET",
    "header": [
    ],
    "url": {
      "raw": "{{baseUrl}}/report/chat/sessions/:sessionId?from=1989-05-07&to=1989-05-07&page_size=30&next_page_token=quis officia in reprehenderit&include_fields=deleted_messages",
      "host": [
        "{{baseUrl}}"
      ],
      "path": [
        "report",
        "chat",
        "sessions",
        ":sessionId"
      ],
      "query": [
        {
          "key": "from",
          "value": "1989-05-07",
          "description": "(Required) Start date in 'yyyy-mm-dd' format. The date range defined by the \"from\" and \"to\" parameters should only be one month as the report includes only one month worth of data at once."
        },
        {
          "key": "to",
          "value": "1989-05-07",
          "description": "(Required) End date."
        },
        {
          "key": "page_size",
          "value": "30",
          "description": "The number of records returned within a single API call."
        },
        {
          "key": "next_page_token",
          "value": "quis officia in reprehenderit",
          "description": "The next page token is used to paginate through large result sets. A next page token will be returned whenever the set of available results exceeds the current page size. The expiration period for this token is 15 minutes."
        },
        {
          "key": "include_fields",
          "value": "deleted_messages",
          "description": "Return all edited and deleted messages. The API only returns this value if the `include_fields` query parameter contains the `edited_messages` and/or the `deleted_messages` values.\n\nTo include **both** edited and deleted messages, comma-separate both values."
        }
      ],
      "variable": [
        {
          "key": "sessionId",
          "value": "quis officia in reprehenderit",
          "description": "(Required) Chat session ID."
        }
      ]
    },
    "description": "Use this API to get Zoom Chat message reports for a specified period of time. The monthly date range must be within the last six months.\n\n**Scopes:** `report_chat:read:admin`<br>**[Rate Limit Label](https://marketplace.zoom.us/docs/api-reference/rate-limits#rate-limits):** `Medium`\n\n**Prerequisites:** \n* A Pro or higher plan \n* Report chat permissions"
  },
  "response": [
    {
      "name": "**HTTP Status Code:** `200` <br>\nArchived chat messages returned.",
      "originalRequest": {
        "method": "GET",
        "header": [
          {
            "description": "Added as a part of security scheme: oauth2",
            "key": "Authorization",
            "value": "<token>"
          }
        ],
        "url": {
          "raw": "{{baseUrl}}/report/chat/sessions/:sessionId?from=1989-05-07&to=1989-05-07&page_size=30&next_page_token=quis officia in reprehenderit&include_fields=deleted_messages",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "report",
            "chat",
            "sessions",
            ":sessionId"
          ],
          "query": [
            {
              "key": "from",
              "value": "1989-05-07"
            },
            {
              "key": "to",
              "value": "1989-05-07"
            },
            {
              "key": "page_size",
              "value": "30"
            },
            {
              "key": "next_page_token",
              "value": "quis officia in reprehenderit"
            },
            {
              "key": "include_fields",
              "value": "deleted_messages"
            }
          ],
          "variable": [
            {
              "key": "sessionId",
              "value": "quis officia in reprehenderit",
              "description": "(Required) Chat session ID."
            }
          ]
        }
      },
      "status": "OK",
      "code": 200,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Content-Type",
          "value": "application/json"
        }
      ],
      "cookie": [
      ],
      "body": "{\n \"from\": \"string [date]\",\n \"to\": \"string [date]\",\n \"page_size\": \"integer\",\n \"next_page_token\": \"string\",\n \"messages\": [\n  {\n   \"id\": \"0fbd238a0519d3abb0e4ce\",\n   \"message\": \"I am good.\",\n   \"sender\": \"user@example.com\",\n   \"date_time\": \"2019-09-17T20:25:17Z\",\n   \"reply_main_message_id\": \"{52400403-DA96-4D7B-9E05-C1C399FF0725}\",\n   \"reply_main_message_timestamp\": \"1568751917976\"\n  },\n  {\n   \"id\": \"38a0fbd205abb0e4ce19d3\",\n   \"message\": \"user has sent you a file\",\n   \"sender\": \"user@example.com\",\n   \"date_time\": \"2019-09-17T20:25:18Z\",\n   \"reply_main_message_id\": \"{52400403-DA96-4D7B-9E05-C1C399FF0726}\",\n   \"reply_main_message_timestamp\": \"1568751917976\",\n   \"files\": [\n    {\n     \"file_id\": \"LqfULZp2SIWBGe_GNgrRFw\",\n     \"file_name\": \"example.txt\",\n     \"file_size\": 14358,\n     \"download_url\": \"https://example.com/file/download/LqfULZp2SIWBGe_GNgrRFw\"\n    }\n   ]\n  }\n ],\n \"edited_messages\": [\n  {\n   \"id\": \"0fbd238a0519d3abb0e4ce\",\n   \"message\": \"I am good.\",\n   \"sender\": \"user@example.com\",\n   \"date_time\": \"2019-09-17T20:25:17Z\",\n   \"reply_main_message_id\": \"{52400403-DA96-4D7B-9E05-C1C399FF0725}\",\n   \"reply_main_message_timestamp\": \"1568751917976\"\n  },\n  {\n   \"id\": \"38a0fbd205abb0e4ce19d3\",\n   \"message\": \"user has sent you a file\",\n   \"sender\": \"user@example.com\",\n   \"date_time\": \"2019-09-17T20:25:18Z\",\n   \"reply_main_message_id\": \"{52400403-DA96-4D7B-9E05-C1C399FF0726}\",\n   \"reply_main_message_timestamp\": \"1568751917976\",\n   \"files\": [\n    {\n     \"file_id\": \"LqfULZp2SIWBGe_GNgrRFw\",\n     \"file_name\": \"example.txt\",\n     \"file_size\": 14358,\n     \"download_url\": \"https://example.com/file/download/LqfULZp2SIWBGe_GNgrRFw\"\n    }\n   ]\n  }\n ],\n \"deleted_messages\": [\n  {\n   \"id\": \"0fbd238a0519d3abb0e4ce\",\n   \"message\": \"I am good.\",\n   \"sender\": \"user@example.com\",\n   \"date_time\": \"2019-09-17T20:25:17Z\",\n   \"reply_main_message_id\": \"{52400403-DA96-4D7B-9E05-C1C399FF0725}\",\n   \"reply_main_message_timestamp\": \"1568751917976\"\n  },\n  {\n   \"id\": \"38a0fbd205abb0e4ce19d3\",\n   \"message\": \"user has sent you a file\",\n   \"sender\": \"user@example.com\",\n   \"date_time\": \"2019-09-17T20:25:18Z\",\n   \"reply_main_message_id\": \"{52400403-DA96-4D7B-9E05-C1C399FF0726}\",\n   \"reply_main_message_timestamp\": \"1568751917976\",\n   \"files\": [\n    {\n     \"file_id\": \"LqfULZp2SIWBGe_GNgrRFw\",\n     \"file_name\": \"example.txt\",\n     \"file_size\": 14358,\n     \"download_url\": \"https://example.com/file/download/LqfULZp2SIWBGe_GNgrRFw\"\n    }\n   ]\n  }\n ]\n}"
    },
    {
      "name": "**Error Code:**`300` <br>\nThe next page token is either invalid or has expired.<br>\nReport requested exceeds 6 month limit.",
      "originalRequest": {
        "method": "GET",
        "header": [
          {
            "description": "Added as a part of security scheme: oauth2",
            "key": "Authorization",
            "value": "<token>"
          }
        ],
        "url": {
          "raw": "{{baseUrl}}/report/chat/sessions/:sessionId?from=1989-05-07&to=1989-05-07&page_size=30&next_page_token=quis officia in reprehenderit&include_fields=deleted_messages",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "report",
            "chat",
            "sessions",
            ":sessionId"
          ],
          "query": [
            {
              "key": "from",
              "value": "1989-05-07"
            },
            {
              "key": "to",
              "value": "1989-05-07"
            },
            {
              "key": "page_size",
              "value": "30"
            },
            {
              "key": "next_page_token",
              "value": "quis officia in reprehenderit"
            },
            {
              "key": "include_fields",
              "value": "deleted_messages"
            }
          ],
          "variable": [
            {
              "key": "sessionId",
              "value": "quis officia in reprehenderit",
              "description": "(Required) Chat session ID."
            }
          ]
        }
      },
      "status": "Multiple Choices",
      "code": 300,
      "_postman_previewlanguage": "text",
      "header": [
        {
          "key": "Content-Type",
          "value": "text/plain"
        }
      ],
      "cookie": [
      ],
      "body": ""
    }
  ]
}