MS CRM 4.0. FetchXML returned columns even if they are empty

Thus, it seems that using FetchXML does not return a column if there is no data for it in CRM.

For example:

<fetch mapping="logical" count="50">
<entity name="contact">
    <attribute name="contactid" />
    <attribute name="emailaddress1" />
    <attribute name="firstname" />
    <attribute name="jobtitle" />
    <attribute name="lastname" />
    <attribute name="mobilephone" />
    <attribute name="parentcustomerid" />
    <attribute name="telephone1" />
    <filter>
        <condition attribute="parentcustomerid" operator="eq" value="94bf630f-b364-de11-8f1d-001cc02e75b4" />
    </filter>
</entity>

However, the returned XML is as follows

<resultset morerecords="0" paging-cookie="&lt;cookie page=&quot;1&quot;&gt;&lt;contactid last=&quot;{86805DB5-E06B-DE11-81EE-001CC02E75B4}&quot; first=&quot;{7CBC9B9A-E06B-DE11-81EE-001CC02E75B4}&quot; /&gt;&lt;/cookie&gt;">
<result>
    <contactid>{7CBC9B9A-E06B-DE11-81EE-001CC02E75B4}</contactid>
    <emailaddress1>tom@xxx.org.uk</emailaddress1>
    <firstname>tommy</firstname>
    <jobtitle>Dude</jobtitle>
    <lastname>Smith</lastname>
    <parentcustomerid yomi="" name="Tom bike shoppe" dsc="0" type="1">{94BF630F-B364-DE11-8F1D-001CC02E75B4}</parentcustomerid>
</result>
<result>
    <contactid>{86805DB5-E06B-DE11-81EE-001CC02E75B4}</contactid>
    <emailaddress1>jason@xxx.org.uk</emailaddress1>
    <firstname>jason</firstname>
    <lastname>Finch</lastname>
    <parentcustomerid yomi="" name="Tom bike shoppe" dsc="0" type="1">{94BF630F-B364-DE11-8F1D-001CC02E75B4}</parentcustomerid>
</result>

The 2nd entry has no job title, and none of the entries has a mobile phone number, for example. This makes it difficult to bind this data to data controls.

So basically my question is: is it possible to get CRM to return these fields with a null or null value?

+3
source share
2 answers

In short, no.

, , , , XML?

+2

, API FetchXML BusinessEntity RetrieveMultiple.

+1

Source: https://habr.com/ru/post/1713642/


All Articles