WriteCSVFile

[AP_9587236]

I have 100 rows in CSV File. I want to replace only one row. This snippet: Resources["CSVParserFunctions"].WriteCSVFile(params2); is not accepting one row as an input. Iam getting an error "JavaException: java.lang.Exception: Unable To Convert From com.thingworx.types.collections.ValueCollection to INFOTABLE ". 

1. How to update only one row of csv file?

2. Shall i pass arrays tothe input data?

 var params2 = {
path: filePath2 /* STRING */,
data: rowCSV /* INFOTABLE */,
fileRepository: "SystemRepository" /* THINGNAME */,
withHeader: true /* BOOLEAN */
};Resources["CSVParserFunctions"].WriteCSVFile(params2);

[slangley · Accepted solution]

Hi @AP_9587236.

You will need to load the whole file into a ThingWorx infotable, Is it a correct assumption that you would want to make the updates via a mashup?  If so, you would need to tie the infotable to a grid, make the change, and then write it back out to the CSV file.

If you can provide a better understanding of your application, we might be able to provide a more efficient way of handling it.

Regards.

--Sharon

[slangley]

Hi @AP_9587236.

If the previous response answered your question, please mark it as the Accepted Solution for the benefit of others with the same question.

Regards.

--Sharon