(Visual FoxPro) SharePoint Get Site ID

See more SharePoint Examples

Note: This example requires Chilkat v11.0.0 or greater.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

LOCAL lnSuccess
LOCAL loHttp
LOCAL loJsonOAuthCC
LOCAL loSbJson
LOCAL lnStatusCode
LOCAL loJsonResp

lnSuccess = 0

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

loHttp = CreateObject('Chilkat.Http')

* Provide the information needed for Chilkat to automatically fetch the OAuth2.0 
* access token as needed.
loJsonOAuthCC = CreateObject('Chilkat.JsonObject')

* --------------------------------------------------------------------------------------------------------
* You'll need to have registered an app in Azure beforehand.
* See How to Create SharePoint App Registration for OAuth 2.0 Client Credentials
* --------------------------------------------------------------------------------------------------------

* Use the values from your App Registration in Azure.
loJsonOAuthCC.UpdateString("client_id","CLIENT_ID")
loJsonOAuthCC.UpdateString("client_secret","SECRET_VALUE")

* You'll always use this scope for client credentials, because the allowed actions
* are determined by the App Permissions defined when you registered the app in Azure.
loJsonOAuthCC.UpdateString("scope","https://graph.microsoft.com/.default")

* The token endpoint includes your tenant ID. 
loJsonOAuthCC.UpdateString("token_endpoint","https://login.microsoftonline.com/TENANT_ID/oauth2/v2.0/token")

* Provide the OAuth2 information. Chilkat will use this information to automatically fetch the OAuth2 access token as needed,
loHttp.AuthToken = loJsonOAuthCC.Emit()

* Get information about the SharePoint site named "test"
loSbJson = CreateObject('Chilkat.StringBuilder')
loHttp.SetUrlVar("sharepoint_hostname","example.sharepoint.com")
loHttp.SetUrlVar("site_name","test")
lnSuccess = loHttp.QuickGetSb("https://graph.microsoft.com/v1.0/sites/{$sharepoint_hostname}:/sites/{$site_name}",loSbJson)
IF (lnSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loJsonOAuthCC
    RELEASE loSbJson
    CANCEL
ENDIF

lnStatusCode = loHttp.LastStatus

? "Response status code = " + STR(lnStatusCode)

IF (lnStatusCode <> 200) THEN
    ? loSbJson.GetAsString()
    ? "Failed."
    RELEASE loHttp
    RELEASE loJsonOAuthCC
    RELEASE loSbJson
    CANCEL
ENDIF

loJsonResp = CreateObject('Chilkat.JsonObject')
loJsonResp.LoadSb(loSbJson)
loJsonResp.EmitCompact = 0

? loJsonResp.Emit()
? ""
? "ID: " + loJsonResp.StringOf("id")
? "Success."

* Use this online tool to generate parsing code from sample JSON: 
* Generate Parsing Code from JSON

RELEASE loHttp
RELEASE loJsonOAuthCC
RELEASE loSbJson
RELEASE loJsonResp