Skip to main content
Question

Data from DB View through REST API


Forum|alt.badge.img+2

Hi,


What would be the best way to fetch data from a custom database View through a REST endpoint?

So far our best approach is to create a QuickReport that fetches data from the DB View and call this trough the QuickReport projection endpoint.

But we are wondering if there is another/better way.

 

We also experimented a bit with custom actions on a new projection, but no luck.

 

Regards Jeppe

3 replies

Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • 4 replies
  • August 17, 2022

Hi Jeppe,

I dont have an answer but we are currently looking at options to do this in order to expose data from a CLU alongside a stand LU within a single API call.

If you have moved forward I’d be keen to hear, and I will update this thread with whatever we learn.

Thanks,

Matt.


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Customer)
  • 1 reply
  • August 19, 2022

Hi Matt,

Thanks for commenting.

We haven't moved forward unfortunately. Our best bet to achieve this is still to use QuickReports.

Feel free to share any insight you might get.
We will do the same if we manage to find a better approach.
 

Regards, 
Jeppe


Forum|alt.badge.img+1
  • Do Gooder (Customer)
  • 1 reply
  • September 9, 2022

Hi Jeppe,
Hi Matt,

same here. Trying to get data of a table view via a REST Endpoint out of IFS. Had no luck until I found this thread and using an QuickReport as well now. Works fine but a more native solution would be better. 

If I found another way I’ll post it here and hope that you guys do as well.

Regards
Gökhan


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