Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 468
  • Last Modified:

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

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...
      crmServ.Update(retrievedEntity)
and so on...

Open in new window

0
touch-base
Asked:
touch-base
1 Solution
 
Biffster007Commented:
Hi,

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??

Che,
MH
0
 
touch-baseAuthor Commented:
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.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now