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

sulav.thapaliya@agile.com.np · 2019-06-13

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 · 2019-06-17

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 · 2019-06-17

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 · 2019-06-17

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

foo_bar · 2019-06-18

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 · 2019-06-21

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 · 2019-06-21

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
}
],
}

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

Answers

Categories