Hello,
I do a salesOrder export til BC, with the BC Default API - EcomOrders. To keep it simple I just have 1 order and 1 orderline in DW and only 2 active table mapping, see screenshot.
The order is created in DC and I can see that the field [OrderIntegrationOrderId] is set in the DW db.
But after this it fails with "message": "'PATCH' requests for 'salesOrders' of EdmType 'Collection' are not allowed within Dynamics 365 Business Central OData web services.".
I guess it is the table mapping "EcomOrderLines - salesOrderLines - Item" that is failing
Here is the log
2025-08-22 09:31:34.8879|DataIntegration|INFORMATION|HttpRestClient: 'https://api.businesscentral.dynamics.com/v2.0/xxxx-x-xxxx-xxxx/Sandbox/api/v2.0/companies(xxxx-xxxx-xxxx-xxxx-xxxxxxx)/salesOrders' invoked with PATCH and '{"currencyCode":"DKK","customerNumber":"12345678","externalDocumentNumber":"ORDER338","sellToAddressLine1":"Erik Eriksen Vej","sellToAddressLine2":"","sellToCity":"Vejle","sellToCountry":"DK","sellToPostCode":"7100","discountAmount":0}'
2025-08-22 09:31:34.9141|DataIntegration|ERROR|Endpoint error: {
"error": {
"code": "BadRequest_MethodNotAllowed",
"message": "'PATCH' requests for 'salesOrders' of EdmType 'Collection' are not allowed within Dynamics 365 Business Central OData web services."
}
} Status: MethodNotAllowed Headers: Transfer-Encoding:chunked,Server:Microsoft-HTTPAPI/2.0,Access-Control-Allow-Headers:Origin, X-Requested-With, Authorization,Access-Control-Allow-Origin:*,Access-Control-Allow-Credentials:true,ms-correlation-x:xxxxxxx.xxx.xxx.xxx,mise-correlation-id:xxxx-x-xxxx-xxxx,Access-Control-Expose-Headers:Date, Content-Length, Server, OData-Version;ms-correlation-x,request-id:96011e3d-138c-4255-890a-3fd4ea70a6d8,X-Content-Type-Options:nosniff,Strict-Transport-Security:max-age=31536000; includeSubDomains,Date:Fri, 22 Aug 2025 07:31:33 GMT,Content-Type:application/json; charset=utf-8
2025-08-22 09:31:34.9153|DataIntegration|ERROR|Error Url: https://api.businesscentral.dynamics.com/v2.0/xxxx-x-xxxx-xxxx/Sandbox/api/v2.0/companies(xxxx-xxxx-xxxx-xxxx-xxxxxxx)/salesOrders. Response Error: {
"error": {
"code": "BadRequest_MethodNotAllowed",
"message": "'PATCH' requests for 'salesOrders' of EdmType 'Collection' are not allowed within Dynamics 365 Business Central OData web services."
}
}. Status response code: MethodNotAllowed
2025-08-22 09:31:34.9240|DataIntegration|INFORMATION|System.InvalidOperationException: {
"error": {
"code": "BadRequest_MethodNotAllowed",
"message": "'PATCH' requests for 'salesOrders' of EdmType 'Collection' are not allowed within Dynamics 365 Business Central OData web services."
}
}
at Dynamicweb.DataIntegration.Providers.ODataProvider.ODataWriter.Write(Dictionary`2 Row)
at Dynamicweb.DataIntegration.Providers.ODataProvider.ODataProvider.RunJob(Job job)
2025-08-22 09:31:34.9243|DataIntegration|ERROR|Error: { "error": { "code": "BadRequest_MethodNotAllowed", "message": "'PATCH' requests for 'salesOrders' of EdmType 'Collection' are not allowed within Dynamics 365 Business Central OData web services." } } Stack: at Dynamicweb.DataIntegration.Providers.ODataProvider.ODataWriter.Write(Dictionary`2 Row) at Dynamicweb.DataIntegration.Providers.ODataProvider.ODataProvider.RunJob(Job job)
2025-08-22 09:31:34.9292|DataIntegration|ERROR|Job failed.
2025-08-22 09:31:34.9313|DataIntegration|INFORMATION|Finished job - EcomOrders.
2025-08-22 09:31:34.9317|DataIntegration|ERROR|Batch failed.
