Skip to main content
Solved

Get domain definitions from opendata API


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

2 replies

Freddy
Forum|alt.badge.img+16
  • Thinkwise Local Partner Brasil
  • 531 replies
  • Answer
  • 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). 


Arie V
Community Manager
Forum|alt.badge.img+12
  • Community Manager
  • 1021 replies
  • 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.


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