Skip to main content

Upload to the Box with ADF

  • June 7, 2024
  • 1 reply
  • 107 views

I cannot upload to the Box by calling API in the Azure Data Factory.
I can not use SDK and I got HTTP 400 error ,
“Malformed stream”
following is the Body that I created in the Azure pipeline:( it should be in JSON format)

@concat('--------------------------9fd09388d840fef1
content-disposition: form-data; name=“attributes”

{“name”:“testdev.xlsx”, “parent”:{“id”:“0”}}
--------------------------9fd09388d840fef1
content-disposition: form-data; name=“file”; filename=“testdev.xlsx”
content-type: text/csv

‘, variables(‘varFileContents’),’

--------------------------9fd09388d840fef1–
')

1 reply

rbarbosa Box
  • Developer Advocate
  • 553 replies
  • June 24, 2024

Hi @Shrpmn

Welcome to the forum!

I dont see anything particularly wrong with your request, however creating a upload request by hand is always tricky.

I wonder if Azure doesn’t have a method to make this easier, you might be missing the proper binary upload it self…

As an example, here is a cUrl log from an upload to box:

POST /api/2.0/files/content?fields=id%2Ctype%2Cname HTTP/2
Host: upload.box.com
User-Agent: curl/8.4.0
Accept: */*
Authorization: Bearer 1!k...PVWw.
Content-Length: 423429
Content-Type: multipart/form-data; boundary=------------------------i2ozkLjczzSHhtVvcYCBSQ

 

--------------------------i2ozkLjczzSHhtVvcYCBSQ
Content-Disposition: form-data; name="attributes"
{.  "name": "upload-test.png",.  "parent": {.    "id": "253757099719".  }.}
--------------------------i2ozkLjczzSHhtVvcYCBSQ
Content-Disposition: form-data; name="file"; filename="upload-test.png"
Content-Type: image/png

.PNG
......IHDR..............V......pHYs..........+.....<tEXtComment.
xr:d:DAF1d4MBsqY:26,j:5910270370129294276,t:24031514...w....iTXt
XML:com.adobe.xmp.....<x:xmpmeta xmlns:x='adobe:ns:meta/'>.    
   <rdf:RDF xmlns:rdf='http://www.w3.org/1999/02/22-rdf-syntax-n [w3.org]

....o..........M`f..}S!0-8..q.e.....s...2..[.....p./.Z..Q;...e.3
M..8u....=.xcJ!..L..B^.03..en..E.=.<....d.1....kO.F...p[[.......
...Wc.N..9..<...Gh.W.ke [gh.w.ke].....tE.g...o.;.8. .xz....:.H.\.S..}w+^..
.`P.........R.,Y.6y..4G.^#.....,%{.T...H3.s..'.g....V.R8...z&c0;
@.y._.....K...?.cP...4F..-x.E....O..O<..w.k.F..RZ.....VGQ..$4.].

#### Many more lines in binary ###

.....[...`>..x"..33P.7........~[...o.$z~S=.a.A.".<]8
.k.1,N.....f.A./....o.=cp.7.....c..w.<>*....N:$.....
o.......v..,...5..1..'...J]....z.U......w.>p..<....O
}......IEND.B`.
--------------------------i2ozkLjczzSHhtVvcYCBSQ--

Of course the binary is impossible to display as text, hence the dots.

Let us know if this helps.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings