You’re offline. This is a read only version of the page.
Announcements
For an account I m trying to populate primarycontactid (lookup field) using the following code but CRM returns error "400 Bad Request"
Can you please guide how is this code wrong ? Or please if can provide a working sample of similar snario ?
- var entity = {};
- entity.primarycontactid = {
- Id: "ba121cbc-6a41-e611-80e0-c4346bc58294",
- LogicalName: "contact"
- };
- var req = new XMLHttpRequest();
- req.open("PATCH", Xrm.Page.context.getClientUrl() + "/api/data/v8.0/accounts(bf121cbc-6a41-e611-80e0-c4346bc58294)", true);
- req.setRequestHeader("OData-MaxVersion", "4.0");
- req.setRequestHeader("OData-Version", "4.0");
- req.setRequestHeader("Accept", "application/json");
- req.setRequestHeader("Content-Type", "application/json; charset=utf-8");
- req.onreadystatechange = function () {
- if (this.readyState === 4) {
- req.onreadystatechange = null;
- if (this.status === 204) {
- //Success - No Return Data - Do Something
- }
- else {
- alert(this.statusText);
- }
- }
- };
- req.send(JSON.stringify(entity));
*This post is locked for comments
Could you please help with the following scenario ? I am running this code to delete a reference parentcustomerid_account
This is working successfully on DEV but when executed on different environment IFD / ADFS the request is 404 NOT FOUND
Do you have any idea ? Thank you
// [Org URI]/api/data/v8.2/contacts([contactid#])/parentcustomerid_account/$ref
contact1Uri = httpClient.BaseAddress + web_api + "contacts(" + myReader.Value.ToString
().ToLower() + ")/parentcustomerid_account/$ref";
HttpResponseMessage disassocResponse1 = await httpClient.DeleteAsync(contact1Uri);
if (disassocResponse1.StatusCode == HttpStatusCode.NoContent)
Status code is 404 = NOT FOUND
Same code is successful on different environment
Could you please help with the following scenario ? I am running this code to delete a reference parentcustomerid_account
This is working successfully on DEV but when executed on different environment IFD / ADFS the request is 404 NOT FOUND
Do you have any idea ? Thank you
// [Org URI]/api/data/v8.2/contacts([contactid#])/parentcustomerid_account/$ref
contact1Uri = httpClient.BaseAddress + web_api + "contacts(" + myReader.Value.ToString().ToLower() + ")/parentcustomerid_account/$ref";
HttpResponseMessage disassocResponse1 = await httpClient.DeleteAsync(contact1Uri);
if (disassocResponse1.StatusCode == HttpStatusCode.NoContent)
Do I have to create two requests of DELETE for updating of the first field and PATCH for updating of the second field?
@Maksym Tomyn no you have to do disassociate to remove the lookup value (https://msdn.microsoft.com/en-us/library/mt607875.aspx):
For a single-valued navigation property, remove the $id query string parameter.
- DELETE [Organization URI]/api/data/v8.2/opportunities(00000000-0000-0000-0000-000000000001)/customerid_account/$ref HTTP/1.1
- Accept: application/json
- OData-MaxVersion: 4.0
- OData-Version: 4.0
How to update lookup field to null ? Can I update the entity with removal of value?
var entity = {};
entity["primarycontactid@odata.bind"] ="/contacts(null)"
entity["new_AccountName@odata.bind"] ="/contacts(89153C7D-E45E-E611-80F6-1458D05A5490)"
var req = new XMLHttpRequest();
req.open("PATCH", Xrm.Page.context.getClientUrl() + "/api/data/v8.0/accounts(bf121cbc-6a41-e611-80e0-c4346bc58294)", true);
req.setRequestHeader("OData-MaxVersion", "4.0");
req.setRequestHeader("OData-Version", "4.0");
req.setRequestHeader("Accept", "application/json");
req.setRequestHeader("Content-Type", "application/json; charset=utf-8");
req.onreadystatechange = function () {
if (this.readyState === 4) {
req.onreadystatechange = null;
if (this.status === 204) {
//Success - No Return Data - Do Something
}
else {
alert(this.statusText);
}
}
};
req.send(JSON.stringify(entity));
While creating CRM record using Web Api we need to use Odata CRM Schema Names not name of the attribute.
ie, if the field is created with name "new_accountname" then the Schema name is looks like "new_AccountName".
So While setting lookup value we need to follow the below syntax instead of using auto code generated by CRMRestBuilder.
Ex:
var entity = {};
entity["primarycontactid@odata.bind"] ="/contacts(89153C7D-E45E-E611-80F6-1458D05A5490)"
entity["new_AccountName@odata.bind"] ="/contacts(89153C7D-E45E-E611-80F6-1458D05A5490)"
var req = new XMLHttpRequest();
req.open("PATCH", Xrm.Page.context.getClientUrl() + "/api/data/v8.0/accounts(bf121cbc-6a41-e611-80e0-c4346bc58294)", true);
req.setRequestHeader("OData-MaxVersion", "4.0");
req.setRequestHeader("OData-Version", "4.0");
req.setRequestHeader("Accept", "application/json");
req.setRequestHeader("Content-Type", "application/json; charset=utf-8");
req.onreadystatechange = function () {
if (this.readyState === 4) {
req.onreadystatechange = null;
if (this.status === 204) {
//Success - No Return Data - Do Something
}
else {
alert(this.statusText);
}
}
};
req.send(JSON.stringify(entity));
jQuery is just a wrapper of JavaScript functions in order to be cross-browser compatible.
WebAPI is officially released but not all the SDK operations are available with WebAPI yet.
hope it helps
Thanks Guido, it helped.
I tried as suggested using JS and result was same error, then I tried using JQuery and it was fine. Just curiest is it something known ? WebAPI sdk has not been released officially does it means it is not stable yet ? Thanks for your guidance.
follow this blog post in order to see how you need to specify a lookup field with the new Web API
www.inogic.com/.../set-values-of-all-data-types-using-web-api-in-dynamics-crm
#1
André Arnaud de Cal...
293,364
Super User 2025 Season 1
#2
Martin Dráb
232,524
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (