Automate/ Real-time the Dashboard

[Olivia_Rose]

Hi Experts,

I have created a dashboard which extracts data from an excel file. Now I want to automate that by extracting that data from Azure DB(Original data source)  to my dashboard. 

1. What is the correct way to do that?

2. Creating an API how can I do it?

3. How do I reload/ refresh that data again and again? 

Note: The original data source is Azure DB. Usually I download that excel data from an interface which by selecting the specific date range. Then downloads the .csv file and update the data to the data location which use as path for the created dashboard. But now I want to automate this process. 

I would be much obliged if you can help me.😊  Any new ideas or suggestions are welcome.!

[JandreKillianRIC · Accepted solution]

Hi @Olivia_Rose 

You will need to create a connection to the AzureDB. 

Then you can set a reload schedule on the application - Click the 3 dots "on the application" > Reload Schedule 

This will give you 1 hour reloads, If you need a faster reload time like every 30 minutes you can check this link to change the reload schedule using the Qlik API. 
https://qlik.dev/apis/rest/reload-tasks/

Why do you need to create a API? (Your point 2 on the question) 

Regards Jandre

[Olivia_Rose]

@JandreKillianRIC 

           Thank You.!☺️