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.

[dmiller]

Welcome @Fernando

Do you happen to have an error view set up for this Snap? You’ll be able to see the error_entity field message there to see if that gives you any additional details.

[robert_parks]

I ran into something simillar – we had a file we had to stage on a WEBDAV and it seems we should use a REST, but we were able to send the file to the API using the FileWriter with the account set up as Basic Authority.

[ricardoTyson]

robert_parks:

I ran into something simillar – we had a file we had to stage on a WEBDAV and it seems we should use a REST, but we were able to send the file to the API using the FileWriter with the account set up as Basic Authority.

thank you for taking the time to reply! although I don’t know if that could work for me as I have to use a token for security but it’s nothing I can’t try 😀

[Fernando]

“error_entity”:
“{“code”:400,“message”:“A CSV file must be provided in data field”}”

[ddellsperger]

it looks like you’ve not specified the file that’s being uploaded in the “Single file upload: File” field, that’s 2 above the one you have blacked out.