Liquid FetchXML returns empty object

(0) Share

Report

Posted on by Community Member

Hi all,

I had working an API called from Portals (managed on Portals > Web templates). It has been working until a couple of minutes ago when I changed some field on an entity's form.

Now, whenever I try to return any data from any entity it returns nothing. I am trying this with "Role" entity (just as an example):

% fetchxml feed %}
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" returntotalrecordcount="true">
  <entity name="role">
    <attribute name="createdon" />
    <order attribute="createdon" descending="true" />
  </entity>
</fetch>
{% endfetchxml %}{
  "totalcount": {{ feed.results.total_record_count }}
}

I also tried with {{ feed }} just for testing and nothing. Any suggestions?

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

- Matt Bayes - 890 on at

Like (0)

Report

Hi Martin,

Make sure you have the correct Entity Permissions setup for the entities you are trying to retrieve through the fetchxml. I have found that no records will be retrieved if you do not.

Also, I am unsure if it just got copied incorrectly but you are missing the open brace for your fetchxml tag.

Matt Bayes

Was this reply helpful? Yes No
Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

Hi,

Please double check your implementaion as per this blog - dyn365apps.com/.../dynamics-365-portals-liquid-templates-part-3-retrieve-data-using-fetchxml

Was this reply helpful? Yes No
Suggested answer

Aric Levin - MVP 30,190 Moderator on at

Like (1)

Report
The code looks good, so I would check the Entity Permissions to see that you have read access to the Role entity.

I would also make sure that you have the proper curly brackets {}.

Looks like it's missing from the beginning, and I am not sure that you need it after the endfetchxml:

{% fetchxml feed %} <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" returntotalrecordcount="true"> <entity name="role"> <attribute name="createdon" /> <order attribute="createdon" descending="true" /> </entity> </fetch> {% endfetchxml %} "totalcount": {{ feed.results.total_record_count }}

Hope this helps.

Was this reply helpful? Yes No