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

Filling/inserting custom table data using provided API services

(0) Share

Report

Posted on by Maro9595

105

Hi all,

Am new in using API in business central, can any one please help me with link or materials to go through on

-Inserting data in to custom table using API example given the link https://jsonplaceholder.typicode.com/users I want to utilize that list and fill my custom table

am using OnPrem BC

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (1)

Report

RE: Filling/inserting custom table data using provided API services

For this you will need to use the http client that you have available in the AL.

learn.microsoft.com/.../httpclient-data-type

Take the respons you get there and load it into a json object

learn.microsoft.com/.../jsonobject-data-type

Parse the json object and then insert records into your desired table

Was this reply helpful? Yes No
Suggested answer

Govinda Kumar 2,304 Moderator on at

Like (1)

Report

RE: Filling/inserting custom table data using provided API services

Hi Maroh Kimaro,

I have found a video that explains how to insert data into a custom table using API in Business Central, and it uses the same example provided in the link you shared. Here is the link to the video

I hope this information is helpful.

Regards.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,307 Super User 2025 Season 2 on at

Like (1)

Report

RE: Filling/inserting custom table data using provided API services

Hi, I recommend the two videos of Erik below, I hope they can also help you.

How to make a simple API call with a json reply in Business Central

https://www.youtube.com/watch?v=D5jzrgl1EP0

JSON in AL for beginners - Essential development knowledge for Business Central

https://www.youtube.com/watch?v=so7_bOxp9V4

Thanks.

ZHU

Was this reply helpful? Yes No
Maro9595 105 on at

Like (0)

Report

RE: Filling/inserting custom table data using provided API services

Thank you ZHU

Was this reply helpful? Yes No
Maro9595 105 on at

Like (0)

Report

RE: Filling/inserting custom table data using provided API services

That was wonderful video thank you, though I stacked on final stage

Error

Unable to convert from Microsoft.Dynamics.Nav.Runtime.NavJsonValue to System.Int32.

Was this reply helpful? Yes No
Suggested answer

Govinda Kumar 2,304 Moderator on at

Like (0)

Report

RE: Filling/inserting custom table data using provided API services

There's an error in the code or a mistake.. when you are parsing json.. you should try to add a debugger and see where your code is breaking..

Regards

Was this reply helpful? Yes No