Skip to main content
Solved

Call Subroutine through Indicium and return table


Blommetje
Forum|alt.badge.img+13

Hi, 

We have created a subroutine, that returns a table. The input params are employee_id and Date. 

When I call this routine through SQL it works and returns the rows as expected. 
When I call this this Subroutine through Indicium (with Postman) with a GET - I do get a 200 - but no data. It does not matter if I send use params are not. 


How can I have Indicium return the table /results? 

Much appreciated!

Blommetje 

 

 

Best answer by Mark Jongeling

Hey Blommetje,

I would have expected this:

GET requet on Table-valued function

Configuration:

Show content

Code:

 

Can you share more of your configuration?

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

4 replies

Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Administrator
  • 3959 replies
  • Answer
  • June 24, 2024

Hey Blommetje,

I would have expected this:

GET requet on Table-valued function

Configuration:

Show content

Code:

 

Can you share more of your configuration?


Blommetje
Forum|alt.badge.img+13
  • Author
  • Partner
  • 210 replies
  • June 24, 2024

Yes, that seems to be ok. Stupid question, but is this something from the latest version? 
I'm currently on platform 2023.3.   I don't see any significant changes in the setup, so I expect a similar output. 


Mark Jongeling
Administrator
Forum|alt.badge.img+23

This is indeed 2024.2, but I would not expect any difference with 2023.3. Can you recreate my example and test this?


Blommetje
Forum|alt.badge.img+13
  • Author
  • Partner
  • 210 replies
  • June 25, 2024

Thank you @Mark Jongeling  

I recreated your sample and it works. After some testing it also works with our Subroutine.
We didn't call it correctly (url with quotes and &). And perhaps something else.. after checking everything. 

Thanks! 

Blommetje


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