Create Sales Order Lines using Logic App Connector

(1) Share

Report

Posted on by Nic1993

Hello,

I'm using the Cronus test business central instance to test my Azure Logic App connector.

I have successfully used the Business Central connectors to create a sales order, retrieve details of that order and get the details of a particular Item which I intend to add to that order.

However, I am struggling to add an Item (Sales Order Line) to a Sales Order. I am getting back Bad Requests from the Business Central API.

ErrorCode: BadRequest  The key 'documentId' does not match a key for the resource 'Sales_Order_Line_Entity'.\r\nclientRequestId: c53000c0-61b5-4c5c-a505-2d3fea5226e0"

Here is my connector:

Here is the input of my POST to the API:

I added the documentId as a key in JSON and set its value to the GUID of the documentId that is returned when getting the details of the sales order I just added.

I've tried the endpoint using Postman and I'm able to create a line with the same details and sales order so it appears the details are correct.

Is there anything obvious I've missed?

Thanks,

Nic

Categories:

I have the same question (0)

All responses (2)

Answers (0)

Seiji Momoto 75 on at

Like (0)

Report
I am facing the same problem and still trying to find the best place to escalate this. I would just like to post here how I do workaround by using the Flow HTTP connector:

At first, create the sales order header from the default Business Central connector

Afterward I retrieve the GUID of the sales order from the "Compose" connector as its inputs

Call the standard API from the Flow "HTTP" connector and provide the GUID of the sales order from the previous step

Once it ran successfully, it would give you a sales header line Id:

I hope this workaround would be some of help to you. And I also hope strongly that the standard Business Central connector can be used as it is. I am still looking for where can I work on this problem.

Thank you,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Can you help me here to design logic apps for sales order using d365fo connector and pasrse via json format whose output should be successful creation of sales order header and lines in d365fo UI

Was this reply helpful? Yes No