Expert mode in the Intregration module - Provide data - OData

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.

OData

The following settings are available for OData:

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.

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).

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.

Microsoft SharePoint

The following settings are available for Microsoft SharePoint:

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.

Data groups

Corresponds to the OData settings.

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:

Attributes

Corresponds to the OData settings.

Data fields

Corresponds to the OData settings.

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.