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

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.