Dynamics 365 通过外键查询表中数据

//获取页面ID

var id=Xrm.Page.data.entity.getId().replace("{", "").replace("}", "");

//条件查询

var filter="?$filter=字段 eq " + id;

// 通过外键查询

//var filter="?$filter=被查询表外键/查询表主键 eq GUID"

//url 拼接

var url =Xrm.Page.context.getClientUrl() + "/api/data/v9.0/实体/"+filter;

crmAjax({
method: 'GET',
url: url,
xmlstatus: 200,
success: function (response) {
//调用遍历
body(response, Discount);
}
});
}

 

function crmAjax(opt) {
opt = opt || {};
opt.method = opt.method.toUpperCase() || 'POST';
opt.url = opt.url || '';
opt.async = opt.async || true;
opt.data = opt.data || null;
opt.success = opt.success || function () { };
opt.xmlstatus = opt.xmlstatus || 200;
var xmlHttp = null;
if (XMLHttpRequest) {
xmlHttp = new XMLHttpRequest();
}
else {
xmlHttp = new ActiveXObject('Microsoft.XMLHTTP');
}
var params = [];
for (var key in opt.data) {
params.push(key + '=' + opt.data[key]);
}
var postData = params.join('&');
if (opt.method.toUpperCase() === 'POST') {
xmlHttp.open(opt.method, opt.url, opt.async);
xmlHttp.setRequestHeader('Content-Type', 'application/json;charset=utf-8');
xmlHttp.send(postData);
}
else if (opt.method.toUpperCase() === 'GET') {
xmlHttp.open(opt.method, opt.url, opt.async);
xmlHttp.send(null);
}
xmlHttp.onreadystatechange = function () {
if (xmlHttp.readyState === 4 && xmlHttp.status === opt.xmlstatus) {
opt.success(xmlHttp.responseText);
}
};
}