Read excel attachment file from Outlook

[GeorgeAlex]

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.

[JordanB]

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