FetchXML through JS

(0) Share

Report

Posted on by sweb

117

Hello, I have some data that I need from some specific dataverse tables.

Problem is I need to query a table to get some data and use that data to query other tables.

Is there any way to do that? If I normally use FetchXML, all of them run an the same time, I can not use the result of one in another, or at least I don't know how.

I thought maybe something with JS, if possible.

Thank you.

Categories:

Customize & extend

I have the same question (0)

All responses (4)

Answers (1)

Christian Leverenz 1,214 on at

Like (0)

Report

Hi @sweb ,
in case of that kind of requirements, i create a liquid template which uses fetchxml to make the queries. Either you make several "services" out of that or you create a bigger template with several fetches. Never tried but i think, you can use results of a fetch in the next fetch.
https://learn.microsoft.com/en-us/power-pages/configure/liquid/template-tags#fetchxml

For the parameter you can just use request.params.<whateveryouparameteris>
https://learn.microsoft.com/en-us/power-pages/configure/liquid/liquid-objects#request

When creating that kind of things, just create a liquid (=web) template, assign it to a pagetemplate and IMPORTANT: swicth off "render header and footer" and then create a page with that pagetemplate. The liquid will be renderered as it is and you can create for example a jsonoutput.
Hope this points in the right direction,
Christian

Was this reply helpful? Yes No
sweb 117 on at

Like (0)

Report

Hi @chleverenz , I don't know if I explained correctly.
I have multiple queries, all of them get executed at the same time, so I don't have any results to start with.
My first query returns some data, I need some of that data to execute the second query.
Have read both your links, I don't seem to understand the solution.
Can I have more details?

Now the site is slow, one query has 7000+ results. I save the data to a JS variable and use the data from the other queries to filter out the one with 7000+ and get the data I need. As I said, site is so slow, takes 1-2 mins to load, sometimes even crashes.

Was this reply helpful? Yes No
Verified answer

oliver.rodrigues 9,368 Most Valuable Professional on at

Like (1)

Report

Why not using the Portals API?

On the click/select of each record you run the additional queries.

Does that make sense?

Was this reply helpful? Yes No
sweb 117 on at

Like (1)

Report

Thanks @OliverRodrigues, had no idea about the API, it's exactly what I need, I thought the only way to get data is through FetchXML.

Was this reply helpful? Yes No