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?

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

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

Thanks.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

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

Was this reply helpful? Yes No