Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2008-06-13
2
Medium Priority
?
467 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 2000 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

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

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

Salesforce.com’s Console is a great tool to view activities, leads, contacts, accounts and opportunities all in one screen. It is particularly effective during call blocks and working numerous activities at a time in a quick, repetitive fashion (suc…
Note: You must have administrative privileges in order to configure lead or case queues. Salesforce.com (http://www.Salesforce.com) is a cloud-based customer relationship management (CRM) system. It is widely used around the world by sales and ma…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.

721 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