topic Re: Read csv from Email attachment (Outlook 365) in Connectivity & Data Prep

Read csv from Email attachment (Outlook 365)

RFPMartins — Tue, 14 Mar 2023 17:01:41 GMT

Hi all,

I'm on Qlik SaaS and I need to consume a csv file that sits on an Outlook 365 email account.

Can I do this using a Qlik Sense app or Automation?

I've connected to the email box using a Qlik Sense app and the Outlook 365 connector, but I can't seem to read or store the attachment, it comes as a octet-stream.

Thanks!

Re: Read csv from Email attachment (Outlook 365)

Frank_S — Mon, 20 Mar 2023 22:06:15 GMT

Hi @RFPMartins

Did you follow the steps in the following instructions accurately.

After authenticating your connection to Outlook365, were you able to see the needed fields? Were you able to insert any of the fields into the load script?

Did you try a different attachment such as xlsx? Were the results the same?

Creating a connection and selecting data

Hopefully the above will guide you in the right direction.

Kind regards...

Re: Read csv from Email attachment (Outlook 365)

RFPMartins — Tue, 21 Mar 2023 10:02:52 GMT

Hi @Frank_S ,

Thanks for the reply!

I can access the email, the issue is that I can't find a way to access the contents of the attachment using the connector.

I can read the to, cc, bcc, subject, even the list of attachments, but I can't seem to get to the file contents.

Re: Read csv from Email attachment (Outlook 365)

Frank_S — Wed, 22 Mar 2023 19:48:49 GMT

Hi @RFPMartins

Try this

https://support.microsoft.com/en-us/office/trusted-documents-cf872bd8-47ec-4c02-baa5-1fdba1a11b53

If the above doesn't help, perhaps start a support request. Reading attachments should work according to your help site on this topic.

https://help.qlik.com/en-US/cloud-services/Subsystems/Integrated_Web_Connectors_help/Content/Connectors_QWC_BuiltIn/Integrated%20connectors/Outlook-365-Connector-integrated.htm

Kind regards...