Expert mode in the Intregration module

Integration module Provide data OData Expert mode

1. Activate expert mode

You can activate the setting "Enable expert options" main menu Extras / Options / Integration / Provide data / OData. In the Applications module, you can then define expert settings on the Expert tab in the properties dialog of elements with a link to OData external sources.

2. OData

The following settings are available for OData:

2.1. Data groups

• odata.dataGroup.consumerCfgGuid
  GUID of the OData external data source configuration.
• odata.dataGroup.consumerServiceGuid
  GUID of the OData service within the OData configuration.
• odata.dataGroup.impersonateUserGuid
  GUID of the Intrexx user, in whose context data group actions will be run.
• odata.dataGroup.mergeMethod
  Defines the HTTP verb to be used for update actions (either PUT or MERGE; default is MERGE).
• odata.dataGroup.entityType
  Fully qualified name of the OData entity type for this data group.
• odata.dataGroup.entityName
  Name of the OData entity for this data group.
• odata.dataGroup.entitySet
  Name of the OData entity set for this data group.
• odata.dataGroup.supports.pagination
  Defines whether the OData service supports pagination for requesting result sets. Intrexx uses pagination by default. For this, the service must support the request for the number of records via "$count". If this is not the case, this value can be set to "false".
• odata.dataGroup.supports.sorting
  Defines whether the OData service supports sorting for result sets. Intrexx uses sorting by default. If the service does not support this, this value can be set to "false".
• odata.dataGroup.supports.inlinecount
  Defines whether the OData service is able to simultaneously return the number of records. This allows a second request with "$count" to be avoided. This value is set to "false" by default.
• odata.dataGroup.supports.fieldselection
  Defines whether the OData service supports a selection of data fields in requests. This value is set to "true" by default. If the service does not support this, the value can be set to "false", which results in all available fields being queried.
• odata.dataGroup.navigationProperty
  Name of the navigation property for 1:1 or 1:n relationships.

2.2. Data fields

• odata.field.fileExtension
  Defines the file name extension to be used for file data fields (such as jpg).
• odata.field.dataType
  Defines the OData data type to be used for the field (overwrites an automatic assignment of the data type).

2.3. View tables

• odata.functionImport.name
  Defines the name of the OData service function to be called.
• odata.functionImport.parameterName
  List of function parameter names.
• odata.functionImport.parameter
  Mapping of field GUIDs on function parameters to determine function parameter values.
• odata.customQueryOptions
  Map for the assignment of values as custom query options. The key for the map is the query option name, and either a field GUID or a fixed value can be entered as the value. When using a field GUID, the value for the custom query option is determined at runtime from the edit field with the corresponding GUID.

3. Microsoft SharePoint

The following settings are available for Microsoft SharePoint:

3.1. Attributes

In the properties dialog of the SharePoint external data group, the Expert attribute "datahandler" with the value "de.uplanet.lucy.server.odata.consumer.sharepoint.RtDataGroupODataSharePoint" is available.

3.2. Data groups

Corresponds to the OData settings.

3.3. SharePoint-specific settings

• sharepoint.attachments.entityset.name
  Name of the attachment entity set for lists in the SharePoint OData metadata.
• sharepoint.document.library
  Labels an external data group as a SharePoint document library.
• sharepoint.file.contenttype.field.guid
  Field GUID for the ContenttypeID field.
• sharepoint.file.editdate.field.guid
  Field GUID for the ChangeDate field.
• sharepoint.file.name.field.guid
  Field GUID for the Name field.
• sharepoint.file.path.field.guid
  Field GUID for the Path field.
• sharepoint.folder.name.field.guid
  Field GUID for the Folder Name field.
• sharepoint.folder.path.field.guid
  Field GUID for the Folder Path field.
• sharepoint.list.library
  Labels an external data group as a SharePoint list.
• sharepoint.version
  The SharePoint server version (SP2013 or SP2010).
• sharepoint.version.comment.field.guid
  Field GUID for the Comment field for versions.
• sharepoint.versionable
  Flags whether a Check-Out/In is required (SharePoint 2013 only).

4. SAP Gateway

The following settings are available for SAP Gateway:

4.1. Attributes

Corresponds to the OData settings.

4.2. Data fields

Corresponds to the OData settings.

4.3. View tables

• odata.functionImport.name
  Defines the name of the OData service function to be called.
• odata.functionImport.parameterName
  List of function parameter names.
• odata.functionImport.parameterFieldGuid
  List of field GUIDs for the determination of function parameter values.
• odata.customQueryOptions
  Map for the assignment of values as Custom Query Options. The key to the map is the query option name, either a field GUID or a fixed value can be entered as a value. In the case of a field GUID, the value for the Custom Query option is determined from the field with the corresponding GUID at run time.