Sending CSV file from SFTP server to API (REST Post)

[ricardoTyson]

Hi fellows, I am trying to send a csv file from an sftp server to an api endpoint but I can’t make the REST POST to work, I keep getting error:400 from the api
I have tried 3 different pipelines but all of them get the same error
I tried 3 different ways to pass it the input:
the fisrt one I format the file i get form the sftp and transform it to a document

input:

error:

POST setting:

then I tried just to read it and put it right away though the binary to document

input:

error:

POST settings:

then I tried to just write it(not in the pipline underneath) and read it from the local file store from snaplogic but didn’t work either

error:

POST settings:

Hopefully someone will spot what I’ve been doing wrong because I’ve spent a lot of time triyng to get this right :c
pd.I already tried guiding myself with these two posts I found with no success:

REST Post Trying To Send a CSV File Designing Pipelines

restful_post_example.docx (314.4 KB) Hello Everyone. I am brand new to SnapLogic as well as brand new to RESTful API’s so please bear with me and not make fun of me too much. :slight_smile: I attached a document to help visualize what I am trying to do. I am just trying to do a proof of concept for a project using the REST Post snap to upload a CSV file but I cant get it to work and I was wondering if someone might be able to help point me in the right direction. Thanks in advance for your ki…

REST POST A File? Designing Pipelines

Seems like a silly question, but I have a pipeline with a REST POST snap like below which posts a file pulled directly from the SLDB filesystem and posts it to a URL, specifying an Upload File and Upload File Key. This seems to work fine… [works] But my file won’t really be coming from the SLDB filesystem, so I want to pretend my file is coming in via prior snaps in the pipeline and reference that in the REST POST using the HTTP Entity. So instead I’m loading the file separately and then run…

thank you in advance for reading.

[aleung]

@dwhite comment is correct. Here is what your pipeline should look like:

sFTP file reader > File Writer (local SLDB: tmp file) > REST POST (with mutipart) > File Delete (remove tmp file)

[ricardoTyson]

aleung:

@dwhite comment is correct. Here is what your pipeline should look like:

sFTP file reader > File Writer (local SLDB: tmp file) > REST POST (with mutipart) > File Delete (remove tmp file)

Hi thank you for replying, I have this :
Label*=InnovaZones REST Post
Service URL*=http://10...*:****/v1/innovazones
HTTP entity=(blank)
Batch size=(blank)
Show all headers(unselected)
Single file upload: File=…/shared/innovaZones_corrected.csv
Single file upload: File key=file
Single file upload: Filename to be used=innovaZones_csv_file
Upload transfer request type=chunked after encoding
Upload body type=Multipart form data
Single file upload: Multipart Content-Type= application/octet-stream
HTTP header:
Key=Content-Type Value=application/x-www-form-urlencoded
key=Authorization Value="Bearer " + account.access_token

and I only need this to connect through postman:

I swear I have read to death the doc of the snap but it haven’t worked so that’s why I feel I need to ask “is that snap well settled?” 😢
thank you again for taking the time to reply.

[aleung]

It sure looks like you already have it working in the 1st pipeline of this post. So it is just a matter of accepting you going to have to write the file locally then have an option to remove it for data security purpose.

[Fernando]

I don’t understand how to configure a REST Post. How to debug this error ?
Is it possible to have a sample of use ?