Attributes

Every datasource contract must have at least one attribute. To map object properties to the columns of the editable entities, you can also add attributes to the root node of the external datasource contract. The data source attributes are mapped to the simple properties in the business object.

The Attributes element is a container element that contains all attributes of a data source. By itself, it doesn’t have any attributes. However, it can contain these elements:

• Attribute: To specify a column from a database table. Each attribute has a unique identifier name, the database table name of the attribute, and the corresponding column of the table. Name, table, and column are required attributes. For example:

  <Attribute name="pKey" table="Visit" column="Id" />
  <Attribute name="description" table="Account_Template__c" column="Description_#Language#__c"/>

• DerivedAttribute: Optional. To specify unbound attributes with literal or calculated values. Specify a unique name of the unbound attribute and its literal value or a valid SQL calculation expression. Name and value are required attributes. For example,

  <DerivedAttribute name="mobilityRelevant" value="'1'" />
  <DerivedAttribute name="docTATypeForNew" value="' '" />
  

• DateTimeAttribute: Optional. To store date and time-related data in Salesforce. You can also add one or more DateTimeAttribute nodes under the PivotItems node of PivotItems. dateName, timeName, table, and column are the attributes of a DateTimeAttribute node. For example, use the dateName variable to fetch the visits for today or a particular date. For example,

  <DateTimeAttribute dateName="creationDate" timeName="creationTime" table="SF_File" column="CreatedDate" />

• PivotItems: To map different schemas. For more information see PivotItems.