Add fields from two different tables in API page

(0) Share

Report

Posted on by Sujan Khadka

I have to add two different fields on one API page. let's say one from the employee table and another from the default dimension. How can I achieve this?

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 81,711 Super User 2025 Season 1 on at

Like (0)

Report

RE: Add fields from two different tables in API page

Hi, or you create a normal page, get the data on OnOpenPage trigger, and publish it in the Web Service.

Hope this helps as well.

Thanks.

ZHU
Suggested answer

Inge M. Bruvik 1,021 Moderator on at

Like (0)

Report

RE: Add fields from two different tables in API page

There is an example here you can follow as long as there is a relation between the tables:

docs.microsoft.com/.../devenv-develop-custom-api

If there is no releation you have to add code to the OnAfterGetRecord trigger to retrieve the data you need from the other tables.
Suggested answer

Marco Mels on at

Like (0)

Report

RE: Add fields from two different tables in API page

Hello,

I assume you need to create a page which has the fields added to it and from there create the API page.

Thanks.