Write CSV to local folder

[Lakshmit]

Hi All,

Using CSV parser extension service WriteCSVFile am storing CSV file in SystemRepository. But my requirement is to save the file to local folder. Is there a way we can achieve this.

Thanks in Advance.

Regards

Lakshmi.

[drichter]

First you create the file in a FileRepository and then you can use the GetFileListingWithLinks-Service of this FileRepository to download the file.

[bot1q]

Hi,

if you want to have an Export in your Mashup.

Use Data Export widget. This will save the CSV in your default browser location (or ask) when you press it.

[Lakshmit]

Hi, 

Thank you for reply, but I want to avoid extra click for data export. Instead storing in Repository I was trying to save in local folder using below code.

var params = {
path: "/Data.csv" /* STRING */,
data: result1 /* INFOTABLE */,

 fileRepository: ??? --- Is there a way we can store in local folder?

// fileRepository: "SystemRepository" /* THINGNAME */,
withHeader: true /* BOOLEAN */
};
// no return
Resources["CSVParserFunctions"].WriteCSVFile(params);

Here WriteCSVFile function stores CSV in fileRepository mentioned in params(Here it is SystemRepository).

[drichter · Accepted solution]

This will not work. All Services run on server side. There have no access to your local filesystem.

[Lakshmit]

Sure, Then will try with FileRepository logic. Thank you for your support.

[bot1q]

If the export is somehow triggert from any User Input. Then just add a "automatic export" handler in the Date Export Widget and you will avoid an extra click.