Generate CSV file for download

Luck Kanthatham-2308338

We have an option in the endpoint to download the result as a CSV file.  How do I convert the JSON output into a CSV file for download?

Michael Udinski

Use the function set http header and define this as the header:

Content-Disposition: attachment;filename="example.csv"

(where example is the name of your csv file)

Luck Kanthatham-2308338

Thank you, Michael.  How do I embed the content of the csv file?

Michael Udinski

Can you elaborate on what you mean?

Luck Kanthatham-2308338

Actually, I was able to get the content embedded.  I just couldn't do it inside Xano when I clicked the "Download" button.

Now, the file that is returned is still in JSON.  This means that I will have to manually manipulate the content of the JSON into a comma-delimited file before returning.  Correct?

Michael Udinski

Take a look at this snippet for an example of also using the csv_create filter:

https://www.xano.com/snippet/ufiacxww/

Luck Kanthatham-2308338

Thank you so much.

Luck Kanthatham-2308338

My apologies.  I didn't see the csv_create filter in the documentation.

Luck Kanthatham-2308338

BTW, you may want to add "csv" to the search keywords.  These CSV filters didn't show up when I searched the documentation. Thank you.

Luck Kanthatham-2308338

Thanks to your help, I was able to create a generic function to convert a JSON array to a csv.  I am sharing the snippet here with others:

https://www.xano.com/snippet/WFSLV4nd/

Michael Udinski

 awesome!!

Riaan Backer

 - when a value contains a space (ex van staden) it gets enclosed ("van staden") with whatever you configure under the enclosure section under the CSV_Create filter. I have tried numerous option to trim this but Xano seems not to like this. What is the right way of solving this under the CSV_create filter 

Luck Kanthatham-2308338

Riann, what is the end result you're expecting from a value with space?  You mentioned "trim".  Do you want to trim the value instead?

Michael Udinski

Yes I am also curious what is the end result you'd be expecting here?

Riaan Backer

Expecting van staden in the csv file without "" 

Luck Kanthatham-2308338

I don't know how to do it in one step.  But perhaps you can use the regex_replace or string replace filter to get rid of the extra quotes perhaps.  You can eliminate the quotes with the patterns and .

Riaan Backer

it seems the CSV_create does not like using other filters unless I am doing it incorrectly - lets see what  advice will be

Chad Lewis

Did you get a solution?

Michael Udinski

hey  there's a Snippet on this you can download with a helper tutorial so you can install it to your instance. Here's the page to the snippet: https://www.xano.com/snippet/LiPGIfYL/

And the helper video:

AgIQ

I tried using the snippet, sending a json payload from Bubble.

When I send one "json" eg

{

"Sample Number": "1",

"Field": "3415",

"Depth": "N/A",

"pH": 5.17,

"pH Unit:": "CaCL2",

"Phosphorus": 29.93,

"Potassium": 78.72

}

I get the file back 100%, but when I send more than one "json" eg

{

"Sample Number": "1",

"Field": "3415",

"Depth": "N/A",

"pH": 5.17,

"pH Unit:": "CaCL2",

"Phosphorus": 29.93,

"Potassium": 78.72

}, {

"Sample Number": "2",

"Field": "3415",

"Depth": "N/A",

"pH": 5.17,

"pH Unit:": "CaCL2",

"Phosphorus": 29.93,

"Potassium": 78.72

}

the csv is empty, no header, nothing.

Any advice? Thx.

Luck Kanthatham-2308338

Not sure which snippet you used, but please make sure that you send in an object array.

[{object 1},{object 2},{object 3}]

I was able to get the result like this:

"Sample Number",Field,Depth,pH,"pH Unit:",Phosphorus,Potassium

1,3415,N/A,5.17,CaCL2,29.93,78.72

2,3415,N/A,5.17,CaCL2,29.93,78.72