Odata API filter

Hi,

I am new at commcare so i would like to ask you about the Odata API filter. I checked all the possible topic and documents but i couldn't find it or i might missed it. What i would like to do is i would like to filter my data though API before importing it to Power BI or Excel while using the Power BI/tableu integration. For example this is my link and i would like to filter the beneficiary with ID 0001, is this possible?

https://www.commcarehq.org/a/sss-1/api/v0.5/odata/cases/ba81a699e6631f8900d3416894xxxxxx/feed&Beneficiary_ID=0001

are you saying that you wish for your filters to be dynamic or just to filter a feed?

cause you CAN create the feed with a filter - and it can be relative

Hi, I have created some Odatafeeds where i have 50-60 columns for different columns, some dashboards needs some columns but not all so that i would like to filter the column in web query level before importing to Power BI. Example, I would like to choose the following columns in query level, but whatever i tried CommCare odate feed always presents the same data by ignoring the ?$select command, https://www.commcarehq.org/a/sss-1/api/v0.5/odata/cases/ba81a699e6631f8900d3416894xxxxxx/feed?$select=Beneficiary_ID, Name, surname, age

I have checked this documentation (Basic Tutorial ยท OData - the Best Way to REST) but it didn't work, Tried this one(OData Query Options | Mendix Documentation) did not work.

Is there any way to filter columns or values in query or API level before importing it to Power BI to decrease the load time? I have been checking any testing all possible solutions but couldn't find anything for months.

I do not think that this is possible but would love to see it happen