How to use raw spreadsheet binary in expression?

Questions
1

Describe the issue/error/question

I am trying to create a ticket using the osTicket API, which supports adding attachments into the ticket via JSON: Tickets — osTicket 1.17.1 documentation

However, I am unsure how to read the raw Binary data of my CSV into the attachment field. When I try to specify using the input from the previous Spreadsheet node it just populates the file with Output output instead of the actual data.

What is the error message (if any)?

Please share the workflow

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 0.203.1
  • Database you’re using (default: SQLite): Postgres
  • Running n8n with the execution process [own(default), main]: own
  • Running n8n via [Docker, npm, n8n.cloud, desktop app]: K8s
2

Just expanding on this, I tried to get the data using a code node however the examples provided for the previous function node no longer work.

Would appreciate it if someone can tell me the new method on how to properly get the binary data buffer from the previous node

3

Solved:

If there’s a better / more efficient way to do this, please let me know! However, this is working.

1 Like
4

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