(Excel) Create Group

Create a new group as specified in the request body. You can create one of three types of groups:

• Office 365 Group (unified group)
• Dynamic group
• Security group

This operation returns by default only a subset of the properties for each group. These default properties are noted in the Properties section.

See https://docs.microsoft.com/en-us/graph/api/group-post-groups?view=graph-rest-1.0 for more information.

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' Use your previously obtained access token as shown here:
'    Get Microsoft Graph OAuth2 Access Token with Group.ReadWrite.All scope.

Dim jsonToken As Chilkat.JsonObject
Set jsonToken = Chilkat.NewJsonObject

success = jsonToken.LoadFile("qa_data/tokens/msGraphGroup.json")
If (success = False) Then
    Debug.Print jsonToken.LastErrorText
    Exit Sub
End If

http.AuthToken = jsonToken.StringOf("access_token")

' Create a JSON body for the HTTP POST
' Use this online tool to generate the code from sample JSON: 
' Generate Code to Create JSON

' {
'   "description": "Self help community for library",
'   "displayName": "Library Assist",
'   "groupTypes": [
'     "Unified"
'   ],
'   "mailEnabled": true,
'   "mailNickname": "library",
'   "securityEnabled": false
' }

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.UpdateString("description","Self help community for library")
success = json.UpdateString("displayName","Library Assist")
success = json.UpdateString("groupTypes[0]","Unified")
success = json.UpdateBool("mailEnabled",True)
success = json.UpdateString("mailNickname","library")
success = json.UpdateBool("securityEnabled",False)

' POST the JSON to https://graph.microsoft.com/v1.0/groups


Set resp = http.PostJson3("https://graph.microsoft.com/v1.0/groups","application/json",json)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

success = json.Load(resp.BodyStr)
json.EmitCompact = False

If (resp.StatusCode <> 201) Then
    Debug.Print json.Emit()
    Debug.Print "Failed, response status code = "; resp.StatusCode

    Exit Sub
End If

Debug.Print json.Emit()

' A sample response:
' (See code for parsing this response below..)

' {
'     "id": "b320ee12-b1cd-4cca-b648-a437be61c5cd",
' 	  "deletedDateTime": null,
' 	  "classification": null,
' 	  "createdDateTime": "2018-12-22T00:51:37Z",
' 	  "creationOptions": [],
' 	  "description": "Self help community for library",
' 	  "displayName": "Library Assist",
' 	  "groupTypes": [
' 	      "Unified"
' 	  ],
' 	  "mail": "library7423@contoso.com",
' 	  "mailEnabled": true,
' 	  "mailNickname": "library",
' 	  "onPremisesLastSyncDateTime": null,
' 	  "onPremisesSecurityIdentifier": null,
' 	  "onPremisesSyncEnabled": null,
' 	  "preferredDataLocation": "CAN",
' 	  "proxyAddresses": [
' 	      "SMTP:library7423@contoso.com"
' 	  ],
' 	  "renewedDateTime": "2018-12-22T00:51:37Z",
' 	  "resourceBehaviorOptions": [],
' 	  "resourceProvisioningOptions": [],
' 	  "securityEnabled": false,
' 	  "visibility": "Public",
' 	  "onPremisesProvisioningErrors": []
' }

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

id = json.StringOf("id")
deletedDateTime = json.StringOf("deletedDateTime")
classification = json.StringOf("classification")
createdDateTime = json.StringOf("createdDateTime")
description = json.StringOf("description")
displayName = json.StringOf("displayName")
mail = json.StringOf("mail")
mailEnabled = json.BoolOf("mailEnabled")
mailNickname = json.StringOf("mailNickname")
onPremisesLastSyncDateTime = json.StringOf("onPremisesLastSyncDateTime")
onPremisesSecurityIdentifier = json.StringOf("onPremisesSecurityIdentifier")
onPremisesSyncEnabled = json.StringOf("onPremisesSyncEnabled")
preferredDataLocation = json.StringOf("preferredDataLocation")
renewedDateTime = json.StringOf("renewedDateTime")
securityEnabled = json.BoolOf("securityEnabled")
visibility = json.StringOf("visibility")
i = 0
count_i = json.SizeOfArray("creationOptions")
Do While i < count_i
    json.I = i
    i = i + 1
Loop
i = 0
count_i = json.SizeOfArray("groupTypes")
Do While i < count_i
    json.I = i
    strVal = json.StringOf("groupTypes[i]")
    i = i + 1
Loop
i = 0
count_i = json.SizeOfArray("proxyAddresses")
Do While i < count_i
    json.I = i
    strVal = json.StringOf("proxyAddresses[i]")
    i = i + 1
Loop
i = 0
count_i = json.SizeOfArray("resourceBehaviorOptions")
Do While i < count_i
    json.I = i
    ' ...
    i = i + 1
Loop
i = 0
count_i = json.SizeOfArray("resourceProvisioningOptions")
Do While i < count_i
    json.I = i
    ' ...
    i = i + 1
Loop
i = 0
count_i = json.SizeOfArray("onPremisesProvisioningErrors")
Do While i < count_i
    json.I = i
    ' ...
    i = i + 1
Loop

Debug.Print "Success."