Home > Forum > General > REST API & OData queries

REST API & OData queries

2

01.12.2022

12:36

Hi all!

I noticed that OData support has been added to REST API 2022.1.4.xx.

I only found one document, which is located here: https://community.webcon.com/posts/post/odata-format-in-webcon-bps/346

This document is related to the usage of OData in PowerBI.

What we really need is the ability to filter views with OData and REST API. Is that one already implemented and if so, where can I find a documentation of that?

<PseudoCode>
/api/data/v4.0/db/{dbid}/applications/{appid}/reports/{reportid}?$select=...&$filter=...
</PseudoCode>

Thanks a lot in advance & best regards, Nik

Reply

Kamil Skrzypiec

02.12.2022

14:00

Kamil Skrzypiec

Hello Nikolaus,

We do not support OData filters on endpoints other than dedicated OData endpoints (the new ones with api/odata routing). For now, we do not plan to expand the rest of the api to handle OData queries, in the first place we wanted to focus on stabilization and adding missing functionalities to the api/odata/beta branch.

The article you linked is about Power BI, but these endpoints can be used on par with reporting ones. They return practically the same data. Only the configuration would be more difficult, because instead of using BPS mechanisms, you would have to build an appropriate filter query.

Best regards,
Kamil

Reply

Solution (0)

Helpful (0)

Wrong answer (0)