How can I send data via API to fill an itable field?

Soporte L1

• December 21, 2022 12:01

What I would like to know is the sintaxis for sending data to populate an itable field when calling for example the DocumentCreate service.

For more common fields, the format is... 

{
"properties": {

"dc:title":"Document created from API",

"my-form_jcm_field_1" : "Field 1.",

"my-form_jcm_field_2" : "Field 2."

}
}
}

But what about tables?

0

• Official comment

  

  Antonio Diaz

  • December 21, 2022 14:05
  • Edited

  Hello,

  An itable field stores its information in JSON format.

  An example to create or update an itable metadata is:

   

  {
      "properties": {
      "metadata.my_table" : "[{'DT_RowId': 1, 'Column1': 'Value_1_1', 'Column2': 'Value_1_2'}, {'DT_RowId': 2, 'Column1': 'value_2_1, 'Column2': 'value_2_2'}]",
      }
  }

  Note that 'Column1'  and 'Column2' are the names of the columns in the table. DT_RowId is an index that represents the order of each row.

   

Please sign in to leave a comment.