Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I am new to Dataiku. Can we read an excel sheet from outlook email.
I need to access the excel report that comes in an outlook email box and load the data into a datawarehouse.
Hi @GeorgeAlex,
If I am understanding you correctly and your goal is to programmatically retrieve Outlook emails with attachments, you would probably need to use the Outlook REST APIs. You could create a Python script to download email attachments that fit your criteria or create a scenario that polls for existing or new emails with attachments. To get support on how to use the Outlook REST APIs, you will probably want to reach out to Microsoft, since their API is managed by them.
If you have any questions, please let us know.
Thanks!
Jordan Burke
Dataiku
where did this end?
I am on the same train at the moment.
@JordanB are you saying i need designer ,capabilities to utilize python from within Dataiku to be able to use email attachments as datasets in Dataiku?
@munoj9 if your goal is to programmatically retrieve Microsoft 360 email attachments from within DSS, you will need permission to write code in DSS.
You could do the following which might not be the best way depending on your requirements but would be quick to implement:
Depending on your requirements you might be able to add the date from email to the excel file using PowerAutomate to build a historical table.
The one caution is if the file changes schema and that requires manual intervention to get is working again.
Let us know what you end up doing. Godspeed!
I love that and currently doing it so! thanks!
Do you think i would be able to set something in Dataiku that appends each file as it is sent? i think that date feature may help me do that.
Thanks for your input by the way!