Small and medium business | Business Central, N...

Serial Number API Webservice

(1) Share

Report

Posted on by LF-16052033-0

605

Hello,

We want to build a Power BI report that will gather information from business central using an webservice API. We want to enter an invoice number to search the customer, item no, description, serial numbers, and quantities.

We are not able to find anything in the API's where we can utilize the Serial Numbers of an item in an way.

Can someone point us in the right direction or suggest an alternative on how to achieve this?

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Judy Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

You need to do some customization to add the serial number. please refer to the helpful old thread for the same topic:

https://community.dynamics.com/forums/thread/details/?threadid=eb5b41af-6771-4634-bfef-49454f59466f

https://community.dynamics.com/forums/thread/details/?threadid=5b74f909-d6bc-4cb0-b99c-67119500d11a

Best Regards,

Judy

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 101,122 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, Power BI can directly read data in Web Service (Odata).

The simplest method is to publish the related tables to the Web Service.

For example,

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No