REST Post Multipart Form-Data + File Upload Issue

[whaleyl]

I’m having trouble correctly formatting multipart form-data to be sent as the body of a REST Post request along with a single file upload.

I’ve managed to get the Post request to correctly send in Postman with the required key/value pairs and a test file:

However, when attempting to replicate this in SnapLogic I am unsuccessful.

I’ve managed to correctly map the key/value pairs in a mapper, and have created the following JSON in a JSON generator using my mapped values:

I’ve used my “entity” object as the HTTP entity in my Post request, and pointed to a local test file for upload in my REST Post snap:

Is my approach to compiling the form-data correct, or no?

[dwhite]

Looks like you’re giving the entity JSON, a target server expecting form-data isn’t going to know what to do with that. Try formatting your entity like

‘key1=’ + $yourData1 + ‘&key2=’ + $yourdata2

Do it right in the entity setting of the snap.

Also, looks like your setting for Single File Upload: Multipart Content-Type is not set correctly. This field is for the MIME type of the file you’re trying to post, so when it gets formatted by the snap into a multipart request, it knows how to describe the file. So using “multipart/form-data” like you have set in the screenshot is not going to work.

It looks like you’re posting an xlsx file. So in your case you can either use the specific mime type for the file “application/vnd.openxmlformats-officedocument.spreadsheetml.sheet” or preferably the generic binary stream content type “application/octet-stream”. By doing that you let the target server know what kind of file you’re posting.

Try making those changes and see what your results are.

[whaleyl]

Thank you very much for the help and feedback, I’ve updated my pipeline with your requested changes.

The new HTTP entity is formatted as follows within the Post snap:

I’ve also changed the content type for the upload file to be “application/octet-stream”, and for the sake of testing am referencing the same file for upload in both Postman and SnapLogic. I’ve also set the file key to be the same as I’ve set it up in Postman:

I’m actually now getting a 200 back from the Post snap in SnapLogic, but the response back from my target endpoint is empty as compared to Postman.

Here’s the response back from SnapLogic:

And here’s the expected response as seen in Postman:

Based on your recommendations and from what I’ve shared, is my Post snap now setup correctly? At this point I feel like I’m overlooking some small detail. Any extra help is appreciated.

[dwhite]

In your response in SnapLogic, what http headers are you getting back?

Also, what http headers are you sending in postman request?

[whaleyl]

Here are my headers I’m sending + getting back in Postman:

And here are my headers I’m sending + getting back in SnapLogic: