Forum Discussion

DekkerNick's avatar
DekkerNick
Frequent Visitor
2 years ago

salesOrderLines API from Business Central gives error

When I would like to retrieve salesOrderLines from Business Central in PowerBI, I get the following error message. 

DataSource.Error: Dynamics365BusinessCentral: Aanvraag mislukt: De externe server heeft een fout geretourneerd: (400) Ongeldige opdracht. (You must specify an Id or a Document Id to get the lines. CorrelationId: 763e20e8-0a35-49a1-9ffd-ec50e146a050.)
Details:
DataSourceKind=Dynamics365BusinessCentral
DataSourcePath=Dynamics365BusinessCentral
Url=https://api.businesscentral.dynamics.com/v2.0/ACCEPTATIE/api/v2.0/salesOrderLines?company=Schut Papier

This is the source. 

let
Bron = Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, null),
ACCEPTATIE = Bron{[Name="ACCEPTATIE"]}[Data],
#"Schut Papier" = ACCEPTATIE{[Name="Schut Papier"]}[Data],
#"v2 0" = #"Schut Papier"{[Name="v2.0"]}[Data],
salesOrderLines_table = #"v2 0"{[Name="salesOrderLines",Signature="table"]}[Data]
in
salesOrderLines_table