Dynamics CRM 2016: JavaScript causes JSON Parse Error

Question

I am trying to get the price of a product in Dynamics CRM 2016, by javascript on the onChange event for the product. This is on a custom entity I have created and is using the pricelistid and the productid.

When I use the same javascript in the console on Chrome i can get the data out but when it is executed by the CRM form I get an error:

SyntaxError: Unexpected end of JSON input at JSON.parse ()

The code is:

var pricelevelid = Xrm.Page.getAttribute("sg_pricelistid").getValue()[0].id;
pricelevelid = pricelevelid.replace(/[{}]/g, "");

var productdata = Xrm.Page.getAttribute("sg_productid").getValue();
if (productdata != null)
        {
        console.log("going into productdata loop");
        productid = productdata[0].id;
        productid = productid.replace(/[{}]/g, "");

        var req = new XMLHttpRequest();
        req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v8.0/productpricelevels?$select=amount,_pricelevelid_value,_productid_value,productpricelevelid&$filter=_pricelevelid_value eq " + pricelevelid + " and  _productid_value eq " + productid + "", 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 === 200) {
                  var results = JSON.parse(this.response);
                        for (var i = 0; i < results.value.length; i++) {
                            var amount = results.value[i]["amount"];
                            var amount_formatted = results.value[i]["[email protected]"];
                        }
                } else {
                    Xrm.Utility.alertDialog(this.statusText);
                }
            }
        };
        req.send();

        data = JSON.parse(req.responseText);
        var amount = data.value[0]["amount"];
        Xrm.Page.getAttribute("sg_unitprice").setValue(amount);
        }

mktange · Accepted Answer · 2016-11-26 12:49:06Z

2

You are performing an asynchronous request and then attempting to parse the response, before it has been set to anything.

This happens at the bottom of your code block at data = JSON.parse(req.responseText), right after you send the request.

All code that relies on the response should be executed in the req.onreadystatechange callback function.

answered Nov 26, 2016 at 12:49

mktange

4171 gold badge3 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Dynamics CRM 2016: JavaScript causes JSON Parse Error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related