a string specifying the baseUrlfor the labkey server
folderPath
a string specifying the folderPath
schemaName
a string specifying the schemaName for the query
queryName
a string specifying the queryName
toInsert
a data frame containing rows of data to be inserted
Details
A single row or multiple rows of data can be inserted. The toInsert data frame must contain
values for each column in the dataset and must be created with the stringsAsFactors option
set to FALSE. The names of the data in the data frame must be the column names from the
LabKey Server.To insert a value of NULL, use an empty string ("") in the data frame (regardless of the database column type).
Also, when inserting data into a study dataset, the sequence number must be specified..
Value
A list is returned with named categories of command, rowsAffected, rows, queryName, containerPath and schemaName.
The schemaName, queryName and containerPath properties contain the same schema, query
and folder path used in the request. The
rowsAffected property indicates the number of rows affected by the API action. This will typically be the same
number as passed in the request. The rows property contains a list of row objects corresponding to the rows
inserted.