Gets the accountid by name.
curl -X GET https://my-dynamics-domain.api.crm.dynamics.com/api/data/v9.0/accounts
-H "Accept: application/json" \
-H "OData-MaxVersion: 4.0" \
-H "OData-Version: 4.0" \
-d "$select=accountid" \
-d "$filter=name eq 'Blue Yonder Airlines'" \
-H "Authorization: Bearer DYNAMICS_CRM_ACCESS_TOKEN"
Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest
' URL: https://my-dynamics-domain.api.crm.dynamics.com/api/data/v9.0/accounts
bTls = True
port = 443
bAutoReconnect = True
success = rest.Connect("my-dynamics-domain.api.crm.dynamics.com",port,bTls,bAutoReconnect)
If (success <> True) Then
Debug.Print "ConnectFailReason: "; rest.ConnectFailReason
Debug.Print rest.LastErrorText
Exit Sub
End If
success = rest.AddQueryParam("$select","accountid")
success = rest.AddQueryParam("$filter","name eq 'Blue Yonder Airlines'")
success = rest.AddHeader("OData-MaxVersion","4.0")
success = rest.AddHeader("Accept","application/json")
success = rest.AddHeader("OData-Version","4.0")
success = rest.AddHeader("Authorization","Bearer DYNAMICS_CRM_ACCESS_TOKEN")
Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = rest.FullRequestNoBodySb("GET","/api/data/v9.0/accounts",sbResponseBody)
If (success <> True) Then
Debug.Print rest.LastErrorText
Exit Sub
End If
respStatusCode = rest.ResponseStatusCode
If (respStatusCode >= 400) Then
Debug.Print "Response Status Code = "; respStatusCode
Debug.Print "Response Header:"
Debug.Print rest.ResponseHeader
Debug.Print "Response Body:"
Debug.Print sbResponseBody.GetAsString()
Exit Sub
End If
Dim jsonResponse As Chilkat.JsonObject
Set jsonResponse = Chilkat.NewJsonObject
success = jsonResponse.LoadSb(sbResponseBody)
odataContext = jsonResponse.StringOf("""@odata.context""")
i = 0
count_i = jsonResponse.SizeOfArray("value")
Do While i < count_i
jsonResponse.I = i
odataEtag = jsonResponse.StringOf("value[i].""@odata.etag""")
accountid = jsonResponse.StringOf("value[i].accountid")
i = i + 1
Loop
{
"@odata.context": "https://mydomain.api.crm.dynamics.com/api/data/v9.0/$metadata#accounts(accountid)",
"value": [
{
"@odata.etag": "W/\"1817216\"",
"accountid": "aca19cdd-88df-e311-b8e5-6c3be5a8b200"
}
]
}