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.SetRequestHeader "Authorization",""
Dim sbResponseBody As New ChilkatStringBuilder
success = http.QuickGetSb("https://api.squadcast.com/v3/users",sbResponseBody)
If (success = 0) Then
Debug.Print http.LastErrorText
Exit Sub
End If
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 = http.LastStatus
Debug.Print "Response Status Code = " & respStatusCode
If (respStatusCode >= 400) Then
Debug.Print "Response Header:"
Debug.Print http.LastHeader
Debug.Print "Failed."
Exit Sub
End If
' Sample JSON response:
' (Sample code for parsing the JSON response is shown below)
' {
' "data": [
' {
' "id": "5d81d9187000fb6b9def7e31",
' "first_name": "Manigandan",
' "last_name": "Dharmalingam",
' "email": "manigandan@squadcast.com",
' "contact": {
' "dial_code": "+91",
' "phone_number": "9578628779"
' },
' "secondary_emails": [
' ],
' "email_verified": true,
' "time_zone": "Asia/Calcutta",
' "title": "",
' "bio": "",
' "notification_rules": [
' {
' "type": "Email",
' "time": 0
' },
' {
' "type": "Push",
' "time": 0
' },
' {
' "type": "SMS",
' "time": 1
' },
' {
' "type": "Phone",
' "time": 2
' }
' ],
' "user_image": false,
' "role_id": "5a425b383c36823b3ed91fb4",
' "role": "account_owner"
' },
' {
' "id": "5d91d262a2c85fa24a27d4d7",
' "first_name": "Akilan",
' "last_name": "Elango",
' "email": "akilan@squadcast.com",
' "contact": {
' "dial_code": "",
' "phone_number": ""
' },
' "secondary_emails": null,
' "email_verified": false,
' "time_zone": "",
' "title": "",
' "bio": "",
' "notification_rules": [
' {
' "type": "Email",
' "time": 0
' },
' {
' "type": "Push",
' "time": 0
' },
' {
' "type": "SMS",
' "time": 1
' },
' {
' "type": "Phone",
' "time": 2
' }
' ],
' "user_image": false,
' "role_id": "5a425b383c36823b3ed91fb5",
' "role": "admin"
' },
' {
' "id": "5d91d262a2c85fa24a27d4da",
' "first_name": "Madhu",
' "last_name": "DS Frontend",
' "email": "madhu@squadcast.com",
' "contact": {
' "dial_code": "",
' "phone_number": ""
' },
' "secondary_emails": null,
' "email_verified": false,
' "time_zone": "",
' "title": "",
' "bio": "",
' "notification_rules": [
' {
' "type": "Email",
' "time": 0
' },
' {
' "type": "Push",
' "time": 0
' },
' {
' "type": "SMS",
' "time": 1
' },
' {
' "type": "Phone",
' "time": 2
' }
' ],
' "user_image": false,
' "role_id": "5a425b383c36823b3ed91fb6",
' "role": "user"
' }
' ]
' }
' 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 first_name As String
Dim last_name As String
Dim email As String
Dim Dial_code As String
Dim Phone_number As String
Dim email_verified As Long
Dim time_zone As String
Dim title As String
Dim bio As String
Dim user_image As Long
Dim role_id As String
Dim role As String
Dim secondary_emails As String
Dim j As Long
Dim count_j As Long
Dim v_type As String
Dim time As Long
Dim i As Long
i = 0
Dim count_i As Long
count_i = jResp.SizeOfArray("data")
Do While i < count_i
jResp.I = i
id = jResp.StringOf("data[i].id")
first_name = jResp.StringOf("data[i].first_name")
last_name = jResp.StringOf("data[i].last_name")
email = jResp.StringOf("data[i].email")
Dial_code = jResp.StringOf("data[i].contact.dial_code")
Phone_number = jResp.StringOf("data[i].contact.phone_number")
email_verified = jResp.BoolOf("data[i].email_verified")
time_zone = jResp.StringOf("data[i].time_zone")
title = jResp.StringOf("data[i].title")
bio = jResp.StringOf("data[i].bio")
user_image = jResp.BoolOf("data[i].user_image")
role_id = jResp.StringOf("data[i].role_id")
role = jResp.StringOf("data[i].role")
secondary_emails = jResp.StringOf("data[i].secondary_emails")
j = 0
count_j = jResp.SizeOfArray("data[i].secondary_emails")
Do While j < count_j
jResp.J = j
j = j + 1
Loop
j = 0
count_j = jResp.SizeOfArray("data[i].notification_rules")
Do While j < count_j
jResp.J = j
v_type = jResp.StringOf("data[i].notification_rules[j].type")
time = jResp.IntOf("data[i].notification_rules[j].time")
j = j + 1
Loop
i = i + 1
Loop
Curl Command
curl -X GET
-H "Authorization: "
https://api.squadcast.com/v3/users
Postman Collection Item JSON
{
"name": "Get All Users",
"request": {
"auth": {
"type": "noauth"
},
"method": "GET",
"header": [
{
"key": "Authorization",
"value": ""
}
],
"url": {
"raw": "{{baseUrl}}/users",
"host": [
"{{baseUrl}}"
],
"path": [
"users"
]
},
"description": "Returns all the users of the organization.\nRequires `access_token` as a `Bearer {{token}}` in the `Authorization` header with `read` scope.\n "
},
"response": [
{
"name": "Forbidden",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{baseUrl}}/users",
"host": [
"{{baseUrl}}"
],
"path": [
"users"
]
}
},
"status": "Forbidden",
"code": 403,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"meta\": {\n \"status\": \"<integer>\",\n \"error_message\": \"<string>\"\n }\n}"
},
{
"name": "Internal Server Error",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{baseUrl}}/users",
"host": [
"{{baseUrl}}"
],
"path": [
"users"
]
}
},
"status": "Internal Server Error",
"code": 500,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"meta\": {\n \"status\": \"<integer>\",\n \"error_message\": \"<string>\"\n }\n}"
},
{
"name": "OK",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{baseUrl}}/users",
"host": [
"{{baseUrl}}"
],
"path": [
"users"
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"data\": [\n {\n \"id\": \"5d81d9187000fb6b9def7e31\",\n \"first_name\": \"Manigandan\",\n \"last_name\": \"Dharmalingam\",\n \"email\": \"manigandan@squadcast.com\",\n \"contact\": {\n \"dial_code\": \"+91\",\n \"phone_number\": \"9578628779\"\n },\n \"secondary_emails\": [],\n \"email_verified\": true,\n \"time_zone\": \"Asia/Calcutta\",\n \"title\": \"\",\n \"bio\": \"\",\n \"notification_rules\": [\n {\n \"type\": \"Email\",\n \"time\": 0\n },\n {\n \"type\": \"Push\",\n \"time\": 0\n },\n {\n \"type\": \"SMS\",\n \"time\": 1\n },\n {\n \"type\": \"Phone\",\n \"time\": 2\n }\n ],\n \"user_image\": false,\n \"role_id\": \"5a425b383c36823b3ed91fb4\",\n \"role\": \"account_owner\"\n },\n {\n \"id\": \"5d91d262a2c85fa24a27d4d7\",\n \"first_name\": \"Akilan\",\n \"last_name\": \"Elango\",\n \"email\": \"akilan@squadcast.com\",\n \"contact\": {\n \"dial_code\": \"\",\n \"phone_number\": \"\"\n },\n \"secondary_emails\": null,\n \"email_verified\": false,\n \"time_zone\": \"\",\n \"title\": \"\",\n \"bio\": \"\",\n \"notification_rules\": [\n {\n \"type\": \"Email\",\n \"time\": 0\n },\n {\n \"type\": \"Push\",\n \"time\": 0\n },\n {\n \"type\": \"SMS\",\n \"time\": 1\n },\n {\n \"type\": \"Phone\",\n \"time\": 2\n }\n ],\n \"user_image\": false,\n \"role_id\": \"5a425b383c36823b3ed91fb5\",\n \"role\": \"admin\"\n },\n {\n \"id\": \"5d91d262a2c85fa24a27d4da\",\n \"first_name\": \"Madhu\",\n \"last_name\": \"DS Frontend\",\n \"email\": \"madhu@squadcast.com\",\n \"contact\": {\n \"dial_code\": \"\",\n \"phone_number\": \"\"\n },\n \"secondary_emails\": null,\n \"email_verified\": false,\n \"time_zone\": \"\",\n \"title\": \"\",\n \"bio\": \"\",\n \"notification_rules\": [\n {\n \"type\": \"Email\",\n \"time\": 0\n },\n {\n \"type\": \"Push\",\n \"time\": 0\n },\n {\n \"type\": \"SMS\",\n \"time\": 1\n },\n {\n \"type\": \"Phone\",\n \"time\": 2\n }\n ],\n \"user_image\": false,\n \"role_id\": \"5a425b383c36823b3ed91fb6\",\n \"role\": \"user\"\n }\n ]\n}"
},
{
"name": "Unauthorized",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "{{baseUrl}}/users",
"host": [
"{{baseUrl}}"
],
"path": [
"users"
]
}
},
"status": "Unauthorized",
"code": 401,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"meta\": {\n \"status\": \"<integer>\",\n \"error_message\": \"<string>\"\n }\n}"
}
]
}
