Configure a Data list activity

Add row

When you execute this activity, a row is added to the Data list with the values specified.

Delete rows using either of the following methods:

• Index: Provide an index value to delete.

  Provide a value in Row index for the rows you want to delete.

• Custom search: Define the search criteria for deleting a row. You can add, delete, and modify the search criteria.

  1. Click  for Search criteria.

  2. Provide the Name and Value using an inline value or process or server variable.

  3. Click Add.

When you execute this activity, the row at the specified index or any row that matches the search criteria is deleted from the array. If the row does not exist, an error is displayed.

Update the cell values using either of the following methods:

• Index: Provide an index value to update. You can add more than one column to update.

  1. Provide a value in Row index for the row where you want to update the value.

  2. Click  for Update fields.

  3. Provide the Name and Value using an inline value, process or server variable.

  4. Click Add.

     You can add multiple columns to update.

• Custom search: Define the search criteria. You can add multiple search criteria.

  1. Click  for Search criteria.

  2. Provide the Name and Value using an inline value or process or server variable.

  3. Click Add.

  4. Click  for Update fields.

  5. Provide the Name and Value using an inline value or process or server variable.

  6. Click Add. You can add multiple columns to update.

When you execute this activity, at runtime the columns in the row at the specified index are updated with the specified values or any row that meets the search criteria is updated. If the row does not exist, an error is displayed.

Get row(s) using either of the following methods:

• Index: Provide an index value to get the rows you want. You can add multiple columns to return.

  1. Provide a value for Row index, using an inline value, or process or server variable.

  2. For Return data, add the columns to be returned and map the columns to the targets using a process or server variable.

  3. On the Row count, select the Long or Short type variable.

• Custom search: Define the search criteria. You can add multiple search criteria.

  1. Click  for Search criteria.

  2. Select a name (column) and provide a value using an inline value or process or server variable.

  3. Click Add.

  4. To return the row data, on the Return data list, select a data model variable.

  5. Add one or more columns and map them to return the result of the data model variable.

  6. On the Row count, select the Long or Short type variable.

When you execute this activity, the data from the row at the specified index is returned with the correct variables, or any row that matches the search criteria is returned with the mapped data model variable. If the row does not exist, an error is displayed.