Forum Discussion

ricardoTyson's avatar
ricardoTyson
New Contributor II
7 years ago

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

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 bu...
pipeline
ricardoTyson's avatar
ricardoTyson
New Contributor II
7 years ago

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's avatar
aleung
Contributor III
7 years ago

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's avatar
    Fernando
    New Contributor
    4 years ago

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

    • dmiller's avatar
      dmiller
      Former Employee
      4 years ago

      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.