Inserting records via web services

(0) Share

Report

Posted on by James ODonnell

Hey all,

So I have been messing around with the API and exposing different pages to pull data from. As a test I tried to send a post request to the opportunity comments page as it seemed simple.

I get an error that the page doesn’t support insert. I tried extending the page with editable true to no avail.

I get that there are some tables they would rightly disallow inserts, updates or deletions, such as GL entries, or anything posted really.

If I made my own page referencing the same table would I be able to post data to it? Or would I need to make my own table and page for that?

Or am I way off and I can totally post to the comments page, I’m just doing it wrong.

Lastly is there a page that shows table/page properties so I know which ones I can fully interact with?

thank you so much for any guidance you can offer and thank you for reading this long winded question haha

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

JAngle 133 on at

Like (0)

Report

You might want to review how the standard api pages work. Majority include triggers to handle all the CRUD operations: github.com/.../pages

It’s a few years old now but I still find this blog helpful: community.dynamics.com/.../how-to-create-custom-apis-for-business-central-even-from-macos

Was this reply helpful? Yes No
Verified answer

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

Like (0)

Report

Hi, you can try table 2000000138 “Page Metadata”.

https://yzhums.com/22845/

This is a system table for viewing all page information in BC.

And for standard apis in BC, hope the following will help.

https://yzhums.com/6117/

Thanks.

ZHU

Was this reply helpful? Yes No
James ODonnell 5 on at

Like (1)

Report

Thank you so much for the info, been going through it over the weekend. I wish I had asked this question a week ago haha. Have a great day!

Was this reply helpful? Yes No
James ODonnell 5 on at

Like (0)

Report

Just in case anyone else comes to this question. I found something that helped so much. In addition to the resources linked in the comments, I found out that if, while you are in VS Code you can few the source AL for any table, page, report, etc.

Just start an AL project and reference the table, page, etc you want to see like so:

pageextension 50131 Test extends "Opportunity Card"

{

}

Now if you click anywhere in "Opportunity Card" and press F12 it will open the AL for that page. Really helpful if you are wondering what is going on behind the scenes.

Was this reply helpful? Yes No