Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] Extract attachment file from outlook 365

Hello,
I want to extract the file attachment outlook 365.
I tried to use the component and tHttpRequest and tFileInputMail but it is not working properly because I can not extract the txt file.
The tHttpRequest extract a file ". Mail» but the tFileInputMail can't retrieve a txt file.
However, if I connect directly to the mailbox via internet explorer, I can see that there is 2 mail with each attachment file.
Maybe I don't use the good solution ? If you have an idea ...
For information, before I was on Lotus notes and TPOP component and tFileInputMail worked well. But now, we've change and pass on Outlook 2010 0683p000009MA5A.png(

Thanks
Regards
Stef
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

The problem was solved by the network team.
In fact, they opened the port at the firewall for Pop server of Office 365.
I was able to again utiiser my TPOP component.

View solution in original post

9 Replies
Anonymous
Not applicable
Author

Hi,
TalendHelpCenter:tFileInputMail helps to extract standard key data from emails not .txt file.
Is your file attachment extracted by tHttpRequest .txt or .mail?
Best regards
Sabrina
Anonymous
Not applicable
Author

Hi Stef,
If nothing works for you, then there is an option of web scrapping using web automation tools.. eg. selenium.. this is handy tool when nothing works to fetch data..
vaibhav
Anonymous
Not applicable
Author

Hi Sabrina,
Yes my component tHttpRequest extract a file ". Mail" but when I want to use my tFileInputMail component, I have the following error :
Exception in component tFileInputMail_1
java.lang.NullPointerException
at integration_npai.test_0_4.Test.tFileInputMail_1Process(Test.java:2169)
at integration_npai.test_0_4.Test.tFileInputDelimited_2Process(Test.java:1734)
at integration_npai.test_0_4.Test.runJobInTOS(Test.java:2970)
at integration_npai.test_0_4.Test.main(Test.java:2500)
I would like to say that before, my job was working fine with a Notes mailBox.
And if I compare two ".mail" file : one from Outlook and an other from Note, the structure of the file is very différent ...

Regards
Stef
Jcs19
Creator II
Creator II

hi try to use TPOP component instead of httprequest
Anonymous
Not applicable
Author

Hi Jcs19,
Before I was uses a TPOP component.
But now, there is no pop protocol ...
Regards
Anonymous
Not applicable
Author

Now I have to connect to https://portal.microsoftonline.com and then go to Outlook ...
Anonymous
Not applicable
Author

Hi Stef_el,
It's welcome to open a workitem jira issue of DI project on Talend Bug Tracker.
Best regards
Sabrina
Anonymous
Not applicable
Author

The problem was solved by the network team.
In fact, they opened the port at the firewall for Pop server of Office 365.
I was able to again utiiser my TPOP component.
Anonymous
Not applicable
Author

Hi Stef_el,
Thanks for your feedback and sharing your experience with us. It's helpful.
Best regards
Sabrina