Skip to main content
Solved

Get domain definitions from opendata API

A
Forum|alt.badge.img+2

Hello

I have a customer that uses the openapi/odata functionality to update reporting tools (powerBI)
I however have certain fields in my tabels which are domains with elements. Is there any way to find these values from the openapi/odata calls?

 

 

Best answer by Freddy

Anne Vries wrote:

Hello

I have a customer that uses the openapi/odata functionality to update reporting tools (powerBI)
I however have certain fields in my tabels which are domains with elements. Is there any way to find these values from the openapi/odata calls?

 

 

 

No easy way, but you can get it through the IAM api's. 

First get gui ID vai /indicium/iam/iam/i_ui_gui_appl/ (filter on gui_appl_alias)

and then via /indicium/iam/iam/i_ui_elemnt (filter on gui_appl_id and dom_id) ..  you get the db_value what you get now and the elemnt_id_transl (what you want). 

View original
    Did this topic help you find an answer to your question?
    This topic has been closed for comments

    Freddy
    Forum|alt.badge.img+16
    • Freddy
    • Thinkwise Local Partner Brasil
    • October 12, 2023
    Anne Vries wrote:

    Hello

    I have a customer that uses the openapi/odata functionality to update reporting tools (powerBI)
    I however have certain fields in my tabels which are domains with elements. Is there any way to find these values from the openapi/odata calls?

     

     

     

    No easy way, but you can get it through the IAM api's. 

    First get gui ID vai /indicium/iam/iam/i_ui_gui_appl/ (filter on gui_appl_alias)

    and then via /indicium/iam/iam/i_ui_elemnt (filter on gui_appl_id and dom_id) ..  you get the db_value what you get now and the elemnt_id_transl (what you want). 

    LEF — Lift. Empower. Fulfill. [lef.digital]
    Arie V
    Community Manager
    Forum|alt.badge.img+12
    • Arie V
    • Community Manager
    • October 12, 2023

    @Anne Vries we encountered the exact same issue and plan on adding a View on IAM in our own application that retrieves the Domain Element names and Translations. That hopefully simplifies it a bit for our BI team and is a bit less complicated than the suggestion by @Freddy, since we include the correct application filtering already in the View.

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings