One of the most common needs is to add a new line or modify the values of an existing line via the API.

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

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

1. Creating a new row

Once the identifiers of the columns (fields) of a table with getTableValues have been obtained, it is very easy to create a new line.

From the API site, 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":"Valeur premier champ","fieldID2":"Valeur second champ","fieldID3":"Valeur troisième champ","fieldID4":"Valeur quatrième champ"}

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

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

From the API site, use the createOrUpdateTableRow. function by specifying the line ID 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), 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":"Nouvelle valeur premier champ","fieldID2":"Nouvelle valeur second champ","fieldID3":"Nouvelle valeur troisième champ","fieldID4":"Nouvelle valeur quatrième champ"}

NB: In both cases, it is rather recommended to go through the parameters in POST rather than in GET. It was used in the example merely for practicality purposes.