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?
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
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.