Hi,
I have two Dataverse virtual tables. When I join these tables using fetchXML I see error on the page:
{
"results":
[
Liquid error: Exception has been thrown by the target of an invocation.
]
}
and error on logs: "Sequence contains no matching element"
I have permissions to both tables and can get data from each of them separately.
{% fetchxml feed %}
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
<entity name="lux_propproperties" >
<attribute name="lux_propertyname" ></attribute>
<attribute name="lux_mspropertyid" ></attribute>
<link-entity name="lux_mktgid_sources" from="lux_propertyid" to="lux_mspropertyid" alias="id_sources2" link-type="outer">
<attribute name="lux_name" ></attribute>
</link-entity>
</entity>
</fetch>
{% endfetchxml %}
{
"results":
[
{% for item in feed.results.entities %}
{
"Name":"{{ item.lux_propertyname }}",
"lux_mspropertyid": "{{ item.lux_mspropertyid }}",
"lux_name": "{{ item.lux_name }}",
}{% unless forloop.last %}, {% endunless %}
{% endfor %}
]
}
My join fields have simple text format with the same length and look like GUID.
I will appreciate if you could help find what's wrong.
We are facing the same issue with link type "not any".
Any hint would be appreciated 😉
Lucas001
60
Super User 2025 Season 2
Fubar
55
Super User 2025 Season 2
surya narayanan
35