OneDrive Spreadsheet to upload json data to FTP

I am new to N8N. I am having an issue uploading the json data to my ftp site. the connection does transfer dummy data, but not the data spreadsheet to json data upload.

  • The Read OneDrive Spreadsheet node displays the correct info
  • The FTP sys the node was successful but the ftp json file is empty.

Is there a array or loop i need to use to insert the data to the json file on the ftp site? Any recommendation to get this workflow to work?

No errors, successful upload.

Information on your n8n setup

  • n8n version: Latest
  • Database you’re using (default: SQLite):
  • Running n8n with the execution process [own(default), main]:
  • **Running n8n via [Docker] Self Hosted

Cheers mates

I think you have to move the JSON to a binary file before uploading it with ftp. (I haven’t used the ftp node yet :grimacing:)

To convert JSON to binary, you can use the “Move binary data” node:

@FelixL I am still not seeing any output from that node. Looks like its not passing. any other suggestions?

@arronrobles set the Mode to “JSON to Binary”

Just made sure that it really works as I’ve never used the ftp node before, here my workflow i used to test it:

The only problem with my test workflow is, that each item gets written independently, but with the same file name.
That means that only the last written item gets saved.

To put all items into one file you can aggregate all items into an array with the “Item Lists” node like this:

I am not getting any output from my Move Binary node.

You just have to set the Mode of the “Move Binary Data” node to “JSON to Binary”:

@FelixL Affirmative! Thanks my dude. That worked. Cheers mate

@arronrobles Glad I was able to help :slightly_smiling_face:

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.