Dynamics Community Forum Thread Details

Liquid & fetchxml to return CRM data

Hi, I am trying to get from an entity "adx_entity_form" portal, I already created a web template to add some Liquid to fetch the results but I am getting nothing.

First, I verified all the fields where accessible from the xRM web API: https://my.instance/api/data/v9.0/adx_entityforms?$select=adx_name,adx_entityformid

Then, I create the web template XML:

{% fetchxml query %}
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
	<entity name="adx_entityform">
		<attribute name="adx_name" />
		<attribute name="adx_entityformid" />
		<order attribute="createdon" descending="true" />
		{% if request.params['id'] %}
		<filter type="and">
		  <condition attribute="adx_entityformid" operator="eq" value="{{ request.params['id'] | xml_escape }}" />
		</filter>
		{% endif %}
	</entity>
</fetch>
{% endfetchxml %}{
	{% for ef in query.results.entities %}
	  "{{ ef.adx_entityformid }}": "{{ ef.adx_name }}"{%- unless forloop.last -%},{%- endunless -%}
  {% endfor %}
}

This returns an empty object, it doesn't reach the for loop.

Any suggestions on this code or something else?

Kindly regards

Quick Links

Leaderboard