Skip to main content
E
Explorerhere291-Visitor
1-Visitor
February 5, 2019
Solved

How to append a CSV file in repository(WriteCSV) using CSV Parser function in ThingWorx ?

  • February 5, 2019
  • 1 reply
  • 1374 views

I'm trying append the csv file in the repository with a service.

My code looks like below.

var params = {
infoTableName : "result",
dataShapeName : "WriteDataShape"
};

// CreateInfoTableFromDataShape(infoTableName:STRING("InfoTable"), dataShapeName:STRING):INFOTABLE(ds1)
var result = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params);
var newRow = new Object();
newRow.ID = ID;
newRow.Name = Name;
//infotable1Object.rows[0] = newRow;
result.AddRow(newRow);
var params2 = {
path: "WriteFile.CSV" /* STRING */,
data: result /* INFOTABLE */,
fileRepository: "SystemRepository" /* THINGNAME */,
withHeader: true /* BOOLEAN */
};
// no return
var result = Resources["CSVParserFunctions"].WriteCSVFile(params2);

Could anyone please tell me why the data in CSV file gets overwritten every time I call this service ? 

Best answer by slangley

Hi @Explorerhere29.

 

The service you are using will always overwrite.  Another approach:

 

Using ReadCSVFile, read in the existing CSV file in the repository as an Infotable as opposed to creating a new table each time as you are doing here:

 

dataShapeName:STRING):INFOTABLE(ds1)
var result = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params);

 

Once you're read in the CSV file as an Infotable, you can append rows as you are currently doing in your code.

 

Regards.

 

--Sharon

1 reply

S
slangleyCommunity ManagerAnswer
Community Manager
February 5, 2019

Hi @Explorerhere29.

 

The service you are using will always overwrite.  Another approach:

 

Using ReadCSVFile, read in the existing CSV file in the repository as an Infotable as opposed to creating a new table each time as you are doing here:

 

dataShapeName:STRING):INFOTABLE(ds1)
var result = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params);

 

Once you're read in the CSV file as an Infotable, you can append rows as you are currently doing in your code.

 

Regards.

 

--Sharon

E
Explorerhere291-VisitorAuthor
1-Visitor
February 7, 2019

For appending rows can I use WriteCSV function or some other ?

Terms & ConditionsCookie settingsAccessibility statement