Beginners Advent Challenge #3
Santa is a poor man, he has no Excel available so he has to import the data as CSV file. Santa also has Christmas wishes, an office suite.
With a tiny VB routine in a loop Santa downloads all the files from the list. Then the downloaded zip file are added to the MailMessage attachments of the Send SMTP Mail Message activity.
Dim WebClnt As WebClient = New WebClient
Dim Target As String
Dim TargetArr() As String
Try
TargetArr = Source.Split("/".ToCharArray())
Target = TargetArr(TargetArr.Length - 1)
WebClnt.DownloadFile(Source & "?dl=1", Target)
Catch ex As Exception
Console.WriteLine(ex.Message)
End Try
Dim Attach As Attachment = New Attachment(Target)
MailMessage.Attachments.Add(Attach)
And last but not least everything is sent via SMTP. Yes, not via Outlook, Santa does not have this office application either. This has the disadvantage that the attachment does not contain the individual zip files, it contains only one EML file which contains the zip files.
Santa checks this with an EML viewer.
Santa is happy again. With a cheat sheet to @Anna_Maziarz solution and the hints of @SamiKiran it was possible to pass this challenge correctly. Many thanks to both