Data Requirements for the Results of ECT-Enabled Mashups

Appendix : Legacy Presto components : Mashables and Mashups : Mashups in Business Analytics Wires : Creating Mashups in Wires : Add Actions or Other Blocks : Adapt Results as a SharePoint External Content Type : Data Requirements for the Results of ECT-Enabled Mashups

To enable integration of mashup results as SharePoint lists, the results of the mashup must:

Have a set of repeating items (rows) that transform to the SharePoint list items.

Each item (row) in the result must have a flat set of fields that each contain simple data. Complex content such as this example is not supported:

<row>
<name>A field with simple content</name>
<location>
<street>complex field</street>
<city>with </city>
<state>individual</state>
<country>children</country>
</location>
<phone>another field with simple content</phone>
</row>

The data type for the content of each field must match a supported SharePoint list field type. See SharePoint documentation for specific information.

Note:

Valid field types includes the built-in SharePoint field types and optionally custom types added to your SharePoint environment. For information on types that are not supported, see Datatypes Not Supported by Business Data Connectivity Service.

Each row must have a required field that can be used as a unique identifier (the ID) for that row. This identifier cannot change for the lifetime of that item.

Numeric row IDs cannot exceed 12 digits.

Row IDs that are simple indexed numbers (integers) are strongly recommended as this field must match the required input parameter for the

External Content Type Adapter block. This is used to support the two required operations for SharePoint external content lists. See Supported SharePoint Operations for more information.

Not exceed the maximum number of rows allowed. This maximum is set by your SharePoint Farm Administrator based on resources specific to your environment.

In addition, the name and datatype of the input parameter that is required for the

External Content Type Adapter block must match the name and datatype of the field used as the row ID in mashup results.

Contact Support | Community | Feedback