Skip to main content
Solved

How do i use expand in indicium?


Forum|alt.badge.img+17

How do I use the expand functionality in indicium? Whatever i try i always end up with invalid odata url. 

I tried creating an expand statement based on the documentation, either the documentation is incorrect or I am missing something here. 
https://docs.thinkwisesoftware.com/docs/indicium/api#expand

the community wont allow me to add the link I use so i added a picture. I tried on tablename, id name, lookup name. Nothing seems to work. 


 

 

Best answer by Anne Buit

Based on the documentation, the following URLS should work in your case:

kerry?$expand=transl_gitaar 

to select all columns from both kerry and gitaarr

kerry?$select=valuut&$expand=transl_gitaar($select=nameidx) 

to select valuut from kerry and nameidx from gitaarr

View original
Did this topic help you find an answer to your question?

4 replies

Anne Buit
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 638 replies
  • December 6, 2022

The so-called ‘navigation-property’ for expands uses a prefix on the last reference column.

To get directly to the look-up table (in this case, gitaarr), you can use lookup_gitaar. If the display would be ‘further up the chain’, you can short-circuit using transl_gitaar. Either would work in this case.

kerry?$expand=lookup_gitaar($select=nameidx)

 

 


Forum|alt.badge.img+17
  • Author
  • Moderator
  • 762 replies
  • December 6, 2022

This works, does this mean the documentation is incorrect? Since the documentation states this, which both don't seem to work. : 

 

 


Anne Buit
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 638 replies
  • Answer
  • December 6, 2022

Based on the documentation, the following URLS should work in your case:

kerry?$expand=transl_gitaar 

to select all columns from both kerry and gitaarr

kerry?$select=valuut&$expand=transl_gitaar($select=nameidx) 

to select valuut from kerry and nameidx from gitaarr


Forum|alt.badge.img+17
  • Author
  • Moderator
  • 762 replies
  • December 6, 2022

They both work, I guess once you know how it works the documentation makes sense. Thanks. 

 


Reply


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