XML and Spreadsheet

Hi,

Just one question.
Is it possible to use a spreadsheet in order to save an XML?
Here is what i have in entry
File Name:
test.xml
File Extension:
xml
Mime Type:
application/xml
File Size:
54.3 kB

This file is ok but i Would like to use a spreadsheet in order to allow an automatic download of the file.
There is no XML option in a spreadsheet…
Thanks a lot!

when using a spreadsheet using CSV file format,
I have :
“<?xml version=""1.0"" encoding=""UTF-8"" standalone=""yes""?>

<api_version>0.4.8</api_version>

/results>
/root>”

The " in the beginning and in the end of the file not allow to use the XML file directly

Hi @herrT15 :wave: Sounds like you have an XML file already that you’re trying to get readable by a spreadsheet, right? If so, you could do something like this:

This turns this sample spreadsheet into a regular table:

Would that work for you? :slight_smile:

I m gonna try it!
Thanks!
Is there a way to download the XML file?

Your solution is ok but in my case I would like to download the XML in XML format

I have the following output from the http request
Capture d'écran 2023-09-15 154823

I just would like to be able to automatically launch a download from the navigator.
usually i am using a spreadsheet but in fact no xml option is available for xml in spreadsheet…

Hi @herrT15 :wave: I’m not too clear on what you’re looking for - you don’t want the XML to be converted to a spreadsheet, but you want the XML file instead? :thinking: Can you share your workflow as well as what version of n8n you’re on, and if you’re on n8n cloud or self-hosting?

Yes sure.
I have a post webhook connected to httprequest. The request is ok. I just would like to download the results through the webhook instead of the result being displayed in the browser.

It looks like you’re self-hosting, I believe - you could use the Write Binary File node to take care of this :slight_smile:

1 Like