Solved

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

Posted on 2008-06-13
2
462 Views
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...
      crmServ.Update(retrievedEntity)
and so on...

Open in new window

0
Comment
Question by:touch-base
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 9

Accepted Solution

by:
Biffster007 earned 500 total points
ID: 21789762
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
 
LVL 1

Author Closing Comment

by:touch-base
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.
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
I showed you how to use console view (HERE (http://www.experts-exchange.com/articles/18379/Getting-Started-and-Using-the-Salesforce-com-Console.html)) -– but how do you set it up on the admin side of Salesforce? Note that you have to have Admin leve…
The viewer will learn how to use and create keystrokes in Netbeans IDE 8.0 for Windows.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

751 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