Expert mode in the Integration module – Provide data – OData
You can activate the setting "Enable expert options" main menu "Extras / Options / Integration / Provide data / OData".
Expert settings can then be defined for the OData service on the "Expert" tab in the "Applications" module.
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 of 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.
SAP Gateway
The following settings are available for SAP Gateway:
Data groups
How OData
Data fields
How OData
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.
More information
Connector for OData – offer data