Generating PDF report from latest data from external API
Basic need: need to generate a report (pdf) for a person.
Data location: for various reasons, we are thinking to expose the data through and API instead of direct database access and somehow pass also the data filter (person identifier) to the API call.
Challenge: how to make sure the data is the latest data and not originating from a previous data extract?
I've been playing with ODATA connector and also creating custom Web Data Connectors using taco tools, but unfortunately none of these does support live extract.
Scenario:
need to generate a report for a person (A) and all it's related data
once a report generation is requested, instruct tableau to fetch the data from an external API for Person A
export a worksheet/dashboard into a PDF
Any thoughts?