VBScript
VBScript
List Groups
See more Microsoft Group Examples
List all the groups available in an organization, including but not limited to Office 365 Groups.See https://docs.microsoft.com/en-us/graph/api/group-list?view=graph-rest-1.0 for more information.
Chilkat VBScript Downloads
Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)
success = 0
' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.
set http = CreateObject("Chilkat.Http")
' Use your previously obtained access token as shown here:
' Get Microsoft Graph OAuth2 Access Token with Group.ReadWrite.All scope.
set jsonToken = CreateObject("Chilkat.JsonObject")
success = jsonToken.LoadFile("qa_data/tokens/msGraphGroup.json")
If (success = 0) Then
outFile.WriteLine(jsonToken.LastErrorText)
WScript.Quit
End If
http.AuthToken = jsonToken.StringOf("access_token")
' Send a GET request to https://graph.microsoft.com/v1.0/groups?$orderby=displayName
strResponse = http.QuickGetStr("https://graph.microsoft.com/v1.0/groups?$orderby=displayName")
If (http.LastMethodSuccess = 0) Then
outFile.WriteLine(http.LastErrorText)
WScript.Quit
End If
set json = CreateObject("Chilkat.JsonObject")
success = json.Load(strResponse)
json.EmitCompact = 0
If (http.LastStatus <> 200) Then
outFile.WriteLine(json.Emit())
outFile.WriteLine("Failed, response status code = " & http.LastStatus)
WScript.Quit
End If
outFile.WriteLine(json.Emit())
' Sample output:
' (See parsing code below..)
' {
' "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#groups",
' "value": [
' {
' "id": "45b7d2e7-b882-4a80-ba97-10b7a63b8fa4",
' "deletedDateTime": null,
' "classification": null,
' "createdDateTime": "2018-12-22T02:21:05Z",
' "creationOptions": [],
' "description": "Self help community for golf",
' "displayName": "Golf Assist",
' "groupTypes": [
' "Unified"
' ],
' "mail": "golfassist@contoso.com",
' "mailEnabled": true,
' "mailNickname": "golfassist",
' "onPremisesLastSyncDateTime": null,
' "onPremisesSecurityIdentifier": null,
' "onPremisesSyncEnabled": null,
' "preferredDataLocation": "CAN",
' "proxyAddresses": [
' "smtp:golfassist@contoso.onmicrosoft.com",
' "SMTP:golfassist@contoso.com"
' ],
' "renewedDateTime": "2018-12-22T02:21:05Z",
' "resourceBehaviorOptions": [],
' "resourceProvisioningOptions": [],
' "securityEnabled": false,
' "visibility": "Public",
' "onPremisesProvisioningErrors": []
' },
' {
' "id": "d7797254-3084-44d0-99c9-a3b5ab149538",
' "deletedDateTime": null,
' "classification": null,
' "createdDateTime": "2018-11-19T20:29:40Z",
' "creationOptions": [],
' "description": "Talk about golf",
' "displayName": "Golf Discussion",
' "groupTypes": [],
' "mail": "golftalk@contoso.com",
' "mailEnabled": true,
' "mailNickname": "golftalk",
' "onPremisesLastSyncDateTime": null,
' "onPremisesSecurityIdentifier": null,
' "onPremisesSyncEnabled": null,
' "preferredDataLocation": "CAN",
' "proxyAddresses": [
' "smtp:golftalk@contoso.onmicrosoft.com",
' "SMTP:golftalk@contoso.com"
' ],
' "renewedDateTime": "2018-11-19T20:29:40Z",
' "resourceBehaviorOptions": [],
' "resourceProvisioningOptions": [],
' "securityEnabled": false,
' "visibility": null,
' "onPremisesProvisioningErrors": []
' }
' ]
' }
'
' Use this online tool to generate parsing code from sample JSON:
' Generate Parsing Code from JSON
odataContext = json.StringOf("""@odata.context""")
i = 0
count_i = json.SizeOfArray("value")
Do While i < count_i
json.I = i
id = json.StringOf("value[i].id")
deletedDateTime = json.StringOf("value[i].deletedDateTime")
classification = json.StringOf("value[i].classification")
createdDateTime = json.StringOf("value[i].createdDateTime")
description = json.StringOf("value[i].description")
displayName = json.StringOf("value[i].displayName")
mail = json.StringOf("value[i].mail")
mailEnabled = json.BoolOf("value[i].mailEnabled")
mailNickname = json.StringOf("value[i].mailNickname")
onPremisesLastSyncDateTime = json.StringOf("value[i].onPremisesLastSyncDateTime")
onPremisesSecurityIdentifier = json.StringOf("value[i].onPremisesSecurityIdentifier")
onPremisesSyncEnabled = json.StringOf("value[i].onPremisesSyncEnabled")
preferredDataLocation = json.StringOf("value[i].preferredDataLocation")
renewedDateTime = json.StringOf("value[i].renewedDateTime")
securityEnabled = json.BoolOf("value[i].securityEnabled")
visibility = json.StringOf("value[i].visibility")
j = 0
count_j = json.SizeOfArray("value[i].creationOptions")
Do While j < count_j
json.J = j
' ...
j = j + 1
Loop
j = 0
count_j = json.SizeOfArray("value[i].groupTypes")
Do While j < count_j
json.J = j
strVal = json.StringOf("value[i].groupTypes[j]")
j = j + 1
Loop
j = 0
count_j = json.SizeOfArray("value[i].proxyAddresses")
Do While j < count_j
json.J = j
strVal = json.StringOf("value[i].proxyAddresses[j]")
j = j + 1
Loop
j = 0
count_j = json.SizeOfArray("value[i].resourceBehaviorOptions")
Do While j < count_j
json.J = j
' ...
j = j + 1
Loop
j = 0
count_j = json.SizeOfArray("value[i].resourceProvisioningOptions")
Do While j < count_j
json.J = j
' ...
j = j + 1
Loop
j = 0
count_j = json.SizeOfArray("value[i].onPremisesProvisioningErrors")
Do While j < count_j
json.J = j
' ...
j = j + 1
Loop
i = i + 1
Loop
outFile.WriteLine("Success.")
outFile.Close