Add file to QB from Microsoft Flow

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered

I'm trying to run a MS Flow that posts a file to quickbase when a file is created in OneDrive for Business folder.

The file needs to be base64 encoded.

I can get the file to Quickbase but I cannot open it. This happens with Excel, or PDF's.

I'd like to get some thoughts out there on where I'm going wrong.

Here's a sanitized flow

Method HTTP POST 

*Uri https://mydomain.quickbase.com/db/bjpvjalec?a=API_AddRecord

Headers Quickbase-Action API_AddRecord Content-Type application/xml

Body:

<qdbapi> <udata>mydata</udata> <field fid="24" filename=" File name​"> ​base64(triggerBody())​ </field> <usertoken>myAuthenticationToken</usertoken> </qdbapi>

Photo of Scott Roache

Scott Roache

  • 80 Points 75 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 8,774 Points 5k badge 2x thumb
Hi Scott,

When passing the file into Quick Base does it show up attached to the record correctly? By not being able to open it do you mean when you click on the link you aren't able to download it to your desktop or device?
Photo of Scott Roache

Scott Roache

  • 80 Points 75 badge 2x thumb
Thanks for the reply. It's solved. But to answer-The file attached to the record correctly. I was able to download it but it wouldn't open-basically saying it was corrupt.

It was solved by removing the carriage returns in the flow body. Once I removed the carriage return the file was readable.