Bulk insert into database from CSV file

@DK_9985660 ,

Are you trying to store this in a ThingWorx storage entity (Stream or Datatable) or are you trying to insert these directly into a database via a SQL command?

If you're storing into a Stream or DataTable, you can use the AddStreamEntries or AddDataTableEntries service to insert in one operation.  If you're attempting to add into a database table, you can programmatically create your sql insert statement like:

INSERT INTO myTable (uid, label, value) VALUES
(1, 'label1', 'value1'),
(2, 'label2', 'value2'),
(3, 'label3', 'value3'),
.
.
.

Either way, you can use the CSV parser tools to first parse the CSV file into an infotable and then use one of the options above.

Hope that helps!

--Nick