Error while querying salesorderline using OData

(0) Share

Report

Posted on by vannamani77

417

Hi,

I am facing the below error while querying salesorderline using OData.

Error:

The EDM instance of type '[Microsoft.Dynamics.DataEntities.SalesOrderHeader Nullable=True]' is missing the property 'SalesOrderLine'.

Code:

var salesOrdersWithLines = d365Client.SalesOrderHeaders.Expand("SalesOrderLine").Where(x => x.SalesOrderNumber.Equals("SO022288")).Take(5);

foreach (var salesOrder in salesOrdersWithLines)
{
Console.WriteLine(string.Format("Sales order ID is {0}", salesOrder.SalesOrderNumber));

foreach (var salesLine in salesOrder.SalesOrderLine)
{
Console.WriteLine(string.Format("Sales order line with description {0} contains item id {1}", salesLine.LineDescription, salesLine.ItemNumber));
}
}

Below is the screen shot showing sales order line for SO022288 in D365FO

Pls help.

Categories:

Data Integration

All responses (1)

Answers (0)

shaneooo 5 on at

Like (0)

Report

RE: Error while querying salesorderline using OData

This question is a couple months old now but I ran into a similar issue recently. D365 v10.0 pu24.

I had the same error using OData APIs for PurchaseOrderHeader joining to PurchaseOrderLines via `Expand`. But if I used PurchaseOrderHeadersV2 joined to PurchaseOrderLinesV2, then it worked! Perhaps SalesOrderHeadersV2/SalesOrderLinesV2 would work for you as well. Or perhaps a later Platform Update or hotfix fixes this?