Pulling data to excel via dataiku API
Risto
Registered Posts: 9 ✭✭✭
Hi,
I have an excel file that needs to be updated monthly with new data.. I'd like to know if its possible to pull data directly from dataiku dataset to an excel sheet. My goal is automating the excel data update without manually exporting the data each time from dataiku to excel. I would make this data pull scheduled inside excel instead.
I have an API key made for that project in dataiku and I wonder if excel could use that to pull the data into a sheet?
Operating system used: Windows 11
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,043 Neuron
Hi, the following posts should help you do what you want:
https://community.dataiku.com/t5/Using-Dataiku/Excel-Export-with-custom-style/m-p/32962