Chilkat Online Tools

Foxpro / Squadcast API V3 / Get All Users

Back to Collection Items

LOCAL loHttp
LOCAL lnSuccess
LOCAL loSbResponseBody
LOCAL loJResp
LOCAL lnRespStatusCode
LOCAL lcId
LOCAL lcFirst_name
LOCAL lcLast_name
LOCAL lcEmail
LOCAL lcDial_code
LOCAL lcPhone_number
LOCAL lnEmail_verified
LOCAL lcTime_zone
LOCAL lcTitle
LOCAL lcBio
LOCAL lnUser_image
LOCAL lcRole_id
LOCAL lcRole
LOCAL lcSecondary_emails
LOCAL j
LOCAL lnCount_j
LOCAL lcV_type
LOCAL lnTime
LOCAL i
LOCAL lnCount_i

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

loHttp = CreateObject('Chilkat_9_5_0.Http')

loHttp.SetRequestHeader("Authorization","")

loSbResponseBody = CreateObject('Chilkat_9_5_0.StringBuilder')
lnSuccess = loHttp.QuickGetSb("https://api.squadcast.com/v3/users",loSbResponseBody)
IF (lnSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loSbResponseBody
    CANCEL
ENDIF

loJResp = CreateObject('Chilkat_9_5_0.JsonObject')
loJResp.LoadSb(loSbResponseBody)
loJResp.EmitCompact = 0

? "Response Body:"
? loJResp.Emit()

lnRespStatusCode = loHttp.LastStatus
? "Response Status Code = " + STR(lnRespStatusCode)
IF (lnRespStatusCode >= 400) THEN
    ? "Response Header:"
    ? loHttp.LastHeader
    ? "Failed."
    RELEASE loHttp
    RELEASE loSbResponseBody
    RELEASE loJResp
    CANCEL
ENDIF

* 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

i = 0
lnCount_i = loJResp.SizeOfArray("data")
DO WHILE i < lnCount_i
    loJResp.I = i
    lcId = loJResp.StringOf("data[i].id")
    lcFirst_name = loJResp.StringOf("data[i].first_name")
    lcLast_name = loJResp.StringOf("data[i].last_name")
    lcEmail = loJResp.StringOf("data[i].email")
    lcDial_code = loJResp.StringOf("data[i].contact.dial_code")
    lcPhone_number = loJResp.StringOf("data[i].contact.phone_number")
    lnEmail_verified = loJResp.BoolOf("data[i].email_verified")
    lcTime_zone = loJResp.StringOf("data[i].time_zone")
    lcTitle = loJResp.StringOf("data[i].title")
    lcBio = loJResp.StringOf("data[i].bio")
    lnUser_image = loJResp.BoolOf("data[i].user_image")
    lcRole_id = loJResp.StringOf("data[i].role_id")
    lcRole = loJResp.StringOf("data[i].role")
    lcSecondary_emails = loJResp.StringOf("data[i].secondary_emails")
    j = 0
    lnCount_j = loJResp.SizeOfArray("data[i].secondary_emails")
    DO WHILE j < lnCount_j
        loJResp.J = j
        j = j + 1
    ENDDO
    j = 0
    lnCount_j = loJResp.SizeOfArray("data[i].notification_rules")
    DO WHILE j < lnCount_j
        loJResp.J = j
        lcV_type = loJResp.StringOf("data[i].notification_rules[j].type")
        lnTime = loJResp.IntOf("data[i].notification_rules[j].time")
        j = j + 1
    ENDDO
    i = i + 1
ENDDO

RELEASE loHttp
RELEASE loSbResponseBody
RELEASE loJResp

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}"
    }
  ]
}