Skip to main content
Answer

Call Subroutine through Indicium and return table

  • June 21, 2024
  • 4 replies
  • 70 views

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:

Code:

 

Can you share more of your configuration?

This topic has been closed for replies.

4 replies

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

Hey Blommetje,

I would have expected this:

GET requet on Table-valued function

Configuration:

Code:

 

Can you share more of your configuration?


Blommetje
Forum|alt.badge.img+13
  • Author
  • Partner
  • 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
  • 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