Powerautomate Smartsheet Connection Question (Using HTTP Connection

GScottMiller

Hello!

I have medium to low experience with API connections, so I am mostly trying to make my flows based on guides I am finding online etc.

I have built a simple automation that when an email arrives on a shared inbox, that it adds a new row to a customer complaint (Case) tracker in smartsheet.

I want to parse the email that was received for any attachments (including inline attachments) and then also attach those to the newly created row.

I've created some HTTP API calls before, but they've been simple GET or PUT functions and I am stuck on this with the limited guides out there for this specific workflow

This is the power automate I've created at this time. I don't think my HTTP is formatted correctly. Does anyone here know a good place for me to look next? (or a good resource for me to find!)

Thank you!

Leibel S

@GScottMiller

Try as below, bolded to be replaced by the proper file type and file name.

-H "Authorization: Bearer token"

-H "Content-Type: application/msword"

-H 'Content-Disposition: attachment; filename="ProgressReport.docx"'

The body should be something like this, you probably don;t need to format this yourself, could be 'Current Item' is this already…

{ 
"$content-type": "application/pdf",
"$content": "base64string"
}

GScottMiller

@Leibel S

Thanks for helping me get further along here.
Are you suggesting I need to somehow convert whatever file it is into Base64 in here? Do you know how that is done in powerautomate?

Because right now I dont think I have anything mapped for the file contents itself (See attachment)