I want to know if I can fetch outlook (Microsoft 365) emails with attachments and save those attachments to new Airtable records. I can download the attachents in base 64, but seems I need the file content in a URL format if I want them in Airtable, and I don’t know how to transform it into the URL. Any ideas that need no extra paid tools? Thank you
Where are you stuck? did you manage to get the 3 M365 steps fine?
Watch Messges, List Attachments, Download an Attachment
if not, where are you stuck at?
I think I actually want something slightly different, I don’t want just the attachtments in Airtable, I want the contents like sender, subject and Message body too.
Currently Watch messages & List attachments seem to work, for download attachments I get the error “Missing value of required parameter ‘attachment’.”
and I have message ID and Attachment ID like you do in the 2 fields. I can tell you to make sure you create a good query in the first step. I have: HasAttachment:true
and monitor what comes out of the 2nd step, which is key to make the 3rd step work.
For the contents that are not attachment, you can use the airtable task or a google sheets task and map the output of the 1st module to a new row, with sender email and all that info you need.