I have a return from a query that I am pushing to a dgrid. That works fine. I want to take this json return and convert it to .csv I tried the code below and sent to an alert and it puts a comman after each character??? json simplify: var json = JSONObject ; // This is my json object as seen in the image above var csv = "" ; function toCSV ( json ) { alert ( "In Function" ) ; json = Object . values ( json ) ; var keys = ( json [ 0 ] && Object . keys ( json [ 0 ] ) ) || [ ] ; csv + = keys . join ( ',' ) + '\n' ; for ( var line of json ) { csv + = keys . map ( key = > line [ key ] ) . join ( ',' ) + '\n' ; } return csv ; } toCSV ( json ) ; alert ( csv ) ; This is the return I get when I alert the CSV variable....

Think I got it.... function ConvertToCSV2 ( objArray ) { let rows = typeof objArray !== "object" ? JSON . parse ( objArray ) : objArray ; let header = "" ; Object . keys ( rows [ 0 ] ) . map ( pr = > ( header + = pr + "," ) ) ; let str2 = "" ; rows . forEach ( row = > { let line = "" ; let columns = typeof row !== "object" ? JSON . parse ( row ) : Object . values ( row ) ; columns . forEach ( column = > { if ( line !== "" ) { line + = "," ; } if ( typeof column === "object" ) { line + = JSON . stringify ( column ) ; } else { line + = column ; } } ) ; str2 + = line + "\r\n" ; } ) ; return header + "\r\n" + str2 ; } // Grab my Json return from the query and send to function var RailroadCSVObject2 = ConvertToCSV2 ( RailroadJSONObject ) ; // Grab the value and export a csv file for the user. var pom = document . createElement ( 'a' ) ; var csvContent = RailroadCSVObject2 ; //here we load our csv data var blob = new Blob ( [ csvContent ] , { type : 'text/csv;charset=utf-8;' } ) ; var url = URL . createObjectURL ( blob ) ; pom . href = url ; pom . setAttribute ( 'download' , 'DataExport.csv' ) ; pom . click ( ) ;

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Convert json.simplify to CSV

jaykapalczynski

I have a return from a query that I am pushing to a dgrid. That works fine.

I want to take this json return and convert it to .csv I tried the code below and sent to an alert and it puts a comman after each character???

json simplify:

<SPAN class="keyword token">var</SPAN> json <SPAN class="operator token">=</SPAN> JSONObject<SPAN class="punctuation token">;</SPAN>	 <SPAN class="comment token">// This is my json object as seen in the image above	</SPAN>
<SPAN class="keyword token">var</SPAN> csv <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
		
<SPAN class="keyword token">function</SPAN> <SPAN class="token function">toCSV</SPAN><SPAN class="punctuation token">(</SPAN>json<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
	<SPAN class="token function">alert</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"In Function"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
	json <SPAN class="operator token">=</SPAN> Object<SPAN class="punctuation token">.</SPAN><SPAN class="token function">values</SPAN><SPAN class="punctuation token">(</SPAN>json<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
	<SPAN class="keyword token">var</SPAN> keys <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>json<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">&&</SPAN> Object<SPAN class="punctuation token">.</SPAN><SPAN class="token function">keys</SPAN><SPAN class="punctuation token">(</SPAN>json<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">||</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
	csv <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> keys<SPAN class="punctuation token">.</SPAN><SPAN class="token function">join</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">','</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'\n'</SPAN><SPAN class="punctuation token">;</SPAN>
	<SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> line <SPAN class="keyword token">of</SPAN> json<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
	    csv <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> keys<SPAN class="punctuation token">.</SPAN><SPAN class="token function">map</SPAN><SPAN class="punctuation token">(</SPAN>key <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN> line<SPAN class="punctuation token">[</SPAN>key<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">join</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">','</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'\n'</SPAN><SPAN class="punctuation token">;</SPAN>
	<SPAN class="punctuation token">}</SPAN>
	<SPAN class="keyword token">return</SPAN> csv<SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>

<SPAN class="token function">toCSV</SPAN><SPAN class="punctuation token">(</SPAN>json<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">alert</SPAN><SPAN class="punctuation token">(</SPAN>csv<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

This is the return I get when I alert the CSV variable....

Encontre mais publicações marcadas com

Accepted answers

jaykapalczynski

Think I got it....

<SPAN class="keyword token">function</SPAN> <SPAN class="token function">ConvertToCSV2</SPAN><SPAN class="punctuation token">(</SPAN>objArray<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">let</SPAN> rows <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">typeof</SPAN> objArray <SPAN class="operator token">!==</SPAN> <SPAN class="string token">"object"</SPAN> <SPAN class="operator token">?</SPAN> JSON<SPAN class="punctuation token">.</SPAN><SPAN class="token function">parse</SPAN><SPAN class="punctuation token">(</SPAN>objArray<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">:</SPAN> objArray<SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">let</SPAN>  header <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
    Object<SPAN class="punctuation token">.</SPAN><SPAN class="token function">keys</SPAN><SPAN class="punctuation token">(</SPAN>rows<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">map</SPAN><SPAN class="punctuation token">(</SPAN>pr <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN> <SPAN class="punctuation token">(</SPAN>header <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> pr <SPAN class="operator token">+</SPAN> <SPAN class="string token">","</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

    <SPAN class="keyword token">let</SPAN> str2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
    rows<SPAN class="punctuation token">.</SPAN><SPAN class="token function">forEach</SPAN><SPAN class="punctuation token">(</SPAN>row <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN> <SPAN class="punctuation token">{</SPAN>
        <SPAN class="keyword token">let</SPAN> line <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="keyword token">let</SPAN> columns <SPAN class="operator token">=</SPAN>
            <SPAN class="keyword token">typeof</SPAN> row <SPAN class="operator token">!==</SPAN> <SPAN class="string token">"object"</SPAN> <SPAN class="operator token">?</SPAN> JSON<SPAN class="punctuation token">.</SPAN><SPAN class="token function">parse</SPAN><SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">:</SPAN> Object<SPAN class="punctuation token">.</SPAN><SPAN class="token function">values</SPAN><SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        columns<SPAN class="punctuation token">.</SPAN><SPAN class="token function">forEach</SPAN><SPAN class="punctuation token">(</SPAN>column <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN> <SPAN class="punctuation token">{</SPAN>
            <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>line <SPAN class="operator token">!==</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
                line <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> <SPAN class="string token">","</SPAN><SPAN class="punctuation token">;</SPAN>
            <SPAN class="punctuation token">}</SPAN>
            <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">typeof</SPAN> column <SPAN class="operator token">===</SPAN> <SPAN class="string token">"object"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
                line <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> JSON<SPAN class="punctuation token">.</SPAN><SPAN class="token function">stringify</SPAN><SPAN class="punctuation token">(</SPAN>column<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
            <SPAN class="punctuation token">}</SPAN>  <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
                line <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> column<SPAN class="punctuation token">;</SPAN>
            <SPAN class="punctuation token">}</SPAN>
        <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        str2 <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> line <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\r\n"</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">return</SPAN> header <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\r\n"</SPAN> <SPAN class="operator token">+</SPAN> str2<SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>

<SPAN class="comment token">// Grab my Json return from the query and send to function</SPAN>
<SPAN class="keyword token">var</SPAN> RailroadCSVObject2 <SPAN class="operator token">=</SPAN> <SPAN class="token function">ConvertToCSV2</SPAN><SPAN class="punctuation token">(</SPAN>RailroadJSONObject<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
		
<SPAN class="comment token">// Grab the value and export a csv file for the user.</SPAN>
<SPAN class="keyword token">var</SPAN> pom <SPAN class="operator token">=</SPAN> document<SPAN class="punctuation token">.</SPAN><SPAN class="token function">createElement</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'a'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> csvContent<SPAN class="operator token">=</SPAN>RailroadCSVObject2<SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">//here we load our csv data </SPAN>
<SPAN class="keyword token">var</SPAN> blob <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Blob</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>csvContent<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">{</SPAN>type<SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'text/csv;charset=utf-8;'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> url <SPAN class="operator token">=</SPAN> URL<SPAN class="punctuation token">.</SPAN><SPAN class="token function">createObjectURL</SPAN><SPAN class="punctuation token">(</SPAN>blob<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
pom<SPAN class="punctuation token">.</SPAN>href <SPAN class="operator token">=</SPAN> url<SPAN class="punctuation token">;</SPAN>
pom<SPAN class="punctuation token">.</SPAN><SPAN class="token function">setAttribute</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'download'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'DataExport.csv'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
pom<SPAN class="punctuation token">.</SPAN><SPAN class="token function">click</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

RobertScheitlin__GISP

Jay,

Does your objArray have the header info?

jaykapalczynski

Think I got it....

<SPAN class="keyword token">function</SPAN> <SPAN class="token function">ConvertToCSV2</SPAN><SPAN class="punctuation token">(</SPAN>objArray<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">let</SPAN> rows <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">typeof</SPAN> objArray <SPAN class="operator token">!==</SPAN> <SPAN class="string token">"object"</SPAN> <SPAN class="operator token">?</SPAN> JSON<SPAN class="punctuation token">.</SPAN><SPAN class="token function">parse</SPAN><SPAN class="punctuation token">(</SPAN>objArray<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">:</SPAN> objArray<SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">let</SPAN>  header <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
    Object<SPAN class="punctuation token">.</SPAN><SPAN class="token function">keys</SPAN><SPAN class="punctuation token">(</SPAN>rows<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">map</SPAN><SPAN class="punctuation token">(</SPAN>pr <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN> <SPAN class="punctuation token">(</SPAN>header <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> pr <SPAN class="operator token">+</SPAN> <SPAN class="string token">","</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

    <SPAN class="keyword token">let</SPAN> str2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
    rows<SPAN class="punctuation token">.</SPAN><SPAN class="token function">forEach</SPAN><SPAN class="punctuation token">(</SPAN>row <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN> <SPAN class="punctuation token">{</SPAN>
        <SPAN class="keyword token">let</SPAN> line <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="keyword token">let</SPAN> columns <SPAN class="operator token">=</SPAN>
            <SPAN class="keyword token">typeof</SPAN> row <SPAN class="operator token">!==</SPAN> <SPAN class="string token">"object"</SPAN> <SPAN class="operator token">?</SPAN> JSON<SPAN class="punctuation token">.</SPAN><SPAN class="token function">parse</SPAN><SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">:</SPAN> Object<SPAN class="punctuation token">.</SPAN><SPAN class="token function">values</SPAN><SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        columns<SPAN class="punctuation token">.</SPAN><SPAN class="token function">forEach</SPAN><SPAN class="punctuation token">(</SPAN>column <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN> <SPAN class="punctuation token">{</SPAN>
            <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>line <SPAN class="operator token">!==</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
                line <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> <SPAN class="string token">","</SPAN><SPAN class="punctuation token">;</SPAN>
            <SPAN class="punctuation token">}</SPAN>
            <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">typeof</SPAN> column <SPAN class="operator token">===</SPAN> <SPAN class="string token">"object"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
                line <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> JSON<SPAN class="punctuation token">.</SPAN><SPAN class="token function">stringify</SPAN><SPAN class="punctuation token">(</SPAN>column<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
            <SPAN class="punctuation token">}</SPAN>  <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
                line <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> column<SPAN class="punctuation token">;</SPAN>
            <SPAN class="punctuation token">}</SPAN>
        <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        str2 <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> line <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\r\n"</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">return</SPAN> header <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\r\n"</SPAN> <SPAN class="operator token">+</SPAN> str2<SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>

<SPAN class="comment token">// Grab my Json return from the query and send to function</SPAN>
<SPAN class="keyword token">var</SPAN> RailroadCSVObject2 <SPAN class="operator token">=</SPAN> <SPAN class="token function">ConvertToCSV2</SPAN><SPAN class="punctuation token">(</SPAN>RailroadJSONObject<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
		
<SPAN class="comment token">// Grab the value and export a csv file for the user.</SPAN>
<SPAN class="keyword token">var</SPAN> pom <SPAN class="operator token">=</SPAN> document<SPAN class="punctuation token">.</SPAN><SPAN class="token function">createElement</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'a'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> csvContent<SPAN class="operator token">=</SPAN>RailroadCSVObject2<SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">//here we load our csv data </SPAN>
<SPAN class="keyword token">var</SPAN> blob <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Blob</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>csvContent<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">{</SPAN>type<SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'text/csv;charset=utf-8;'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> url <SPAN class="operator token">=</SPAN> URL<SPAN class="punctuation token">.</SPAN><SPAN class="token function">createObjectURL</SPAN><SPAN class="punctuation token">(</SPAN>blob<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
pom<SPAN class="punctuation token">.</SPAN>href <SPAN class="operator token">=</SPAN> url<SPAN class="punctuation token">;</SPAN>
pom<SPAN class="punctuation token">.</SPAN><SPAN class="token function">setAttribute</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'download'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'DataExport.csv'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
pom<SPAN class="punctuation token">.</SPAN><SPAN class="token function">click</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

jaykapalczynski

If I do this I get a decent return but no headers.....how do I add the headers to this final output of this

<SPAN class="comment token">// JSON to CSV Converter</SPAN>
<SPAN class="keyword token">function</SPAN> <SPAN class="token function">ConvertToCSV</SPAN><SPAN class="punctuation token">(</SPAN>objArray<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
   <SPAN class="keyword token">var</SPAN> array <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">typeof</SPAN> objArray <SPAN class="operator token">!=</SPAN> <SPAN class="string token">'object'</SPAN> <SPAN class="operator token">?</SPAN> JSON<SPAN class="punctuation token">.</SPAN><SPAN class="token function">parse</SPAN><SPAN class="punctuation token">(</SPAN>objArray<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">:</SPAN> objArray<SPAN class="punctuation token">;</SPAN>
   <SPAN class="keyword token">var</SPAN> str <SPAN class="operator token">=</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">;</SPAN>
			
   <SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> i <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">;</SPAN> i <SPAN class="operator token"><</SPAN> array<SPAN class="punctuation token">.</SPAN>length<SPAN class="punctuation token">;</SPAN> i<SPAN class="operator token">++</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
       <SPAN class="keyword token">var</SPAN> line <SPAN class="operator token">=</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">;</SPAN>
       <SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> index <SPAN class="keyword token">in</SPAN> array<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
           <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>line <SPAN class="operator token">!=</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">)</SPAN> line <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> <SPAN class="string token">','</SPAN>

           line <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> array<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN>index<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
       <SPAN class="punctuation token">}</SPAN>

       str <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> line <SPAN class="operator token">+</SPAN> <SPAN class="string token">'\r\n'</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="punctuation token">}</SPAN>

    <SPAN class="keyword token">return</SPAN> str<SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍


<SPAN class="keyword token">var</SPAN> RailroadCSVObject <SPAN class="operator token">=</SPAN> <SPAN class="token function">ConvertToCSV</SPAN><SPAN class="punctuation token">(</SPAN>RailroadJSONObject<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.