Dynamic CRM Web Api CRUD 操作

傷城~ 2022-11-15 14:11 225阅读 0赞

在Dynamic CRM online开发中，webapi 操作数据示例：

// define the data to create new account  
var data =  
\{  
    "name": "Sample Account",  
    "creditonhold": false,  
    "address1\_latitude": 47.639583,  
    "description": "This is the description of the sample account",  
    "revenue": 5000000,  
    "accountcategorycode": 1  
\}

// create account record  
Xrm.WebApi.createRecord("account", data).then(  
    function success(result) \{  
        console.log("Account created with ID: " + result.id);  
        // perform operations on record creation  
    \},  
    function (error) \{  
        console.log(error.message);  
        // handle error conditions  
    \}  
);

Xrm.WebApi.deleteRecord("account", "e8aa440a-1c89-eb11-a812-000d3acdd17d").then(  
    function success(result) \{  
        console.log("Account deleted");  
        // perform operations on record deletion  
    \},  
    function (error) \{  
        console.log(error.message);  
        // handle error conditions  
    \}  
);

Xrm.WebApi.retrieveRecord("account", "f990c3f5-e086-eb11-b1ac-000d3a6faf27", "?$select=name,revenue,telephone1").then(  
    function success(result) \{

console.log("Retrieved values: Name: " + result.name + ", Revenue: " + result.revenue + "Telephone1:" + result.telephone1);  
        // perform operations on record retrieval  
    \},  
    function (error) \{  
        console.log(error.message);  
        // handle error conditions  
    \}  
);

Xrm.WebApi.retrieveMultipleRecords("account", "?$select=name&$top=3&$orderby=name").then(  
    function success(result) \{  
        for (var i = 0; i < result.entities.length; i++) \{  
            console.log(result.entities\[i\]);  
        \}  
        // perform additional operations on retrieved records  
    \},  
    function (error) \{  
        console.log(error.message);  
        // handle error conditions  
    \}  
);

Xrm.WebApi.retrieveMultipleRecords("account", "?$select=name,\_primarycontactid\_value&$filter=primarycontactid/contactid eq a0dbf27c-8efb-e511-80d2-00155db07c77").then(  
    function success(result) \{  
        for (var i = 0; i < result.entities.length; i++) \{  
            console.log(result.entities\[i\]);  
        \}  
        // perform additional operations on retrieved records  
    \},  
    function (error) \{  
        console.log(error.message);  
        // handle error conditions  
    \}  
);

Xrm.WebApi.retrieveMultipleRecords("account", "?$select=name&$top=3&$expand=primarycontactid($select=contactid,fullname)", 3).then(  
    function success(result) \{  
        for (var i = 0; i < result.entities.length; i++) \{  
            console.log(result.entities\[i\]);  
        \}  
        // perform additional operations on retrieved records  
    \},  
    function (error) \{  
        console.log(error.message);  
        // handle error conditions  
    \}  
);

// define the data to update a record  
var data =  
\{  
    "name": "Updated Sample Account ",  
    "creditonhold": true,  
    "address1\_latitude": 47.639583,  
    "description": "This is the updated description of the sample account",  
    "revenue": 6000000,  
    "accountcategorycode": 2  
\}  
// update the record  
Xrm.WebApi.updateRecord("account", "82c7e91e-ec7e-eb11-a812-000d3ace02d1", data).then(  
    function success(result) \{  
        console.log("Account updated");  
        // perform operations on record update  
    \},  
    function (error) \{  
        console.log(error.message);  
        // handle error conditions  
    \}  
);