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","{{authorization-token}}"
Dim sbResponseBody As New ChilkatStringBuilder
success = http.QuickGetSb("https://domain.com/crm/v2.1/org",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)
' {
' "org": [
' {
' "country": null,
' "hierarchy_preferences": {
' "type": "Role_Hierarchy"
' },
' "photo_id": null,
' "city": null,
' "description": null,
' "mc_status": true,
' "gapps_enabled": false,
' "domain_name": "org60036018",
' "translation_enabled": true,
' "street": null,
' "alias": null,
' "currency": "Indian Rupee",
' "id": "738964000000300043",
' "state": null,
' "fax": null,
' "employee_count": null,
' "zip": null,
' "website": null,
' "currency_symbol": "₹",
' "mobile": null,
' "currency_locale": "en_IN",
' "primary_zuid": "60034346",
' "zia_portal_id": null,
' "time_zone": "Asia/Kolkata",
' "zgid": "60036018",
' "country_code": "IN",
' "license_details": {
' "paid_expiry": "2021-10-20T00:00:00+00:00",
' "users_license_purchased": 25,
' "trial_type": null,
' "trial_expiry": null,
' "paid": true,
' "paid_type": "enterprise"
' },
' "phone": "312",
' "company_name": "Zylker",
' "privacy_settings": false,
' "primary_email": "patricia@zohocorp.com",
' "iso_code": "INR"
' }
' ]
' }
' Sample code for parsing the JSON response...
' Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
Dim country As String
Dim v_Type As String
Dim photo_id As String
Dim city As String
Dim description As String
Dim mc_status As Long
Dim gapps_enabled As Long
Dim domain_name As String
Dim translation_enabled As Long
Dim street As String
Dim alias As String
Dim v_currency As String
Dim id As String
Dim state As String
Dim fax As String
Dim employee_count As String
Dim zip As String
Dim website As String
Dim currency_symbol As String
Dim mobile As String
Dim currency_locale As String
Dim primary_zuid As String
Dim zia_portal_id As String
Dim time_zone As String
Dim zgid As String
Dim country_code As String
Dim Paid_expiry As String
Dim Users_license_purchased As Long
Dim Trial_type As String
Dim Trial_expiry As String
Dim Paid As Long
Dim Paid_type As String
Dim phone As String
Dim company_name As String
Dim privacy_settings As Long
Dim primary_email As String
Dim iso_code As String
Dim i As Long
i = 0
Dim count_i As Long
count_i = jResp.SizeOfArray("org")
Do While i < count_i
jResp.I = i
country = jResp.StringOf("org[i].country")
v_Type = jResp.StringOf("org[i].hierarchy_preferences.type")
photo_id = jResp.StringOf("org[i].photo_id")
city = jResp.StringOf("org[i].city")
description = jResp.StringOf("org[i].description")
mc_status = jResp.BoolOf("org[i].mc_status")
gapps_enabled = jResp.BoolOf("org[i].gapps_enabled")
domain_name = jResp.StringOf("org[i].domain_name")
translation_enabled = jResp.BoolOf("org[i].translation_enabled")
street = jResp.StringOf("org[i].street")
alias = jResp.StringOf("org[i].alias")
v_currency = jResp.StringOf("org[i].currency")
id = jResp.StringOf("org[i].id")
state = jResp.StringOf("org[i].state")
fax = jResp.StringOf("org[i].fax")
employee_count = jResp.StringOf("org[i].employee_count")
zip = jResp.StringOf("org[i].zip")
website = jResp.StringOf("org[i].website")
currency_symbol = jResp.StringOf("org[i].currency_symbol")
mobile = jResp.StringOf("org[i].mobile")
currency_locale = jResp.StringOf("org[i].currency_locale")
primary_zuid = jResp.StringOf("org[i].primary_zuid")
zia_portal_id = jResp.StringOf("org[i].zia_portal_id")
time_zone = jResp.StringOf("org[i].time_zone")
zgid = jResp.StringOf("org[i].zgid")
country_code = jResp.StringOf("org[i].country_code")
Paid_expiry = jResp.StringOf("org[i].license_details.paid_expiry")
Users_license_purchased = jResp.IntOf("org[i].license_details.users_license_purchased")
Trial_type = jResp.StringOf("org[i].license_details.trial_type")
Trial_expiry = jResp.StringOf("org[i].license_details.trial_expiry")
Paid = jResp.BoolOf("org[i].license_details.paid")
Paid_type = jResp.StringOf("org[i].license_details.paid_type")
phone = jResp.StringOf("org[i].phone")
company_name = jResp.StringOf("org[i].company_name")
privacy_settings = jResp.BoolOf("org[i].privacy_settings")
primary_email = jResp.StringOf("org[i].primary_email")
iso_code = jResp.StringOf("org[i].iso_code")
i = i + 1
Loop
Curl Command
curl -X GET
-H "Authorization: Bearer <access_token>"
-H "Authorization: {{authorization-token}}"
https://domain.com/crm/v2.1/org
Postman Collection Item JSON
{
"name": "Organization Details",
"request": {
"auth": {
"type": "bearer",
"bearer": [
{
"key": "token",
"value": "{{access-token}}",
"type": "string"
}
]
},
"method": "GET",
"header": [
{
"key": "Authorization",
"value": "{{authorization-token}}"
}
],
"url": {
"raw": "{{api-domain}}/crm/v2.1/org",
"host": [
"{{api-domain}}"
],
"path": [
"crm",
"v2.1",
"org"
]
},
"description": "To get the organization data."
},
"response": [
{
"name": "SUCCESS RESPONSE",
"originalRequest": {
"method": "GET",
"header": [
{
"key": "Authorization",
"value": "{{authorization-token}}"
}
],
"url": {
"raw": "{{api-domain}}/crm/v2.1/org",
"host": [
"{{api-domain}}"
],
"path": [
"crm",
"v2.1",
"org"
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Server",
"value": "ZGS"
},
{
"key": "Date",
"value": "Tue, 04 May 2021 13:41:05 GMT"
},
{
"key": "Content-Type",
"value": "application/json;charset=utf-8"
},
{
"key": "Content-Length",
"value": "847"
},
{
"key": "Connection",
"value": "keep-alive"
},
{
"key": "Referrer-Policy",
"value": "strict-origin"
},
{
"key": "X-Content-Type-Options",
"value": "nosniff"
},
{
"key": "X-XSS-Protection",
"value": "1; mode=block"
},
{
"key": "Pragma",
"value": "no-cache"
},
{
"key": "Cache-Control",
"value": "no-cache"
},
{
"key": "Expires",
"value": "Thu, 01 Jan 1970 00:00:00 GMT"
},
{
"key": "X-Frame-Options",
"value": "SAMEORIGIN"
},
{
"key": "X-ACCESSTOKEN-RESET",
"value": "2021-05-04T14:40:46+00:00"
},
{
"key": "clientVersion",
"value": "4004813"
},
{
"key": "clientsubVersion",
"value": "fb33599b767b94d06d2bd2529079b386"
},
{
"key": "Content-Disposition",
"value": "attachment; filename=response.json"
},
{
"key": "Content-Language",
"value": "en-US"
},
{
"key": "Strict-Transport-Security",
"value": "max-age=15768000"
}
],
"cookie": [
],
"body": "{\n \"org\": [\n {\n \"country\": null,\n \"hierarchy_preferences\": {\n \"type\": \"Role_Hierarchy\"\n },\n \"photo_id\": null,\n \"city\": null,\n \"description\": null,\n \"mc_status\": true,\n \"gapps_enabled\": false,\n \"domain_name\": \"org60036018\",\n \"translation_enabled\": true,\n \"street\": null,\n \"alias\": null,\n \"currency\": \"Indian Rupee\",\n \"id\": \"738964000000300043\",\n \"state\": null,\n \"fax\": null,\n \"employee_count\": null,\n \"zip\": null,\n \"website\": null,\n \"currency_symbol\": \"₹\",\n \"mobile\": null,\n \"currency_locale\": \"en_IN\",\n \"primary_zuid\": \"60034346\",\n \"zia_portal_id\": null,\n \"time_zone\": \"Asia/Kolkata\",\n \"zgid\": \"60036018\",\n \"country_code\": \"IN\",\n \"license_details\": {\n \"paid_expiry\": \"2021-10-20T00:00:00+00:00\",\n \"users_license_purchased\": 25,\n \"trial_type\": null,\n \"trial_expiry\": null,\n \"paid\": true,\n \"paid_type\": \"enterprise\"\n },\n \"phone\": \"312\",\n \"company_name\": \"Zylker\",\n \"privacy_settings\": false,\n \"primary_email\": \"patricia@zohocorp.com\",\n \"iso_code\": \"INR\"\n }\n ]\n}"
},
{
"name": "AUTHENTICATION_FAILURE",
"originalRequest": {
"method": "GET",
"header": [
{
"key": "Authorization",
"value": "{{authorization-token}}"
}
],
"url": {
"raw": "{{api-domain}}/crm/v2.1/org",
"host": [
"{{api-domain}}"
],
"path": [
"crm",
"v2.1",
"org"
]
}
},
"status": "Unauthorized",
"code": 401,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Server",
"value": "ZGS"
},
{
"key": "Date",
"value": "Tue, 04 May 2021 12:36:48 GMT"
},
{
"key": "Content-Type",
"value": "application/json;charset=utf-8"
},
{
"key": "Content-Length",
"value": "98"
},
{
"key": "Connection",
"value": "keep-alive"
},
{
"key": "Referrer-Policy",
"value": "strict-origin"
},
{
"key": "X-Content-Type-Options",
"value": "nosniff"
},
{
"key": "X-XSS-Protection",
"value": "1; mode=block"
},
{
"key": "Pragma",
"value": "no-cache"
},
{
"key": "Cache-Control",
"value": "no-cache"
},
{
"key": "Expires",
"value": "Thu, 01 Jan 1970 00:00:00 GMT"
},
{
"key": "X-Frame-Options",
"value": "SAMEORIGIN"
},
{
"key": "X-Download-Options",
"value": "noopen"
}
],
"cookie": [
],
"body": "{\n \"code\": \"AUTHENTICATION_FAILURE\",\n \"details\": {},\n \"message\": \"Authentication failed\",\n \"status\": \"error\"\n}"
},
{
"name": "OAUTH_SCOPE_MISMATCH",
"originalRequest": {
"method": "GET",
"header": [
{
"key": "Authorization",
"value": "{{authorization-token}}"
}
],
"url": {
"raw": "{{api-domain}}/crm/v2.1/org",
"host": [
"{{api-domain}}"
],
"path": [
"crm",
"v2.1",
"org"
]
}
},
"status": "Unauthorized",
"code": 401,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Server",
"value": "ZGS"
},
{
"key": "Date",
"value": "Tue, 04 May 2021 13:37:11 GMT"
},
{
"key": "Content-Type",
"value": "application/json;charset=utf-8"
},
{
"key": "Content-Length",
"value": "113"
},
{
"key": "Connection",
"value": "keep-alive"
},
{
"key": "Referrer-Policy",
"value": "strict-origin"
},
{
"key": "X-Content-Type-Options",
"value": "nosniff"
},
{
"key": "X-XSS-Protection",
"value": "1; mode=block"
},
{
"key": "Pragma",
"value": "no-cache"
},
{
"key": "Cache-Control",
"value": "no-cache"
},
{
"key": "Expires",
"value": "Thu, 01 Jan 1970 00:00:00 GMT"
},
{
"key": "X-Frame-Options",
"value": "SAMEORIGIN"
},
{
"key": "X-Download-Options",
"value": "noopen"
}
],
"cookie": [
],
"body": "{\n \"code\": \"OAUTH_SCOPE_MISMATCH\",\n \"details\": {},\n \"message\": \"invalid oauth scope to access this URL\",\n \"status\": \"error\"\n}"
}
]
}
