(Excel) Outlook Contacts Create a Contact

See more Outlook Contact Examples

Creates an Outlook Contact.

For more information, see https://docs.microsoft.com/en-us/graph/api/user-post-contacts?view=graph-rest-1.0&tabs=http

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 here: Get Outlook Contacts OAuth2 Access Token (Azure AD v2.0 Endpoint).

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

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

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

' Send the following POST:

' POST https://graph.microsoft.com/v1.0/me/contacts
' Content-type: application/json
' 
' {
'   "givenName": "Pavel",
'   "surname": "Bansky",
'   "emailAddresses": [
'     {
'       "address": "pavelb@fabrikam.onmicrosoft.com",
'       "name": "Pavel Bansky"
'     }
'   ],
'   "businessPhones": [
'     "+1 732 555 0102"
'   ]
' }

' Build the JSON body of the POST.

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

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
Dim success As Boolean
success = json.UpdateString("givenName","Pavel")
success = json.UpdateString("surname","Bansky")
success = json.UpdateString("emailAddresses[0].address","pavelb@fabrikam.onmicrosoft.com")
success = json.UpdateString("emailAddresses[0].name","Pavel Bansky")
success = json.UpdateString("businessPhones[0]","+1 732 555 0102")

' Send the HTTP POST

Set resp = http.PostJson2("https://graph.microsoft.com/v1.0/me/contacts","application/json",json.Emit())
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "Response status code = "; resp.StatusCode

Dim jResp As Chilkat.JsonObject
Set jResp = Chilkat.NewJsonObject
success = jResp.Load(resp.BodyStr)
jResp.EmitCompact = False
Debug.Print jResp.Emit()

' The send succeeded if the response status code = 201.
If (resp.StatusCode <> 201) Then
    Debug.Print "Failed"
    Exit Sub
End If

' Sample JSON response:

' {
'   "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('4ee732c3-322e-4a6b-b729-2fd1eb5c6004')/contacts/$entity",
'   "@odata.etag": "W/\"EQAAABYAAABUcG0qWqkmQYqWLHQataQxAAD0iYfT\"",
'   "id": "AAMkADYzZWE3YmZmLWU0YzgtNGNkZC04MGE1LWFiYTFlNTRlY2QwYQBGAAAAAAAu7cUXL5YOTrdsUIw7-v8FBwBUcG0qWqkmQYqWLHQataQxAAAAAAEOAABUcG0qWqkmQYqWLHQataQxAAD0sxexAAA=",
'   "createdDateTime": "2021-06-29T16:32:05Z",
'   "lastModifiedDateTime": "2021-06-29T16:32:06Z",
'   "changeKey": "EQAAABYAAABUcG0qWqkmQYqWLHQataQxAAD0iYfT",
'   "categories": [
'   ],
'   "parentFolderId": "AAMkADYzZWE3YmZmLWU0YzgtNGNkZC04MGE1LWFiYTFlNTRlY2QwYQAuAAAAAAAu7cUXL5YOTrdsUIw7-v8FAQBUcG0qWqkmQYqWLHQataQxAAAAAAEOAAA=",
'   "birthday": null,
'   "fileAs": "",
'   "displayName": "Pavel Bansky",
'   "givenName": "Pavel",
'   "initials": null,
'   "middleName": null,
'   "nickName": null,
'   "surname": "Bansky",
'   "title": null,
'   "yomiGivenName": null,
'   "yomiSurname": null,
'   "yomiCompanyName": null,
'   "generation": null,
'   "imAddresses": [
'   ],
'   "jobTitle": null,
'   "companyName": null,
'   "department": null,
'   "officeLocation": null,
'   "profession": null,
'   "businessHomePage": null,
'   "assistantName": null,
'   "manager": null,
'   "homePhones": [
'   ],
'   "mobilePhone": null,
'   "businessPhones": [
'     "+1 732 555 0102"
'   ],
'   "spouseName": null,
'   "personalNotes": "",
'   "children": [
'   ],
'   "emailAddresses": [
'     {
'       "name": "Pavel Bansky",
'       "address": "pavelb@fabrikam.onmicrosoft.com"
'     }
'   ],
'   "homeAddress": {},
'   "businessAddress": {},
'   "otherAddress": {}
' }

Debug.Print "Contact created."