Chilkat Online Tools

Foxpro / Zoho CRM REST APIs / Organization Details

Back to Collection Items

LOCAL loHttp
LOCAL lnSuccess
LOCAL loSbResponseBody
LOCAL loJResp
LOCAL lnRespStatusCode
LOCAL lcCountry
LOCAL lcPhoto_id
LOCAL lcCity
LOCAL lcDescription
LOCAL lnMc_status
LOCAL lnGapps_enabled
LOCAL lcDomain_name
LOCAL lnTranslation_enabled
LOCAL lcStreet
LOCAL lcAlias
LOCAL lcV_currency
LOCAL lcId
LOCAL lcState
LOCAL lcFax
LOCAL lcEmployee_count
LOCAL lcZip
LOCAL lcWebsite
LOCAL lcCurrency_symbol
LOCAL lcMobile
LOCAL lcCurrency_locale
LOCAL lcPrimary_zuid
LOCAL lcZia_portal_id
LOCAL lcTime_zone
LOCAL lcZgid
LOCAL lcCountry_code
LOCAL lcPaid_expiry
LOCAL lnUsers_license_purchased
LOCAL lcTrial_type
LOCAL lcTrial_expiry
LOCAL lnPaid
LOCAL lcPaid_type
LOCAL lcPhone
LOCAL lcCompany_name
LOCAL lnPrivacy_settings
LOCAL lcPrimary_email
LOCAL lcIso_code
LOCAL i
LOCAL lnCount_i

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

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Http')
loHttp = CreateObject('Chilkat.Http')

loHttp.SetRequestHeader("Authorization","{{authorization-token}}")

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.StringBuilder')
loSbResponseBody = CreateObject('Chilkat.StringBuilder')
lnSuccess = loHttp.QuickGetSb("https://domain.com/crm/v2/org",loSbResponseBody)
IF (lnSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loSbResponseBody
    CANCEL
ENDIF

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJResp = CreateObject('Chilkat.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)

* {
*   "org": [
*     {
*       "country": null,
*       "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": true,
*       "primary_email": "patricia@zylker.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

i = 0
lnCount_i = loJResp.SizeOfArray("org")
DO WHILE i < lnCount_i
    loJResp.I = i
    lcCountry = loJResp.StringOf("org[i].country")
    lcPhoto_id = loJResp.StringOf("org[i].photo_id")
    lcCity = loJResp.StringOf("org[i].city")
    lcDescription = loJResp.StringOf("org[i].description")
    lnMc_status = loJResp.BoolOf("org[i].mc_status")
    lnGapps_enabled = loJResp.BoolOf("org[i].gapps_enabled")
    lcDomain_name = loJResp.StringOf("org[i].domain_name")
    lnTranslation_enabled = loJResp.BoolOf("org[i].translation_enabled")
    lcStreet = loJResp.StringOf("org[i].street")
    lcAlias = loJResp.StringOf("org[i].alias")
    lcV_currency = loJResp.StringOf("org[i].currency")
    lcId = loJResp.StringOf("org[i].id")
    lcState = loJResp.StringOf("org[i].state")
    lcFax = loJResp.StringOf("org[i].fax")
    lcEmployee_count = loJResp.StringOf("org[i].employee_count")
    lcZip = loJResp.StringOf("org[i].zip")
    lcWebsite = loJResp.StringOf("org[i].website")
    lcCurrency_symbol = loJResp.StringOf("org[i].currency_symbol")
    lcMobile = loJResp.StringOf("org[i].mobile")
    lcCurrency_locale = loJResp.StringOf("org[i].currency_locale")
    lcPrimary_zuid = loJResp.StringOf("org[i].primary_zuid")
    lcZia_portal_id = loJResp.StringOf("org[i].zia_portal_id")
    lcTime_zone = loJResp.StringOf("org[i].time_zone")
    lcZgid = loJResp.StringOf("org[i].zgid")
    lcCountry_code = loJResp.StringOf("org[i].country_code")
    lcPaid_expiry = loJResp.StringOf("org[i].license_details.paid_expiry")
    lnUsers_license_purchased = loJResp.IntOf("org[i].license_details.users_license_purchased")
    lcTrial_type = loJResp.StringOf("org[i].license_details.trial_type")
    lcTrial_expiry = loJResp.StringOf("org[i].license_details.trial_expiry")
    lnPaid = loJResp.BoolOf("org[i].license_details.paid")
    lcPaid_type = loJResp.StringOf("org[i].license_details.paid_type")
    lcPhone = loJResp.StringOf("org[i].phone")
    lcCompany_name = loJResp.StringOf("org[i].company_name")
    lnPrivacy_settings = loJResp.BoolOf("org[i].privacy_settings")
    lcPrimary_email = loJResp.StringOf("org[i].primary_email")
    lcIso_code = loJResp.StringOf("org[i].iso_code")
    i = i + 1
ENDDO

RELEASE loHttp
RELEASE loSbResponseBody
RELEASE loJResp

Curl Command

curl -X GET
	-H "Authorization: Bearer <access_token>"
	-H "Authorization: {{authorization-token}}"
https://domain.com/crm/v2/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/org",
      "host": [
        "{{api-domain}}"
      ],
      "path": [
        "crm",
        "v2",
        "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/org",
          "host": [
            "{{api-domain}}"
          ],
          "path": [
            "crm",
            "v2",
            "org"
          ]
        }
      },
      "status": "OK",
      "code": 200,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Server",
          "value": "ZGS"
        },
        {
          "key": "Date",
          "value": "Tue, 11 May 2021 10:49:49 GMT"
        },
        {
          "key": "Content-Type",
          "value": "application/json;charset=utf-8"
        },
        {
          "key": "Content-Length",
          "value": "796"
        },
        {
          "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-store, no-cache, must-revalidate, private"
        },
        {
          "key": "Expires",
          "value": "Thu, 01 Jan 1970 00:00:00 GMT"
        },
        {
          "key": "X-Frame-Options",
          "value": "SAMEORIGIN"
        },
        {
          "key": "X-ACCESSTOKEN-RESET",
          "value": "2021-05-11T11:08:26+00:00"
        },
        {
          "key": "clientVersion",
          "value": "4023320"
        },
        {
          "key": "clientsubVersion",
          "value": "4d8b6ee4f7d1d284c930a4e807480c5c"
        },
        {
          "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            \"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\": true,\n            \"primary_email\": \"patricia@zylker.com\",\n            \"iso_code\": \"INR\"\n        }\n    ]\n}"
    },
    {
      "name": "INVALID_REQUEST_METHOD",
      "originalRequest": {
        "method": "COPY",
        "header": [
          {
            "key": "Authorization",
            "value": "{{authorization-token}}"
          }
        ],
        "url": {
          "raw": "{{api-domain}}/crm/v2/org",
          "host": [
            "{{api-domain}}"
          ],
          "path": [
            "crm",
            "v2",
            "org"
          ]
        }
      },
      "status": "Bad Request",
      "code": 400,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Server",
          "value": "ZGS"
        },
        {
          "key": "Date",
          "value": "Tue, 11 May 2021 10:50:28 GMT"
        },
        {
          "key": "Content-Type",
          "value": "application/json;charset=utf-8"
        },
        {
          "key": "Content-Length",
          "value": "124"
        },
        {
          "key": "Connection",
          "value": "keep-alive"
        },
        {
          "key": "X-Frame-Options",
          "value": "deny"
        },
        {
          "key": "X-Download-Options",
          "value": "noopen"
        },
        {
          "key": "X-Content-Type-Options",
          "value": "nosniff"
        }
      ],
      "cookie": [
      ],
      "body": "{\n    \"code\": \"INVALID_REQUEST_METHOD\",\n    \"details\": {},\n    \"message\": \"The http request method type is not a valid one\",\n    \"status\": \"error\"\n}"
    },
    {
      "name": "AUTHENTICATION_FAILURE",
      "originalRequest": {
        "method": "GET",
        "header": [
          {
            "key": "Authorization",
            "value": "{{authorization-token}}"
          }
        ],
        "url": {
          "raw": "{{api-domain}}/crm/v2/org",
          "host": [
            "{{api-domain}}"
          ],
          "path": [
            "crm",
            "v2",
            "org"
          ]
        }
      },
      "status": "Unauthorized",
      "code": 401,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Server",
          "value": "ZGS"
        },
        {
          "key": "Date",
          "value": "Tue, 11 May 2021 10:52:27 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/org",
          "host": [
            "{{api-domain}}"
          ],
          "path": [
            "crm",
            "v2",
            "org"
          ]
        }
      },
      "status": "Unauthorized",
      "code": 401,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Server",
          "value": "ZGS"
        },
        {
          "key": "Date",
          "value": "Thu, 13 May 2021 06:31:49 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}"
    }
  ]
}