Skip to main content
Solved

Call Subroutine through Indicium and return table

  • 21 June 2024
  • 4 replies
  • 56 views

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 

 

 

This topic has been closed for comments

4 replies

Userlevel 7
Badge +23

Hey Blommetje,

I would have expected this:

GET requet on Table-valued function

Configuration:

Code:

 

Can you share more of your configuration?

Userlevel 5
Badge +13

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. 

Userlevel 7
Badge +23

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

Userlevel 5
Badge +13

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