Configure table service attributes

In the Management Portal at Entitlement Catalog, on the Attributes tab of the service page, configure table attributes to store multiple rows of data in a table structure.

For example, because people may use multiple devices when they interact in your environment, it can be useful to store data about these devices in a single table service attribute. In a workflow action, this makes it easier to provide values based on the device that is used. Table service attributes are also very useful in integrations with third-party solutions like Mobile Device Management (MDM) systems.

Configuration

Field

Explanation and Tips

Table columns

Specify columns and values manually.

  • On the Columns tab, specify the columns of the table. You can add a maximum of 32 columns.
  • Select the check boxes in the Required column to specify mandatory columns.
  • Select the check boxes in the Restricted Information column to mask the column values in the Management Portal.
  • On the Initial Value tab, specify the default values of the table rows.
    • You can specify separators in input values:
      • Pipe-characters ("|") are changed to a capital i ("I").
      • Semi-colons (";") are changed to a colon (":").
    • You can add a maximum of 512 rows.
    • The value is limited to 2000 characters.
    • You can use placeholders to specify values. This allows you to configure services that dynamically resolve the values of table service attributes. For example, you can use a person attribute as a label in a table service attribute. During the service transaction, this person attribute then resolves dynamically depending on the person that requests or subscribes to the service. This allows you to use personalized options in the table.
      • If you use placeholders to specify values, they need to resolve in unique values. If multiple placeholders resolve in the same value, only one value will be added to the table.
  • If you first link the service attribute to another one, and then select Table columns, the table of the other service attribute is "copied". This makes it easier to create a new table.
  • You can add a maximum of 32 columns.

Copy from global attribute of type Table

Base the columns and values on a table global attribute. Optionally, you can filter out irrelevant data from the original table attribute by configuring a table filter.

  • The Preview contents area shows a read-only view of the columns of this global attribute.
  • The initial values are the values of the global attribute.

Copy from people attribute of type Table

Base the columns and values on a table people attribute. Optionally, you can filter out irrelevant data from the original table attribute by configuring a table filter.

  • The Preview contents area shows a read-only view of the columns of this people attribute.
  • The initial values are the values of the subscriber's people attribute.

Copy from service attribute of type Table

Base the columns and values on another table service attribute. Optionally, you can filter out irrelevant data from the original table attribute by configuring a table filter.

  • The Preview contents area shows a read-only view of the columns and values of this service attribute.
  • The subscriber to the current service must already subscribe to the other service before the values of its service attribute can be resolved.

Placeholders

Use the following commands to retrieve values from the table, for workflow actions and other service attributes.
For example, if you have configured a table service attribute MyDevices with the following values:

UUID

FriendlyName

Type

OS

PhoneNumber

Status

123-123-1234

S4

Phone

Android

8008937810

Active

123-123-1235

iPad

PDA

iOS

 

Wiped

Use the following commands:

Get the values of the entire table

Command

#Service[SA Table.FullTable]

Column values are separated with “;”, rows with “|”.

Example

#Service[MyMobileDevices.FullTable]

Returns

123-123-1234;S4;Phone;Android;8008937810;Active|123-123-1235;iPad;PDA;iOS;;Wiped

Get the values of the current row

Command

#Service[SA Table.CurrentRow.FullRow]

Column values are separated with “;”

Example

#Service[MyMobileDevices.CurrentRow.FullRow]

Returns

123-123-1234;S4;Phone;Android;8008937810;Active

Get the values of a column of the current row

Command

#Service[SA Table.CurrentRow.C1]

Example

#Service[MyMobileDevices.CurrentRow.UUID]

Returns

123-123-1234

Get the values of a table column

Command

#Service[SA Table.EntireColumn.C1]

Example

#Service[MyMobileDevices.EntireColumn.UUID]

Returns

123-123-1234 123-123-1235

Get the number of rows of a table

Command

#Service[SA Table.Number of rows]

Example

#Service[MyMobileDevices.Number of rows]

Returns

2

Get the description of the table

Command

#Service[SA Table.Description]

Example

#Service[MyMobileDevices.Description]

Returns

"This table shows the mobile devices of the subscriber"

See also