Skip to main content
Answer

Get domain definitions from opendata API

  • October 12, 2023
  • 2 replies
  • 79 views
A
Forum|alt.badge.img+3

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

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). 

    Geurt
    Marius Korff
    This topic has been closed for replies.

    2 replies

    Freddy
    Forum|alt.badge.img+16
    • Freddy
    • Thinkwise Local Partner Brasil
    • Answer
    • October 12, 2023

    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 settingsAccessibility statement