C# Dynamics CRM: Lookup Account ID using Account Name

Back to Index

Gets the accountid by name.

Documentation: http://www.odata.org/getting-started/basic-tutorial/#queryData

CURL Command

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"

C# Example

Chilkat.Rest rest = new Chilkat.Rest();
bool success;

//  URL: https://my-dynamics-domain.api.crm.dynamics.com/api/data/v9.0/accounts
bool bTls = true;
int port = 443;
bool bAutoReconnect = true;
success = rest.Connect("my-dynamics-domain.api.crm.dynamics.com",port,bTls,bAutoReconnect);
if (success != true) {
    Debug.WriteLine("ConnectFailReason: " + Convert.ToString(rest.ConnectFailReason));
    Debug.WriteLine(rest.LastErrorText);
    return;
}

rest.AddQueryParam("$select","accountid");
rest.AddQueryParam("$filter","name eq 'Blue Yonder Airlines'");

rest.AddHeader("OData-MaxVersion","4.0");
rest.AddHeader("Accept","application/json");
rest.AddHeader("OData-Version","4.0");
rest.AddHeader("Authorization","Bearer DYNAMICS_CRM_ACCESS_TOKEN");

Chilkat.StringBuilder sbResponseBody = new Chilkat.StringBuilder();
success = rest.FullRequestNoBodySb("GET","/api/data/v9.0/accounts",sbResponseBody);
if (success != true) {
    Debug.WriteLine(rest.LastErrorText);
    return;
}

int respStatusCode = rest.ResponseStatusCode;
if (respStatusCode >= 400) {
    Debug.WriteLine("Response Status Code = " + Convert.ToString(respStatusCode));
    Debug.WriteLine("Response Header:");
    Debug.WriteLine(rest.ResponseHeader);
    Debug.WriteLine("Response Body:");
    Debug.WriteLine(sbResponseBody.GetAsString());
    return;
}

Chilkat.JsonObject jsonResponse = new Chilkat.JsonObject();
jsonResponse.LoadSb(sbResponseBody);

int i;
int count_i;

string odataContext = jsonResponse.StringOf("\"@odata.context\"");
i = 0;
count_i = jsonResponse.SizeOfArray("value");
while (i < count_i) {
    jsonResponse.I = i;
    string odataEtag = jsonResponse.StringOf("value[i].\"@odata.etag\"");
    string accountid = jsonResponse.StringOf("value[i].accountid");
    i = i + 1;
}

Sample JSON Response Body

{
  "@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"
    }
  ]
}