Display linked entity from FetchXML in JSON

[Lucas001]

Hello everyone,

I am using the FetchXML Builder and the query shows exactly what I want.

{% fetchxml testXML %}
<fetch>
  <entity name="test_table">
    <attribute name="attr1" />
    <attribute name="LookUpField" />
    <attribute name="attr3" />
    <attribute name="attr4" />
    <link-entity name="linked_Table" from="xyz_id" to="name" alias="nameXYZ" visible="true">
      <attribute name="nameXYZ" />
    </link-entity>
  </entity>
</fetch>
{% endfetchxml %}

I want to retrieve a LookupField. But whysoever there's nothing displaying inside the LookUpField when I display it in a JSON.

I tried different combinations as below:

[
{% for item in testXML.results.entities %}
 {
   "Test1" : "{{ item.LookUpField }}",
   "Test2" : "{{ item.nameXYZ }}",
   "Test3" : "{{ item.LookUpField.nameXYZ }}"
 }{% unless forloop.last %}, {% endunless %}
{% endfor %}
]

Inside the FetchXML Builder it's working fine, but the fetchXML inside my pagetemplate seems to have an issue.

Do I need to give the FetchXML additional access or something as it is not even displaying the GUID neither the Name which is referenced inse the LookUp.

Has somebody come across something like that or know how I can display the linked name attribute of the lookup column?

[ragavanrajan]

Hi @Lucas001 

For the lookup column table, hope you have set enough table permissions and assigned web roles properly.  Please check all your table permissions 

Hope it helps.
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

[Lucas001]

Hi @ragavanrajan,

what I don't get. I can display the needed data in a view in a form or anything else. As I created the FetchXML witht he builder and it is working fine inside its UI as well. Copying that code and just trying to display it inside a JSON doesn't work.

Is there anything else one has to give permission when using FetchXML with a LookUp Column?

[Lucas001 · Accepted solution]

I finally found a solution.

https://www.newdynamicllc.com/portal-pages-how-to-display-an-entity-list-using-fetchxml-and-liquid-c...

[
{% for item in testXML.results.entities %}
 {
   "Test1" : "{{ item.['yourAliasFieldName.yourNameofTheFieldInsideTheRelatedTable']}}"
 }{% unless forloop.last %}, {% endunless %}
{% endfor %}
]

It is difficult to find something like that when there's nowhere a documentation.

@ragavanrajanmaybe you could submit that to the product team and ask them to include it into the documentation.

[ragavanrajan]

sure @Lucas001 

Thanks for the answer. I will pass the info and you can see some updates in the docs soon. 

Thanks again.