Tuesday, 25 December 2018

Single Record Retrieving Using WebAPI in MSCRM

Single Record Retrieving Using WebAPI in MSCRM
==============================================================
function RetrievingRecords() {

    var lookup = Xrm.Page.data.entity.getId();
    var lookupID = lookup.replace('{', '').replace('}', '');
    var req = new XMLHttpRequest();
    req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v9.1/new_testcrms(" + lookupID + ")?$select=_new_accounts_value,new_countries,new_dob,new_gender,new_moneytype,new_moneytype_base,new_name,new_numbers,new_rates", 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.setRequestHeader("Prefer", "odata.include-annotations=\"*\"");
    req.onreadystatechange = function () {
        if (this.readyState === 4) {
            req.onreadystatechange = null;
            if (this.status === 200) {
           
                var result = JSON.parse(this.response);
                // Lookup field guid value
                var _new_accounts_value = result["_new_accounts_value"];
                //Lookupfield text value
                var _new_accounts_value_formatted = result["_new_accounts_value@OData.Community.Display.V1.FormattedValue"];
                //  lookup field  entityname
                var _new_accounts_value_lookuplogicalname = result["_new_accounts_value@Microsoft.Dynamics.CRM.lookuplogicalname"];
                // optionset value
                var new_countries = result["new_countries"];

                // optionset field text value
                var new_countries_formatted = result["new_countries@OData.Community.Display.V1.FormattedValue"];
                var new_dob = result["new_dob"];
                // two optionset true
                var new_gender = result["new_gender"];
                // two optionset text value  Yes
                var new_gender_formatted = result["new_gender@OData.Community.Display.V1.FormattedValue"];
                // money field values
                var new_moneytype = result["new_moneytype"];
                // money field values with symbols
                var new_moneytype_formatted = result["new_moneytype@OData.Community.Display.V1.FormattedValue"];
                var new_moneytype_base = result["new_moneytype_base"];
                var new_moneytype_base_formatted = result["new_moneytype_base@OData.Community.Display.V1.FormattedValue"];
                var new_name = result["new_name"];
                var new_numbers = result["new_numbers"];
                var new_numbers_formatted = result["new_numbers@OData.Community.Display.V1.FormattedValue"];
                var new_rates = result["new_rates"];
                var new_rates_formatted = result["new_rates@OData.Community.Display.V1.FormattedValue"];
            } else {
                Xrm.Utility.alertDialog(this.statusText);
            }
        }
    };
    req.send();

}

No comments:

Post a Comment