Customer experience | Sales, Customer Insights,...

why I am not getting value in result what's wrong with the code

(0) Share

Report

Posted on by unbeatable

365

function onformload(executioncontext){

debugger

var req = new XMLHttpRequest();

var id = Xrm.Page.data.entity.getId();

var results;

req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v9.1/ap_pensionss?$select=ap_fundsrequestedfromcedingscheme,ap_fundsreceviedfromceedingschemedate&$filter=ap_opportunitypensionsid eq "+ id.replace("{", "").replace("}", "") ,false);

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.setRequestHeader("Prefer", "odata.include-annotations=\"*\"");

req.onreadystatechange = function () {

if (this.readyState === 4) {

req.onreadystatechange = null;

if (this.status === 200) {

debugger;

results = JSON.parse(this.response);

debugger;

} else {

}

};

req.send();

}

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Bipin D365 28,985 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

I would recommend to install Rest Builder solution on your crm instance to Auto generate web api code and test it inside the same tool.

Download link - github.com/.../releases

Another option is to use Xrm.Webapi instead of xmlhttprequest.

docs.microsoft.com/.../retrieverecord

Replace your filter with below

&$filter=ap_opportunitypensionsid eq '"+ id.replace("{", "").replace("}"'

Please mark my answer verified if i were helpful

Was this reply helpful? Yes No
unbeatable 365 on at

Like (0)

Report
Copy link

Link copied!

this not help full at all

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!
Hi partner,

Could you use Rest Builder to create request?

You can refer following screenshot to create request.

Then you can use it in combination with the code below and the code in the image above.

function test(executionContext) { var formContext = executionContext.getFormContext(); var id = formContext.data.entity.getId(); id = id.replace("{", "").replace("}", ""); var req = new XMLHttpRequest(); req.open("GET", Xrm.Page.context.getClientUrl() "/api/data/v9.1/contacts?$select=_accountid_value,address1_addressid,emailaddress1,fullname&$filter=_accountid_value eq " id "", true); ……

And you can try to use asynchronous requests, because synchronous requests block the execution of code which causes "freezing" on the screen and an unresponsive user experience.

This means that you need change ‘false’ with ‘true’.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No