本文主要讲述Dynamic CRM 2016使用FetchXml进行记录检索
代码如下
function RetrieveUsingWebAPIFetchxml() {
debugger;
var fetchxml = "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>" +
"<entity name='account'>" +
"<attribute name='name' />" +
"<attribute name='primarycontactid' />" +
"<attribute name='telephone1' />" +
"<attribute name='accountid' />" +
"<order attribute='name' descending='false' />" +
"<filter type='and'>" +
"<condition attribute='accountid' operator='eq' value='{AD43098E-38AD-E711-80C8-CD6AC961FE61}' />" +
"</filter>" +
"</entity>" +
"</fetch>";
var req = new XMLHttpRequest();
req.open("GET", encodeURI(Xrm.Page.context.getClientUrl() + "/api/data/v8.0/accounts?fetchXml=" + encodeURI(fetchxml), true));
req.setRequestHeader("Accept", "application/json");
req.setRequestHeader("Content-Type", "application/json; charset=utf-8");
req.setRequestHeader("OData-MaxVersion", "4.0");
req.setRequestHeader("OData-Version", "4.0");
req.onreadystatechange = function () {
if (this.readyState == 4) {
req.onreadystatechange = null;
if (this.status == 200) {
if (JSON.parse(this.response).value.length > 0)
var data = JSON.parse(this.response).value;
}
else {
var error = JSON.parse(this.response).error;
}
}
};
req.send();
}查询结果如下:
(1)存在记录:
(2)记录不存在

本文详细介绍了如何在Dynamic CRM 2016中利用WEB API和FetchXml查询特定记录,提供了存在记录和记录不存在时的代码示例。
&spm=1001.2101.3001.5002&articleId=78219762&d=1&t=3&u=f40439c5e320425d8e78e4e76fb2e2db)

被折叠的 条评论
为什么被折叠?



