REST Endpoint or OData operations in MS CRM 2011-Part 1



To locate and retrieve data with the REST Endpoint, manipulate URI.
The organization root URL must include organization.
We can retrieve service root URI by using Xrm.Page.context.getServerUrl
Each MS CRM 2011 entity is represented in the conceptual schema definition language (CSDL).
The Naming convention is [Entity Schema name] Set
MS CRM 2011 entity attributes. Each property is assigned a data type that corresponds to one of the primitive Entity Data Model (EDM) data types or Complex type defined for MS CRM.
Complex Types:
1.       Microsoft.Crm.Sdk.Data.Services.EntityReference àrepresents EntityReference and Customer Owner.
2.       Microsoft.Crm.Sdk.Data.Services.OptionSetValueàOptionSetValue, State and Status.
3.       Microsoft.Crm.Sdk.Data.Services.MoneyàMoney
4.       Microsoft.Crm.Sdk.Data.Services.BooleanManagedPropertyàBooleanMangedProperty

Entity Reference
Name
Type
Id
GUID
LogicalName
String
Name
Sting

Ex: set entity reference to entity
                     entity.StateProvince = { Id:”xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx”, 
                                  LogicalName: "name of the entity", 
                                  Name: “record name” };
OptionSetValue
Name
Type
Value
Number

Ex: set OptionSetValue
Logical name of ubs_BillingConsumptionType is ubs_billingconsumptiontype
entity.ubs_BillingConsumptionType={ Value: 5 };
 

Money
Name
Type
Value
Number

Ex: Set Money
entity.Limit={ Value =100.00}
Note: attribute name is case sensitive (it means attribute name must be equal to the OData attribute Name. check the names by retrieve Query).

Comments

Post a Comment

Popular posts from this blog

MS CRM 4.0 Relationship Mappings Error

Image
Whenever relationship is deleted but relationship attribute is used in another relationship mappings. In that case if you click on mappings you will get below error message. Cause: attribute is deleted but attribute is used in attribute mappings. In MS CRM attribute relationship mappings are saved in following tables E ntityMapBase AttributeMapBase Identify the mapping record in EntityMapBase Table. Take the GUID of that record and find the related attribue records in AttributeMapTable select * from dbo . AttributeMapBase where EntityMapId = 'place your relationship record GUID' update the your deleted attribute records DeletionStateCode with 2.
Read more

Open Data Protocol

The open data protocol is a web protocol for querying and updating data.OData does this by applying and building upon web technologies such as HTTP Atom publishing Protocol (AtomPub) JSON to provide access to information from variety of applications,services and stores. OData being used to access information from different sources like Relational Data base File Systems Content management systems Traditional  web sites OData is consistent with the way the Web Works.This Commitment to core Web Principles allow Odata enable a new level of data integration and interoperability across the broad range of clients,server, services and tools. OData provides the uniform way to expose,structure,query and manipulate data using REST practices and JSON or ATOM.OData also provides a way to reprasent metadata about the data,allowing computers to know more about the type system,relationships and structure of the data.
Read more

Using Read-only versus const

There are Two difference versions of constants in C#: the Const keyword is used for compile –time constants read only keyword is used for runtime constants. The main issue with const is that it's evaluated at compile-time, which means if it's changed at a later date; you have to not only recompile that application, but all applications that reference that application. In contrast, read -only is evaluated at run-time providing you a lot more flexibility. An overview of differences between const and read-only in c#      Const Read only Cont be static Can be either instance-level or static Value is evaluated at compile time The value is evaluated at run time. It is initialized at declaration only It can be initialized in declaration or by code in the code constructor .therefore read only fields have difference values depending on constructor used.   So, const should really only be used for logical, real-world constants such as days of week, numeric Constants, etc. as for as perfo...
Read more