Report on External DB via API Call?

Unknown

Report on External DB via API Call?

Unknown

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?

Unknown

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:

[url=https://documentation.decisions.com/docs/integrating-an-external-database-with-a-flow]https://documentation.decisions.com/docs/integrating-an-external-database-with-a-flow[/url]

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]