Strange differences between FetchXml using RetrieveMultiple as opposed to xrmToolbox

(0) Share

Report

Posted on by Chevva

My very simple FetchXml query just needs three attributes from the contact entity:

If I run this in xrmToolbox's FetchXml tester, the results are:

">
  
    Abraham McCormick
    10
    cv11 6ur
    {25A17064-1AE7-E611-80F4-E0071B661F01}

However, running the exact same query through RetrieveMultiple, I get:

7128.x.png

Where did address1_composite come from? What might I be doing wrong?

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

address1_composite is the compilation of your address1_x fields. I'm not sure why it behaves differently. If you don't need that field you can just go through collection and remove it.

Was this reply helpful? Yes No
Suggested answer

Johao Larios 1,795 on at

Like (0)

Report

Hello there,

I think it is because how the addresses field works. Could you share the query that you are using in the retrieve multiple ?

However, as mentioned by Andrew, this should not affect you.

regards,

Was this reply helpful? Yes No
Chevva 95 on at

Like (0)

Report

Thanks for your feedback.

It's the exact same query that I included, i.e. querying fullname, address1_line1 & address1_postalcode.

I can easily remove address1_composite from the collection (which is what I assume xrmToolbox is doing as it's not appearing in its results) but the generic FetchXml routine at the core of my process needs to handle any user-defined query. In this case the logic blindly concatenates the results into a CSV string, which doesn't look too good!

Interestingly, if I simply query address1_composite on its own, I receive address1_composite, address1_line1, address1_postalcode and contactid

I don't want contactid either, which I assume is included in the results because it appears in the filter condition?

Was this reply helpful? Yes No
Suggested answer

Johao Larios 1,795 on at

Like (0)

Report

Yes, you are right. They will always appear as you mentioned.

Regards,

Was this reply helpful? Yes No
Chevva 95 on at

Like (0)

Report

Yes, no alternative other than to filter out the results, excluding everything that wasn't explicitly requested by an <attribute name"xxx"/>

Was this reply helpful? Yes No

Join the conversation

Community site session details

Strange differences between FetchXml using RetrieveMultiple as opposed to xrmToolbox

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Strange differences between FetchXml using RetrieveMultiple as opposed to xrmToolbox

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates