You’re offline. This is a read only version of the page.
86
I've pulled down all purchase invoices and purchase orders via the standard api's (endpoints purchaseOrders and purchaseInvoices), I used the ?$expand = purchaseOrderLines/purchaseInvoiceLines in order to get the respective lines. Is there a field that joins these two datasets? I can join on vendor,postingDate,itemNumber and variantCode but I'm left with some duplicates. I could identify these and weed them out with some SQL code, however I would suspect that there is a field in BC somewhere that allows me to join these two sets?
Thanks ZHU,
That blog was very useful, will bookmark for sure. It seems that I was mistaken however. There is a field in the purchaseInvoices service called orderNumber which links to the purchase order. I missed it because most of the records for this field are blank! I'm not sure how that could be as I thought there was almost always a purchase order associated with every purchase invoice.
cheers,
garydee
Hi, Could the following blog help you?
https://www.kauffmann.nl/2021/01/06/batch-calls-with-business-central-apis-3-tips-and-tricks/
When encountering such complex API processing, a relatively simple way is to create a new table (temporary) in BC, create a new page, and collect all the required data when it is opened. Then access this data in Odata.
Hope this will help.
Thanks.
ZHU
#1
Sohail Ahmed
2,655
#2
Mansi Soni
1,574
#3
YUN ZHU
1,453
Super User 2025 Season 1
Share
Report
All responses (
Answers (
