Chilkat Online Tools

VB6 / Sunshine Conversations API / List Messages

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

http.BasicAuth = 1
http.Login = "username"
http.Password = "password"

Dim queryParams As New ChilkatJsonObject
success = queryParams.UpdateString("page[after]","5e1606762556d93e9c176f69")
success = queryParams.UpdateString("page[before]","5e1606762556d93e9c176f69")
success = queryParams.UpdateInt("page[size]",10)

Dim resp As ChilkatHttpResponse
Set resp = http.QuickRequestParams("GET","https://domain.com/v2/apps/{{appId}}/conversations/{{conversationId}}/messages",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)

' {
'   "messages": [
'     {
'       "id": "5e552ef595e5206375bb835d",
'       "received": "2019-03-21T18:48:52.760Z",
'       "author": {
'         "type": "business",
'         "userId": "5963c0d619a30a2e00de36b8",
'         "displayName": "Steve",
'         "avatarUrl": "https://www.gravatar.com/image.jpg"
'       },
'       "content": {
'         "type": "text",
'         "text": "Hello!",
'         "actions": [
'           {
'             "value": "<Error: Too many levels of nesting to fake this schema>"
'           },
'           {
'             "value": "<Error: Too many levels of nesting to fake this schema>"
'           }
'         ]
'       },
'       "source": {
'         "type": "ios",
'         "integrationId": "de13bee15b51033b34162411",
'         "originalMessageId": "5f40256af057d0000dda9bd7",
'         "originalMessageTimestamp": "2019-03-21T18:45:53.720Z",
'         "client": {
'           "id": "5c9a34160c89726709136733",
'           "type": "telegram",
'           "status": "active",
'           "integrationId": "582dedf230e788746891281a",
'           "externalId": "your-own-id",
'           "lastSeen": "2020-08-20T16:13:07.462Z",
'           "linkedAt": "2020-06-23T14:33:47.492Z",
'           "displayName": "Steve",
'           "avatarUrl": "http://EGnaLcOXhxGTLKJ.jpuft043dnis59F",
'           "info": {},
'           "raw": {}
'         },
'         "device": {
'           "id": "de13bee15b51033b34162411",
'           "type": "web",
'           "guid": "in laboris ex",
'           "clientId": "amet minim do eu",
'           "status": "active",
'           "integrationId": "sed enim aliquip commodo",
'           "lastSeen": "elit proident",
'           "pushNotificationToken": "officia labore",
'           "info": {},
'           "appVersion": "irure deserunt qui veniam consequat"
'         }
'       },
'       "quotedMessage": {
'         "type": "message",
'         "message": {
'           "value": "<Error: Too many levels of nesting to fake this schema>"
'         }
'       },
'       "metadata": {
'         "lang": "en-ca"
'       },
'       "deleted": true
'     },
'     {
'       "id": "5e552ef595e5206375bb835d",
'       "received": "2019-03-21T18:48:52.760Z",
'       "author": {
'         "type": "business",
'         "userId": "5963c0d619a30a2e00de36b8",
'         "displayName": "Steve",
'         "avatarUrl": "https://www.gravatar.com/image.jpg"
'       },
'       "content": {
'         "type": "text",
'         "text": "Hello!",
'         "actions": [
'           {
'             "value": "<Error: Too many levels of nesting to fake this schema>"
'           },
'           {
'             "value": "<Error: Too many levels of nesting to fake this schema>"
'           }
'         ]
'       },
'       "source": {
'         "type": "ios",
'         "integrationId": "de13bee15b51033b34162411",
'         "originalMessageId": "5f40256af057d0000dda9bd7",
'         "originalMessageTimestamp": "2019-03-21T18:45:53.720Z",
'         "client": {
'           "id": "5c9a34160c89726709136733",
'           "type": "telegram",
'           "status": "active",
'           "integrationId": "582dedf230e788746891281a",
'           "externalId": "your-own-id",
'           "lastSeen": "2020-08-20T16:13:07.462Z",
'           "linkedAt": "2020-06-23T14:33:47.492Z",
'           "displayName": "Steve",
'           "avatarUrl": "http://bnAEzvgnDimaLnqEYLUCQXbU.ywrnS-uvD-0kBryUe",
'           "info": {},
'           "raw": {}
'         },
'         "device": {
'           "id": "de13bee15b51033b34162411",
'           "type": "web",
'           "guid": "laborum eiusmod adipisicing esse",
'           "clientId": "labore adipisicing eiusmod",
'           "status": "inactive",
'           "integrationId": "aute",
'           "lastSeen": "anim reprehenderit proident pariatur incididunt",
'           "pushNotificationToken": "qui dolore Excepteur in",
'           "info": {},
'           "appVersion": "incididunt labore dolore pariatur"
'         }
'       },
'       "quotedMessage": {
'         "type": "message",
'         "message": {
'           "value": "<Error: Too many levels of nesting to fake this schema>"
'         }
'       },
'       "metadata": {
'         "lang": "en-ca"
'       },
'       "deleted": true
'     }
'   ],
'   "meta": {
'     "hasMore": false,
'     "afterCursor": "55c8d9758590aa1900b9b9f6",
'     "beforeCursor": "55c8d9758590aa1900b9b9f6"
'   },
'   "links": {
'     "prev": "https://api.smooch.io/v2/apps?page[before]=fcafad804c39a39648004af9",
'     "next": "https://api.smooch.io/v2/apps?page[after]=5ea868f862cdd24abf010b38"
'   }
' }

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

Dim id As String
Dim received As String
Dim v_Type As String
Dim UserId As String
Dim DisplayName As String
Dim AvatarUrl As String
Dim contentType As String
Dim Text As String
Dim sourceType As String
Dim IntegrationId As String
Dim OriginalMessageId As String
Dim OriginalMessageTimestamp As String
Dim Id As String
Dim ClientType As String
Dim Status As String
Dim ClientIntegrationId As String
Dim ExternalId As String
Dim LastSeen As String
Dim LinkedAt As String
Dim ClientDisplayName As String
Dim ClientAvatarUrl As String
Dim DeviceId As String
Dim DeviceType As String
Dim Guid As String
Dim ClientId As String
Dim DeviceStatus As String
Dim DeviceIntegrationId As String
Dim DeviceLastSeen As String
Dim PushNotificationToken As String
Dim AppVersion As String
Dim quotedMessageType As String
Dim Value As String
Dim Lang As String
Dim deleted As Long
Dim j As Long
Dim count_j As Long
Dim value As String

Dim HasMore As Long
HasMore = jResp.BoolOf("meta.hasMore")
Dim AfterCursor As String
AfterCursor = jResp.StringOf("meta.afterCursor")
Dim BeforeCursor As String
BeforeCursor = jResp.StringOf("meta.beforeCursor")
Dim Prev As String
Prev = jResp.StringOf("links.prev")
Dim v_Next As String
v_Next = jResp.StringOf("links.next")
Dim i As Long
i = 0
Dim count_i As Long
count_i = jResp.SizeOfArray("messages")
Do While i < count_i
    jResp.I = i
    id = jResp.StringOf("messages[i].id")
    received = jResp.StringOf("messages[i].received")
    v_Type = jResp.StringOf("messages[i].author.type")
    UserId = jResp.StringOf("messages[i].author.userId")
    DisplayName = jResp.StringOf("messages[i].author.displayName")
    AvatarUrl = jResp.StringOf("messages[i].author.avatarUrl")
    contentType = jResp.StringOf("messages[i].content.type")
    Text = jResp.StringOf("messages[i].content.text")
    sourceType = jResp.StringOf("messages[i].source.type")
    IntegrationId = jResp.StringOf("messages[i].source.integrationId")
    OriginalMessageId = jResp.StringOf("messages[i].source.originalMessageId")
    OriginalMessageTimestamp = jResp.StringOf("messages[i].source.originalMessageTimestamp")
    Id = jResp.StringOf("messages[i].source.client.id")
    ClientType = jResp.StringOf("messages[i].source.client.type")
    Status = jResp.StringOf("messages[i].source.client.status")
    ClientIntegrationId = jResp.StringOf("messages[i].source.client.integrationId")
    ExternalId = jResp.StringOf("messages[i].source.client.externalId")
    LastSeen = jResp.StringOf("messages[i].source.client.lastSeen")
    LinkedAt = jResp.StringOf("messages[i].source.client.linkedAt")
    ClientDisplayName = jResp.StringOf("messages[i].source.client.displayName")
    ClientAvatarUrl = jResp.StringOf("messages[i].source.client.avatarUrl")
    DeviceId = jResp.StringOf("messages[i].source.device.id")
    DeviceType = jResp.StringOf("messages[i].source.device.type")
    Guid = jResp.StringOf("messages[i].source.device.guid")
    ClientId = jResp.StringOf("messages[i].source.device.clientId")
    DeviceStatus = jResp.StringOf("messages[i].source.device.status")
    DeviceIntegrationId = jResp.StringOf("messages[i].source.device.integrationId")
    DeviceLastSeen = jResp.StringOf("messages[i].source.device.lastSeen")
    PushNotificationToken = jResp.StringOf("messages[i].source.device.pushNotificationToken")
    AppVersion = jResp.StringOf("messages[i].source.device.appVersion")
    quotedMessageType = jResp.StringOf("messages[i].quotedMessage.type")
    Value = jResp.StringOf("messages[i].quotedMessage.message.value")
    Lang = jResp.StringOf("messages[i].metadata.lang")
    deleted = jResp.BoolOf("messages[i].deleted")
    j = 0
    count_j = jResp.SizeOfArray("messages[i].content.actions")
    Do While j < count_j
        jResp.J = j
        value = jResp.StringOf("messages[i].content.actions[j].value")
        j = j + 1
    Loop
    i = i + 1
Loop

Curl Command

curl -G -d "page[after]=5e1606762556d93e9c176f69"
	-d "page[before]=5e1606762556d93e9c176f69"
	-d "page[size]=10"
	-u 'username:password'
https://domain.com/v2/apps/{{appId}}/conversations/{{conversationId}}/messages

Postman Collection Item JSON

{
  "name": "List Messages",
  "_postman_id": "9f9b265c-7546-4b49-98bf-7e4d85bae5f2",
  "request": {
    "method": "GET",
    "header": [
    ],
    "url": {
      "raw": "{{url}}/v2/apps/{{appId}}/conversations/{{conversationId}}/messages?page[after]=5e1606762556d93e9c176f69&page[before]=5e1606762556d93e9c176f69&page[size]=10",
      "host": [
        "{{url}}"
      ],
      "path": [
        "v2",
        "apps",
        "{{appId}}",
        "conversations",
        "{{conversationId}}",
        "messages"
      ],
      "query": [
        {
          "key": "page[after]",
          "value": "5e1606762556d93e9c176f69",
          "description": "Contains parameters for applying cursor pagination."
        },
        {
          "key": "page[before]",
          "value": "5e1606762556d93e9c176f69",
          "description": "Contains parameters for applying cursor pagination."
        },
        {
          "key": "page[size]",
          "value": "10",
          "description": "Contains parameters for applying cursor pagination."
        }
      ]
    },
    "description": "List all messages for a particular conversation. This API is paginated through\n[cursor pagination](#section/Introduction/API-pagination-and-records-limits), in the _backwards_ direction, with the\nmost recent (i.e. last) page of messages being returned by default. The `hasMore` flag indicates whether more messages\nexist in the direction you are currently paginating through. To page backwards in the history, use the `beforeCursor` or follow the `prev`\nlink. The page size limit is fixed at 100 messages per page.\n\n```shell\n/v2/apps/:appId/conversations/:conversationId/messages?page[before]=5f32b88acf6bf25073b2be56\n```\n"
  },
  "response": [
    {
      "id": "550b7411-8e33-4840-8701-23face25cb9a",
      "name": "Ok",
      "originalRequest": {
        "method": "GET",
        "header": [
          {
            "description": {
              "content": "Added as a part of security scheme: bearer",
              "type": "text/plain"
            },
            "key": "Authorization",
            "value": "Bearer <token>"
          }
        ],
        "url": {
          "raw": "{{baseUrl}}/v2/apps/:appId/conversations/:conversationId/messages?page[after]=5e1606762556d93e9c176f69&page[before]=5e1606762556d93e9c176f69&page[size]=10",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "v2",
            "apps",
            ":appId",
            "conversations",
            ":conversationId",
            "messages"
          ],
          "query": [
            {
              "key": "page[after]",
              "value": "5e1606762556d93e9c176f69"
            },
            {
              "key": "page[before]",
              "value": "5e1606762556d93e9c176f69"
            },
            {
              "key": "page[size]",
              "value": "10"
            }
          ],
          "variable": [
            {
              "key": "appId"
            },
            {
              "key": "conversationId"
            }
          ]
        }
      },
      "status": "OK",
      "code": 200,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Content-Type",
          "value": "application/json"
        }
      ],
      "cookie": [
      ],
      "body": "{\n \"messages\": [\n  {\n   \"id\": \"5e552ef595e5206375bb835d\",\n   \"received\": \"2019-03-21T18:48:52.760Z\",\n   \"author\": {\n    \"type\": \"business\",\n    \"userId\": \"5963c0d619a30a2e00de36b8\",\n    \"displayName\": \"Steve\",\n    \"avatarUrl\": \"https://www.gravatar.com/image.jpg\"\n   },\n   \"content\": {\n    \"type\": \"text\",\n    \"text\": \"Hello!\",\n    \"actions\": [\n     {\n      \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n     },\n     {\n      \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n     }\n    ]\n   },\n   \"source\": {\n    \"type\": \"ios\",\n    \"integrationId\": \"de13bee15b51033b34162411\",\n    \"originalMessageId\": \"5f40256af057d0000dda9bd7\",\n    \"originalMessageTimestamp\": \"2019-03-21T18:45:53.720Z\",\n    \"client\": {\n     \"id\": \"5c9a34160c89726709136733\",\n     \"type\": \"telegram\",\n     \"status\": \"active\",\n     \"integrationId\": \"582dedf230e788746891281a\",\n     \"externalId\": \"your-own-id\",\n     \"lastSeen\": \"2020-08-20T16:13:07.462Z\",\n     \"linkedAt\": \"2020-06-23T14:33:47.492Z\",\n     \"displayName\": \"Steve\",\n     \"avatarUrl\": \"http://EGnaLcOXhxGTLKJ.jpuft043dnis59F\",\n     \"info\": {},\n     \"raw\": {}\n    },\n    \"device\": {\n     \"id\": \"de13bee15b51033b34162411\",\n     \"type\": \"web\",\n     \"guid\": \"in laboris ex\",\n     \"clientId\": \"amet minim do eu\",\n     \"status\": \"active\",\n     \"integrationId\": \"sed enim aliquip commodo\",\n     \"lastSeen\": \"elit proident\",\n     \"pushNotificationToken\": \"officia labore\",\n     \"info\": {},\n     \"appVersion\": \"irure deserunt qui veniam consequat\"\n    }\n   },\n   \"quotedMessage\": {\n    \"type\": \"message\",\n    \"message\": {\n     \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n    }\n   },\n   \"metadata\": {\n    \"lang\": \"en-ca\"\n   },\n   \"deleted\": true\n  },\n  {\n   \"id\": \"5e552ef595e5206375bb835d\",\n   \"received\": \"2019-03-21T18:48:52.760Z\",\n   \"author\": {\n    \"type\": \"business\",\n    \"userId\": \"5963c0d619a30a2e00de36b8\",\n    \"displayName\": \"Steve\",\n    \"avatarUrl\": \"https://www.gravatar.com/image.jpg\"\n   },\n   \"content\": {\n    \"type\": \"text\",\n    \"text\": \"Hello!\",\n    \"actions\": [\n     {\n      \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n     },\n     {\n      \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n     }\n    ]\n   },\n   \"source\": {\n    \"type\": \"ios\",\n    \"integrationId\": \"de13bee15b51033b34162411\",\n    \"originalMessageId\": \"5f40256af057d0000dda9bd7\",\n    \"originalMessageTimestamp\": \"2019-03-21T18:45:53.720Z\",\n    \"client\": {\n     \"id\": \"5c9a34160c89726709136733\",\n     \"type\": \"telegram\",\n     \"status\": \"active\",\n     \"integrationId\": \"582dedf230e788746891281a\",\n     \"externalId\": \"your-own-id\",\n     \"lastSeen\": \"2020-08-20T16:13:07.462Z\",\n     \"linkedAt\": \"2020-06-23T14:33:47.492Z\",\n     \"displayName\": \"Steve\",\n     \"avatarUrl\": \"http://bnAEzvgnDimaLnqEYLUCQXbU.ywrnS-uvD-0kBryUe\",\n     \"info\": {},\n     \"raw\": {}\n    },\n    \"device\": {\n     \"id\": \"de13bee15b51033b34162411\",\n     \"type\": \"web\",\n     \"guid\": \"laborum eiusmod adipisicing esse\",\n     \"clientId\": \"labore adipisicing eiusmod\",\n     \"status\": \"inactive\",\n     \"integrationId\": \"aute\",\n     \"lastSeen\": \"anim reprehenderit proident pariatur incididunt\",\n     \"pushNotificationToken\": \"qui dolore Excepteur in\",\n     \"info\": {},\n     \"appVersion\": \"incididunt labore dolore pariatur\"\n    }\n   },\n   \"quotedMessage\": {\n    \"type\": \"message\",\n    \"message\": {\n     \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n    }\n   },\n   \"metadata\": {\n    \"lang\": \"en-ca\"\n   },\n   \"deleted\": true\n  }\n ],\n \"meta\": {\n  \"hasMore\": false,\n  \"afterCursor\": \"55c8d9758590aa1900b9b9f6\",\n  \"beforeCursor\": \"55c8d9758590aa1900b9b9f6\"\n },\n \"links\": {\n  \"prev\": \"https://api.smooch.io/v2/apps?page[before]=fcafad804c39a39648004af9\",\n  \"next\": \"https://api.smooch.io/v2/apps?page[after]=5ea868f862cdd24abf010b38\"\n }\n}"
    },
    {
      "id": "b77a129c-bc78-489f-9630-1dbd1d0aa6bd",
      "name": "Message not found",
      "originalRequest": {
        "method": "GET",
        "header": [
          {
            "description": {
              "content": "Added as a part of security scheme: bearer",
              "type": "text/plain"
            },
            "key": "Authorization",
            "value": "Bearer <token>"
          }
        ],
        "url": {
          "raw": "{{baseUrl}}/v2/apps/:appId/conversations/:conversationId/messages?page[after]=5e1606762556d93e9c176f69&page[before]=5e1606762556d93e9c176f69&page[size]=10",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "v2",
            "apps",
            ":appId",
            "conversations",
            ":conversationId",
            "messages"
          ],
          "query": [
            {
              "key": "page[after]",
              "value": "5e1606762556d93e9c176f69"
            },
            {
              "key": "page[before]",
              "value": "5e1606762556d93e9c176f69"
            },
            {
              "key": "page[size]",
              "value": "10"
            }
          ],
          "variable": [
            {
              "key": "appId"
            },
            {
              "key": "conversationId"
            }
          ]
        }
      },
      "status": "Not Found",
      "code": 404,
      "_postman_previewlanguage": "text",
      "header": [
        {
          "key": "Content-Type",
          "value": "text/plain"
        }
      ],
      "cookie": [
      ],
      "body": ""
    }
  ]
}