Report on External DB via API Call?
Comments
-
Hey all,
Heres my situation, I see you can create reports based on native Decisions elements and also a table that youve integrated with, but how can I also make a call to view the report of that external table Ive integrated with?
-
Hey yourself!
So, were assuming here that we have a data source in which were able to grab our information from yes? Otherwise, Ive included a link below which guides you on integrating with an external database table:
Now, if youre trying to have this be accessible via API call, well need the following items:
- A Flow with [b]Fetch Entities [/b]and a [b]Form[/b]
- The [b]Form [/b]that contains an Advanced Data Grid
- The [b]Fetch Entities [/b]step will fetch the external data which will be tossed into the advanced grid
Our finished product should look something like this:
[img]att2[/img]
Once weve got this configured and working as expected, we should be able to right click the flow that calls this information and navigate to:
[i]Run [Advanced] > Integration > View Integration Details[/i]
[i]
[/i]
A new window will pop up and make sure its Set Up as a UI/Form, not a service. The generated link will be able to be opened or referenced by your external user/front end and it should bring up the report like so![img]att1[/img]