How table fields are stored on Athento and how to send this information from other systems?

In addition to filling in table-type fields through the product user interface, you may also want to send table information from other applications or import data using some of the import features.

This article explains the JSON format in which table-type field values are stored on Athento.

"my_itable_field": [
 {"DT_RowId": "row1", "itable-field-text-name": "Text test 1", "itable-field-number-name": "10"},
 {"DT_RowId": "row2", "itable-field-text-name": "Text test 2", "itable-field-number-name": "20"}
]

Let's break down where each of these data points comes from:

my_itable_field is the API name of the table-type field.

"DT_RowId": "rowX" indicates the row of the table you are sending. In this expression, only the number after "row" changes.

• "DT_RowId" : "row1" --> Row 1
• "DT_RowId" : "row2" --> Row 2

"itable-field-text-name" should be replaced with the internal name of the table column.

"Text test 1" is the value we want that column to take for that row.