Regarding API in NAV 2018 (Purchase Order, Sales Order)

sulav.thapaliya@agile.com.np

I am trying to use sales order and Purchase order API in NAV 2018. I have been able to pass the data in header using postman. But I do not see any line items while getting the data from NAV. Is there any process on viewing the line items in JSON format?

pradi

Are you using the standard purchase order & sales order page or have you customized a new page for the API?

sulav.thapaliya@agile.com.np

I have created a purchase order API page and it's listpart page from purchase header and purchase line.I have manage to pass the data in header only but I am getting confused on how to pass the data in line.

Juhl

You do multiple calls. First header then lines.
https://docs.microsoft.com/en-us/dynamics-nav/fin-graph/api/dynamics_create_salesorderline

foo_bar

Hi Sulav,

you can do deep inserts trough the navision API, see following post for info regarding your custom page:
https://forum.mibuso.com/discussion/72423/api-deep-insert-not-working-in-custom-entity


info regarding deep insert:
https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/webapi/web-api-basic-operations-sample#section-3-create-related-entities-deep-insert

Regards,

foo

wait

To see the line items you need to expand them when you do GET
ex: http://{{url}}/{{service}}//API/beta/companies({{companyId}})/SalesHeader?$expand=SalesLine

wait

To pass data into the line you just use JSON array. The body would look something like this.
ex:

{
"number": "123456"
"salesLine": [
{
"number": 123456,
"lineNumber": 10000
}
],
}