Retrieved custom entity properties are not returned when they're empty (V4.0)

Posted on 2008-06-13
Last Modified: 2013-11-24
My webservice retrieves custom CRM entities and decides if certain properties need to be updated from an external source. It seems that whenever properties in CRM are empty (certainly string properties - I've yet to test other property types) they aren't returned in my DynamicEntity. My logic is being driven by properties returned and decides what needs to be updated, so any empty string properties never get updated! See snippet. Thanks for any advice/suggestions.
Dim query As New QueryExpression

query.EntityName = "my_entity"

query.ColumnSet = New AllColumns

Dim condition1 As New ConditionExpression

condition1.AttributeName = sExistingEntityKey

condition1.Operator = ConditionOperator.Equal

condition1.Values = New String() {sLookupKey}

Dim childFilter As New FilterExpression

childFilter.FilterOperator = LogicalOperator.And

childFilter.Conditions = New ConditionExpression() {condition1}

query.Criteria = childFilter

Dim retrieve As New RetrieveMultipleRequest()

retrieve.Query = query

retrieve.ReturnDynamicEntities = True

Dim retrieved As RetrieveMultipleResponse = CType(crmServ.Execute(retrieve), RetrieveMultipleResponse)

If retrieved.BusinessEntityCollection.BusinessEntities.Length > 0 Then

   Dim entity As New DynamicEntity

   Dim retrievedEntity As DynamicEntity = CType(retrieved.BusinessEntityCollection.BusinessEntities(0), DynamicEntity)

   For i = 0 To retrievedEntity.Properties.Length - 1

      If retrievedEntity.Properties(i).Name = "[property name I know must be updated]" Then

      update property...


and so on...

Open in new window

Question by:touch-base

Accepted Solution

Biffster007 earned 500 total points
ID: 21789762

If you know the entity that you'll be working with why don't you create an instance of that than you'll have access to all the fields??


Author Closing Comment

ID: 31466858
I'd been hunting for an obscure property or method that might return ALL columns regardless of content but I'll now follow your suggestion! Thanks.

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

These days socially coordinated efforts have turned into a critical requirement for enterprises.
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now