Forum Discussion
Odata url ?$Filter for multiple filters
Hi
I am using odata url link from MS Business Central to Power query/ BI using the format
https://api.businesscentral.dynamics.com/vzzzzzzzzzzzzzzzz8-e2ffffffffff6/xxxxxxxxxxx/ODataV4/xxxxxxxxxxxx/GLPowerBI?$filter=Posting_Date gt 2022-01-01
It currently filters by Posting_Date gt 2022-01-01
I would like to add further filter --- G_L_Account_No in 101010 101020 101030 (these are text not numbers)
- Where G_L_Account_No is the field to filter on
- 101010 101020 101030 are the only values for the field I want to include
Ending up with something like ?$filter=Posting_Date gt 2022-01-01 gt 2022-01-01 and G_L_Acconut_No in (101010, 101020, 101030)
What is the correct term to use please?
Thank you
Pete
2 Replies
Hi, PBE ;
You could try it.
https://api.businesscentral.dynamics.com/vzzzzzzzzzzzzzzzz8-e2ffffffffff6/xxxxxxxxxxx/ODataV4/xxxxxx...?$filter=Posting_Date gt 2022-01-01 and G_LAccount_No in('101010','101020','101030')Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
Filtering OData Feeds - That NAV Guy
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Thanks for your reply. The code didn't work but the links look good and I'll see if I can work it out from them.
PBE
