Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Reading URL / hyperlink from e-mail subject

Reading URL / hyperlink from e-mail subject 3 years 6 months ago #14482

  • Fran
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 6
  • Thank you received: 0
A scheduled job that runs and sends a report via email. However, the email body contains the hyperlink not the actual attachment. Because of this, I would need to click and download the file from there. Can we use ETL to automate the process?

Please Log in or Create an account to join the conversation.

Reading URL / hyperlink from e-mail subject 3 years 6 months ago #14490

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7606
  • Karma: 33
  • Thank you received: 418
This can be easily done by parsing saving message body into variable, parsing variable using calculations and downloading data from location stored in the variable.

See the pictures below.





See wiki for working with variables
Mike
Attachments:

Please Log in or Create an account to join the conversation.

Reading URL / hyperlink from e-mail subject 3 years 6 months ago #14499

  • Fran
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 6
  • Thank you received: 0
Thanks Mike! I never thought of this.

Fran

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 144 guests and no members online