D365 OData: How to filter PO lines by status?

(1) Share

Report

Posted on by Andrei

Hi,

I was told in other thread, that D365 F&O OData does not support $filter inside $expand, so I cannot filter PO lines by status in my request for PurchaseOrderHeadersV2 endpoint.
I would like to discuss how it can be done.

1. Is it true, that here are NO any ways to filter PO lines in request for PurchaseOrderHeadersV2 endpoint?

2. As I understand, the only way to have it done is make 2 requests:

Req 1: Get PO filtered headers from PurchaseOrderHeadersV2.

Req 2: Get filtered lines for headers above from PurchaseOrderLinesV2

and then combine results of two request.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (5)

Answers (1)

Andrei 92 on at

Like (0)

Report

D365 OData: How to filter PO lines by status?

Thank you, Martin.

Was this reply helpful? Yes No
Martin Dráb 236,160 Most Valuable Professional on at

Like (1)

Report

D365 OData: How to filter PO lines by status?

No, composite data entities can't be used over OData. Anthony means a normal entity using both headers and lines as its data sources.

Was this reply helpful? Yes No
Andrei 92 on at

Like (0)

Report

D365 OData: How to filter PO lines by status?

Thank you Anthony,

Do you mean this: https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/develop-composite-data-entities#export-a-composite-entity

Was this reply helpful? Yes No
Verified answer

Anthony Blake 2,683 Super User 2025 Season 2 on at

Like (1)

Report

D365 OData: How to filter PO lines by status?

Just to add, another option is a custom Data Entity to return your combined dataset.

Was this reply helpful? Yes No
Anthony Blake 2,683 Super User 2025 Season 2 on at

Like (1)

Report

D365 OData: How to filter PO lines by status?

Hi

I think you are correct, also consider reversing the order if the lines query is more selective.

Anthony

Was this reply helpful? Yes No