Create or modify a row or values with the API : createOrUpdateTableRow(s)

One of the most common requirements is to add a new row or change the values of an existing row via the API.

To create or modify a row or the data in a row, the API request is createOrUpdateTableRow.

To create or modify multiple rows, or the data for multiple rows, the API request is createOrUpdateTableRows.

1. Create a new row

Once you have retrieved the column identifiers (fields) of a table with getTableValues, it is easy to create a new row.

From the API website, use the createOrUpdateTableRow. function, specifying tmpNEW_ROW as the value for the rowID parameter.

Here is an example of a request. Replace userID with your user ID and sessionID with your API key (Sesskey), and fieldID1, fieldID2, fieldID3 and fieldID4 with the correct column IDs (fields):

https://timetonic.com/live/api.php?req=createOrUpdateTableRow&version=5.71&o_u=userID &u_c=userID &sesskey=sessionID &rowId=tmpNEW_ROW&fieldValues={"fieldID1": "First field value", "fieldID2": "Second field value", "fieldID3": "Third field value", "fieldID4": "Fourth field value"}

Note : it is recommended to pass the parameters as POST rather than GET but for the example it is easier to test.

2. Modifying the values of one or more fields in an existing row

Once you have retrieved the identifiers of the columns (fields) and rows of a table with getTableValues, it is easy to modify the values of an existing row.

From the API site, use the createOrUpdateTableRow. function, specifying the row ID as the value for the rowID parameter.

Here is an example of a request. Replace of course userID with your user ID and sessionID with your API key (Sesskey), rowIDtoUpdate with the row ID and fieldID1, fieldID2, fieldID3 and fieldID4 with the correct column IDs (fields):

https://timetonic.com/live/api.php?req=createOrUpdateTableRow&version=5.71&o_u=userID &u_c=userID &sesskey=sessionID &rowId=rowIDtoUpdate&fieldValues={"fieldID1": "New value first field", "fieldID2": "New value second field", "fieldID3": "New value third field", "fieldID4": "New value fourth field"}

Note : it is recommended to pass the parameters in POST rather than GET but for the example it is easier to test.