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
Categories
- All Categories
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 970 Connectors
- 259 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 502 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 379 Beast Mode
- 21 Variables
- 487 Automate
- 104 Apps
- 379 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 319 Distribute
- 67 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 64 Community Announcements
- 4.8K Archive