Odata url ?$Filter for multiple filters

[PBE]

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/xxxxxx...?$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

[v-yalanwu-msft]

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.

[PBE]

Hi @v-yalanwu-msft 

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