Email Connector for Weekly Email with Multiple Attachments & Updated Date on Attachment Name
I am trying to set up an email connector that pulls one csv attachment from a weekly email. The email contains 3 attachments, two of which are csv and only one of these is the one I need. Both CSV files contain nearly the same name and the name of the attachments starts with the week of the statement, so it changes weekly. Here is an example:
11-28-23 Statement.csv
11-28-23 Statement Breakdown.csv
I'm running into two issues here, I need the 11-28-23 Statement csv file and next week, the file name will be 12-5-23 Statement. I can't figure out how to incorporate wildcards in the attachment name expression or another alternative to get the correct attachment.
Best Answer
-
@lbg3222 You can use regex in the Attachment Name Expression field to specify which file you want to import. If you want to keep the file that ends in "Statement.csv" then you can use this: .*Statement\.csv
The ".*" at the beginning acts as a wildcard to allow any date prefix.
0
Answers
-
@lbg3222 You can use regex in the Attachment Name Expression field to specify which file you want to import. If you want to keep the file that ends in "Statement.csv" then you can use this: .*Statement\.csv
The ".*" at the beginning acts as a wildcard to allow any date prefix.
0 -
@MichelleH thank you. I'm no longer getting an error on the attachment name but now it's saying the file found is the wrong type. This is likely due to the fact that the pdf file attachment has the same name? Any idea on how to fix this?
0 -
@MichelleH yes, I did verify that both of those are set up correctly:
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive