- Posts: 604
- Thank you received: 82
O365 Data Reader Zero Messages
- bruce.gibbins
- Topic Author
- Offline
- Platinum Member
-
Less
More
1 month 6 days ago - 1 month 6 days ago #22938
by bruce.gibbins
O365 Data Reader Zero Messages was created by bruce.gibbins
Hello
I was wondering if you would consider adding a checkbox to the O365 Mail Data Reader to abort cleanly if there is no mail?
I typically use the O365 Reader Package Action Object. However, in a very basic ETL workflow I directly scheduled a Transformation which simply read an email message if it existed and moved it into another folder and wrote a record to a database table. But because there may be no messages, we see failures in the execution log. However, in this case there may be no mail to read, and the task should just end successfully.
I then added the same Transformer to a package hoping to capture the transformation status. But because the reader treats no messages as an error, it aborts the transformation in error.
If there was a check box on the Reader itself then this false positive on an error when no messages to read could be avoided.
Cheers
I was wondering if you would consider adding a checkbox to the O365 Mail Data Reader to abort cleanly if there is no mail?
I typically use the O365 Reader Package Action Object. However, in a very basic ETL workflow I directly scheduled a Transformation which simply read an email message if it existed and moved it into another folder and wrote a record to a database table. But because there may be no messages, we see failures in the execution log. However, in this case there may be no mail to read, and the task should just end successfully.
I then added the same Transformer to a package hoping to capture the transformation status. But because the reader treats no messages as an error, it aborts the transformation in error.
If there was a check box on the Reader itself then this false positive on an error when no messages to read could be avoided.
Cheers
Last edit: 1 month 6 days ago by bruce.gibbins.
Please Log in or Create an account to join the conversation.
- Peter.Jonson
-
- Offline
- Platinum Member
-
4 weeks 5 hours ago #22970
by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic O365 Data Reader Zero Messages
I do not think there any need for additional check box
We just need to make sure that it works the same way as the rest of the readers.
(They do not fail when no data was found)
We just need to make sure that it works the same way as the rest of the readers.
(They do not fail when no data was found)
Peter Jonson
ETL Developer
Please Log in or Create an account to join the conversation.
3 weeks 3 days ago #22971
by admin
Mike
ETL Architect
Replied by admin on topic O365 Data Reader Zero Messages
Just letting you know that your suggestion was implemented in the latest release
Here are the details
www.etl-tools.com/articles/major-release...ocessor-6-4-0-0.html
Please let us know if it works as expected
Here are the details
www.etl-tools.com/articles/major-release...ocessor-6-4-0-0.html
Please let us know if it works as expected
Mike
ETL Architect
The following user(s) said Thank You: bruce.gibbins
Please Log in or Create an account to join the conversation.