Email Connector: Unable to figure out why my regex not working
Dear DOMO community,
I am at a loss and don't understand why in my email connector the regex .*PANAY.* will work when email subject is
Fw: MSPANAY GROUP |IBITEM AND AVAIL - 9/8/2023 7:17:56 am
but it fails when the email subject is
Fw: MSPANAY GROUP | Ibitem, Price Change and Avail - 8/28/2023 7:54:21 AM
When checking regex expressions, it should find both of them.
Anybody have any idea what I might have done wrong ?
Appreciate any help you can provide.
Saskia
Best Answer
Answers
-
@MichelleH : Thank you for responding.
I can confirm that nothing else was different. Sender same, same file type. The only difference was the subject name and also this email contained one additional file attached to it.
The alert in the history specifically refers to the regex and was as follows:
Domo is ready, but an email was received that did not pass the regex filters and was not processed. Invalid Subject Fw: MSPANAY GROUP | Ibitem, Price Change and Avail - 8/28/2023 7:54:21 AM, regex is .*PANAY.*
PS: this email was eventually processed by changing the subject to "Fw: MSPANAY GROUP |IBITEM AND AVAIL - 8/25/2023 7:17:56 am" as a workaround, so the issue was definitely with the regex.
0 -
@MichelleH - no that did not fix it. I'm afraid I am getting the same alert as per below
Domo is ready, but an email was received that did not pass the regex filters and was not processed. Invalid Subject FW: MSPANAY GROUP | Ibitem, Price Change and Avail - 8/28/2023 7:54:21 AM, regex is .*PANAY.*
The only fix is to actually change the subject to be "Fw: MSPANAY GROUP |IBITEM AND AVAIL - 8/25/2023 7:17:56 am"
So you think it should work with my regex and the issue might be somewhere else ?
0 -
@MichelleH - I did your test recommendation and confirm that with the same rules it also doesn't work. I will contact Domo Support.
Thank you for all your help !
0 -
Hey @SaskiaV , don't know if this was resolved for you- however, Domo Email Connectors do not support Forwarded emails as it is unable to read the attachment. The Email must be sent directly to the connector.
0 -
@tanayakakade It has been resolved by DOMO support. The issue was actually with the length of the subject title. As soon as it was longer than 20+ characters, the regex failed. DOMO fixed this bug.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 623 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 690 Automate
- 177 Apps
- 455 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive