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

Serial Number API Webservice

(1) Share

Report

Posted on by LF-16052033-0

526

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)

Suggested answer

Judy Microsoft Employee on at

Like (0)

Report

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 95,720 Super User 2025 Season 2 on at

Like (0)

Report

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