Retrieve data with Liquid and FETCH XML

(1) Share

Report

Posted on by hubjes

Hello.

I have a problem with fetching data using fetchxml.
Some time ago it worked for me, now it works strangely.

Here is my code:

{% fetchxml params %}

</entity>

</fetch>

{% endfetchxml %}

{% for resultparams in params.results.entities %}

{% endfor %}

And as a result I get:

And this is data in the table:

So I retrieve the data from 'dyn365bc_parameter_name' and 'dyn365bc_params_test' (it's a GUID field).
I've done some tests and it always shows data from the first attribute I select to retrieve, no matter what kind of field it is and in addition it shows data from the GUID type field.
Do you have any idea why I can't show all attributes at the same time? I think the permissions in Power Pages and the field names are correct because I can retrieve data from any field, but only if it is my first attribute in the fetch xml.

Categories:

Customize & extend

I have the same question (0)

All responses (3)

Answers (1)

EmadBeshai 806 Moderator on at

Like (1)

Report

Hi @hubjes ,

Did you check your table permissions for this table?

If this post helps you with your problem, please mark this answer as Accepted Solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Verified answer

hubjes 48 on at

Like (1)

Report

Hi.
Permission was fine, I think the problem occurs when you try to use fetchxml multiple times for a specific table on the same website. When I use fetchxml only once per website, it works ok.

Was this reply helpful? Yes No
Christian Leverenz 1,214 on at

Like (1)

Report

Hi @hubjes,

i recenently was also using fetchXML agin after a long time and stumbled across a strange remark in the documentation ( https://learn.microsoft.com/en-us/power-pages/configure/liquid/template-tags#fetchxml ) : you shall not use selfenclosing tags. so, instead of <attribute name="harry"/> you should use <attribute name="harry"></attribute>

sounds a little bit strange,, but may be its serious now. You will always get the id if the entry as this is a specific attribute in the response.

Hope it helps.

Have fun,

Christian

Was this reply helpful? Yes No