FetchXML from link entity twice

(0) Share

Report

Posted on by Community Member

I am trying to pull data from same linked entity twice like below:

I am attempting to do this to pull this entity twice joining on 2 different fields to get the country for billing and country for shipping. I can get it to pull the first alias, but not the second. What am I missing?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

ashlega 34,477 on at

Like (0)

Report

RE: FetchXML from link entity twice

Is it giving you an error? Where are you doing it(plugin/ssrs..)?

Is there a country record with the right name?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: FetchXML from link entity twice

Not giving me an error, but only pulling data from the first entity. The 2nd entity alias, it does pull from. Not sure what I am doing wrong.

Was this reply helpful? Yes No
Suggested answer

ashlega 34,477 on at

Like (0)

Report

RE: FetchXML from link entity twice

I'm still wondering where are you trying to run that fetch and if there are countries with the right names..

You can run fetchXml using webAPI.

Here is what I got (different prefix for the country entity, but, in general, just the same query I believe):

https://<ORG ROOT>/api/data/v8.2/salesorders?fetchXml=<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">

<entity name="salesorder">

<attribute name="name" />

<attribute name="customerid" />

<attribute name="statuscode" />

<attribute name="totalamount" />

<attribute name="salesorderid" />

<order attribute="name" descending="false" />

<link-entity name='new_country' alias='countrybill' to='billto_country' from='new_name' link-type='outer'>

<attribute name='new_code' alias='billcountry'/>

</link-entity>

<link-entity name='new_country' alias='countryship' to='shipto_country' from='new_name' link-type='outer'>

<attribute name='new_code' alias='shipcountry'/>

</link-entity>

</entity>

</fetch>

This, actually, shows two things:

- The query should work (highlighted line)

- If there is no match, you won't see those attributes in the result (the other line)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: FetchXML from link entity twice

Ok. I will try that out

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: FetchXML from link entity twice

Tried what you are showing. Maybe, I am not adequately explaining. I need both the shipcountry and billcountry on the same line. The link works partially. Since I need to do it for both the billto as well as the shipto, I am doing the link twice with differing alias and joining on the billto_country on one and shipto_country on the other. The problem I am facing is that is pulling it from the first link-entity alias, but not the second.

Was this reply helpful? Yes No
ashlega 34,477 on at

Like (0)

Report

RE: FetchXML from link entity twice

It seems to be the same kind of FetchXml I posted above (two links, two aliases) - you can see how different codes show up for the bill to and ship to.

Are you certain there is, actually, a billto/shipto country for those country names? If there is no match, you won't have those attributes in the resultset.

Was this reply helpful? Yes No