SFTP integration connectors - create new file

[miketimchenko]

Hi team,

I am working on an integration to export data into sftp-server. I created an integration connector SFTP and an application integration. According to my task I should create a new folder weekly and add new files. There is now any issues to create a new folder but I can't pass the error with a new file. I use task "Connector", entities "Create". Please, let me know white parameters I should setup and what are recommended values.

Viewing: connectorInputPayload

{ "FilePath": "/my_folder_path/", "Filename": "my_file_name.my_file_format", "IsDirectory": false, "FileSize": 0.0 }

Viewing: ErrorMessage

{"error":{"code":400,"details":[{"@type":"type.googleapis.com/google.rpc.ErrorInfo","metadata":{"cause":"Invalid INSERT statement","connection_type":"SFTP","entity_type":"Root"}}],"message":"Unable to create entity.","status":"FAILED_PRECONDITION"}}

Thank you

Mike

[divishagupta]

Hi Mike,

In order to create a new file, you need to use the Upload Action. Instead of selecting Entities, select Actions, and there you'll be able to see Upload Action. 

Connector Task --> Connection --> Actions --> Upload

You can find more details and usage examples here.