{"id":846,"date":"2012-10-18T10:18:17","date_gmt":"2012-10-18T10:18:17","guid":{"rendered":"http:\/\/mahenderpal.wordpress.com\/?p=846"},"modified":"2012-10-18T10:18:17","modified_gmt":"2012-10-18T10:18:17","slug":"retrieve-ms-crm-datatype-fields-using-late-bound","status":"publish","type":"post","link":"https:\/\/himbap.com\/blog\/?p=846","title":{"rendered":"Retrieve MS CRM fields using late bound"},"content":{"rendered":"

In my earlier post<\/a> I have provided sample code to set different data type fields using late bound in MS CRM 2011. In this post I am going to how can we fetch value from different data type fields.<\/p>\n

Entity _Account = service.Retrieve(“account”, new Guid(“XXXXX”), new ColumnSet(new string[] { “name”, “accountcategorycode”, “new_collectiondate”, “creditlimit”, “parentaccountid”, “new_executivecommission”, “new_isbilled” }));<\/p>\n

\/\/To fetch string value
\nstring Name = _Account[“name”].ToString();<\/p>\n

\/\/To fetch optionset selected value
\nint OptionSetValue = ((OptionSetValue)_Account[“accountcategorycode”]).Value;<\/p>\n

\/\/To fetch date time field value
\nDateTime CollectionDate = ((DateTime)_Account[“new_collectiondate”]).Date;<\/p>\n

\/\/To fetch money field value
\ndecimal Creditlimit = ((Money)_Account[“creditlimit”]).Value;<\/p>\n

\/\/To fetch decimal field value
\ndecimal Executivecommission = (decimal)_Account[“new_executivecommission”];<\/p>\n

\/\/To fetch lockup field
\nGuid ParentAccountID = ((EntityReference)_Account[“parentaccountid”]).Id;<\/p>\n

\/\/To fetch Boolean field<\/p>\n

Boolean IsBilled=(Boolean)_Account[“new_isbilled”];<\/p>\n

\"\"<\/a>
\nEnjoy !!!<\/p>\n","protected":false},"excerpt":{"rendered":"

In my earlier post I have provided sample code to set different data type fields using late bound in MS CRM 2011. In this post I am going to how can we fetch value from different data type fields. Entity _Account = service.Retrieve(“account”, new Guid(“XXXXX”), new ColumnSet(new string[] { “name”, “accountcategorycode”, “new_collectiondate”, “creditlimit”, “parentaccountid”, “new_executivecommission”, “new_isbilled” })); \/\/To fetch string… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[94,109,165],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/846"}],"collection":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=846"}],"version-history":[{"count":0,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/846\/revisions"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=846"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=846"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=846"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}