Get all data contracts
get
/fscmRestApi/resources/11.13.18.05/hedDataContracts
Request
Query Parameters
-
expand: string
When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
-
fields: string
This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
Format: ?fields=Attribute1,Attribute2
Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2 -
finder: string
Used as a predefined finder to search the collection.
Format ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>
The following are the available finder names and corresponding finder variables- ByContractFinder Finds the data contract that match the criteria specified.
Finder Variables- Contract; string; The data contract attribute that's associated with the data contract.
- SourceContractTypeCode; string; The unique code of the source contract type that's associated with the data contract.
- SourceObjectCode; string; The unique source object code that's associated with the data contract.
- ByPublishedContractFinder Finds the data contract that match the criteria specified.
Finder Variables- SearchObjectCode; string; The unique code of the search object that's associated with the data contract.
- SearchObjectId; integer; The unique identifier of the search object that's associated with the data contract.
- SourceContractTypeCode; string; The unique code of the source contract type that's associated with the data contract.
- SourceObjectCode; string; The unique code of the source object that's associated with the data contract.
- PrimaryKey Finds the data contract that match the primary key criteria specified.
Finder Variables- DataContractId; integer; The unique identifier of the data contract.
- ByContractFinder Finds the data contract that match the criteria specified.
-
limit: integer
This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
-
links: string
This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
Example:
self,canonical -
offset: integer
Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
-
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
-
orderBy: string
This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
-
q: string
This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY
Format: ?q=expression1;expression2
You can use these queryable attributes to filter this collection resource using the q query parameter:- ContractTypeCode; string; The contract type code of the data contract. A list of acceptable values is defined in the lookup type ORA_HEY_CONTRACT_TYPE_CODE.
- ContractTypeMeaning; string; The meaning of the contract type code of the data contract. A list of acceptable values is defined in the lookup type ORA_HEY_CONTRACT_TYPE_CODE.
- CreationDate; string; The date when the data contract was created.
- DataContractCode; string; The unique code for the data contract.
- DataContractId; integer; The unique identifier for the data contract.
- LastUpdateBy; string; The user who last updated the data contract.
- LastUpdateDate; string; The date and time the data contract was last updated.
- SourceObject; string; The source object that's associated with the data contract, such as an event or a business rule.
- SourceObjectCode; string; The unique code of the source object that's associated with the data contract.
- SourceObjectDescription; string; The description of the source object that's associated with the data contract.
- SourceObjectId; integer; The unique identifier of the source object that's associated with the data contract.
-
totalResults: boolean
The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
Header Parameters
-
Metadata-Context: string
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version: string
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
Default Response
The following table describes the default response for this task.
Headers
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Root Schema : hedDataContracts
Type:
Show Source
object
-
count(required): integer
The number of resource instances returned in the current range.
-
hasMore(required): boolean
Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
-
items: array
Items
Title:
Items
The items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
Links
The link relations associated with the resource instance. -
offset(required): integer
The offset value used in the current page.
-
totalResults: integer
The estimated row count when "?totalResults=true", otherwise the count is not included.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : hedDataContracts-item-response
Type:
Show Source
object
-
attributes: array
Data Contract Attributes
Title:
Data Contract Attributes
Data contract attributes identifies all the attributes that are part of the contract of an object such as an event or a business rule. -
ContractTypeCode: string
Title:
Contract Type Code
Read Only:true
Maximum Length:30
The contract type code of the data contract. A list of acceptable values is defined in the lookup type ORA_HEY_CONTRACT_TYPE_CODE. -
ContractTypeMeaning: string
Title:
Contract Type Meaning
Read Only:true
Maximum Length:80
The meaning of the contract type code of the data contract. A list of acceptable values is defined in the lookup type ORA_HEY_CONTRACT_TYPE_CODE. -
CreatedBy: string
Title:
Created By
Read Only:true
Maximum Length:64
The user who created the data contract. -
CreationDate: string
(date-time)
Title:
Creation Date
Read Only:true
The date when the data contract was created. -
DataContractCode: string
Title:
Data Contract Code
Read Only:true
Maximum Length:80
The unique code for the data contract. -
DataContractId: integer
(int64)
Title:
Data Contract ID
Read Only:true
The unique identifier for the data contract. -
LastUpdateBy: string
Title:
Last Update By
Read Only:true
Maximum Length:64
The user who last updated the data contract. -
LastUpdateDate: string
(date-time)
Title:
Last Update Date
Read Only:true
The date and time the data contract was last updated. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
mappedDataAttributes: array
Mapped Data Contract Attributes
Title:
Mapped Data Contract Attributes
Data contract attributes map identifies whether the attributes are the source or the target of an object such as an event or a business rule. -
SourceObject: string
Title:
Source Object
Read Only:true
Maximum Length:50
The source object that's associated with the data contract, such as an event or a business rule. -
SourceObjectCode: string
Title:
Source Object Code
Read Only:true
Maximum Length:30
The unique code of the source object that's associated with the data contract. -
SourceObjectDescription: string
Title:
Source Object Description
Read Only:true
Maximum Length:1000
The description of the source object that's associated with the data contract. -
SourceObjectId: integer
(int64)
Title:
Source Object ID
Read Only:true
The unique identifier of the source object that's associated with the data contract. -
SourceObjectName: string
Title:
Source Object Name
Read Only:true
Maximum Length:100
The name of the source object that's associated with the data contract.
Nested Schema : Data Contract Attributes
Type:
array
Title:
Data Contract Attributes
Data contract attributes identifies all the attributes that are part of the contract of an object such as an event or a business rule.
Show Source
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Mapped Data Contract Attributes
Type:
array
Title:
Mapped Data Contract Attributes
Data contract attributes map identifies whether the attributes are the source or the target of an object such as an event or a business rule.
Show Source
Nested Schema : hedDataContracts-attributes-item-response
Type:
Show Source
object
-
AttributeAlias: string
Title:
Attribute Value
Read Only:true
Maximum Length:100
The alias of the attribute related to the data contract. -
AttributeId: integer
(int64)
Title:
Attribute ID
Read Only:true
The unique identifier for an attribute of a data contract. -
AttributeName: string
Title:
Attribute Name
Read Only:true
Maximum Length:100
The name of the attribute related to the data contract. -
AttributeTypeCode: string
Title:
Attribute Type Code
Read Only:true
Maximum Length:30
The type code of an attribute of a data contract. A list of acceptable values is defined in the lookup ORA_HEY_ATTRIBUTE_TYPE_CODE. -
AttributeTypeMeaning: string
Title:
Attribute Type Meaning
Read Only:true
Maximum Length:80
The meaning of the type code of a data contract attribute. A list of acceptable values is defined in the lookup ORA_HEY_ATTRIBUTE_TYPE_CODE. -
CreatedBy: string
Title:
Created By
Read Only:true
Maximum Length:64
The user who created the data contract attribute. -
CreationDate: string
(date-time)
Title:
Creation Date
Read Only:true
The date when the data contract attribute was created. -
DefaultValue: string
Title:
Default Value
Read Only:true
Maximum Length:512
Indicates the default value of an attribute in data contract attribute resource. -
DefaultValueTypeCode: string
Title:
Default Value Type Code
Read Only:true
Maximum Length:30
Indicates the default value type code of an attribute in data contract attribute resource. A list of acceptable values is defined in the lookup ORA_HEY_ATTRIBUTE_TYPE_CODE. -
DefaultValueTypeMeaning: string
Title:
Default Value Type Meaning
Read Only:true
Maximum Length:80
The meaning of the default value type of a data contract attribute. A list of acceptable values is defined in the lookup ORA_HEY_ATTRIBUTE_TYPE_CODE. -
LastUpdateBy: string
Title:
Last Update By
Read Only:true
Maximum Length:64
The user who last updated the data contract attribute. -
LastUpdateDate: string
(date-time)
Title:
Last Update Date
Read Only:true
The date and time when the data contract attribute was last updated. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
RequiredFlag: boolean
Title:
Required
Read Only:true
Maximum Length:1
Default Value:false
Indicates whether the attribute is required. If true, then the attribute is required. If false, then the attribute isn't required.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object
-
href: string
Title:
hyperlink reference
The URI to the related resource. -
kind: string
Title:
kind
Allowed Values:[ "collection", "item", "describe", "other" ]
The kind of the related resource. -
name: string
Title:
name
The name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relation
Allowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]
The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object
-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Nested Schema : hedDataContracts-mappedDataAttributes-item-response
Type:
Show Source
object
-
CreatedBy: string
Title:
Created By
Read Only:true
Maximum Length:64
The user who created the data contract attribute map. -
CreationDate: string
(date-time)
Title:
Creation Date
Read Only:true
The date and time when the data contract attribute map was created. -
DataContractMapId: integer
(int64)
Title:
Data Contract Map ID
Read Only:true
Indicates the unique identifier for a data contract attribute map. -
DefaultValue: string
Title:
Default Value
Read Only:true
Maximum Length:512
The value that the data contract attribute will have, when it's null or no value is passed. -
DefaultValueTypeCode: string
Title:
Default Value Type Code
Read Only:true
Maximum Length:30
The data type of the default value. For example, ORA_HEY_PRIMITIVE_STRING, ORA_HEY_PRIMITIVE_BOOLEAN and so on. -
DefaultValueTypeMeaning: string
Title:
Default Value Type Meaning
Read Only:true
Maximum Length:80
The data type of the default value. For example, string, number and so on. -
DestinationAttributeAlias: string
Title:
Destination Attribute Alias
Read Only:true
Maximum Length:100
The alias of the destination data contract attribute. -
DestinationAttributeName: string
Title:
Destination Attribute Name
Read Only:true
Maximum Length:100
The name of the destination data contract attribute. -
DestinationAttributeTypeCode: string
Title:
Destination Attribute Type Code
Read Only:true
Maximum Length:30
The data type code of the destination data contract attribute. -
DestinationAttributeTypeMeaning: string
Title:
Destination Attribute Type Meaning
Read Only:true
Maximum Length:80
The data type meaning of the destination data contract attribute. -
DestinationDataContractAttributeId: integer
(int64)
Title:
Destination Data Contract Attribute ID
Read Only:true
The identifier of the destination data contract. -
DestinationDataContractId: integer
(int64)
Title:
Destination Data Contract ID
Read Only:true
The identifier of the destination data contract attribute. -
LastUpdateBy: string
Title:
Last Update By
Read Only:true
Maximum Length:64
The user who last updated the data contract attribute map. -
LastUpdateDate: string
(date-time)
Title:
Last Update Date
Read Only:true
The date and time when the data contract attribute map was updated. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
MappingTypeCode: string
Title:
Mapping Type Code
Read Only:true
Maximum Length:30
The code that indicates if the data contract is a source or destination in the mapping definition. For example, HEY_SOURCE or HEY_DESTINATION. -
MappingTypeMeaning: string
Title:
Mapping Type Meaning
Read Only:true
Maximum Length:50
The meaning that indicates if the data contract is a source or destination in the mapping definition. -
SourceAttributeAlias: string
Title:
Source Attribute Alias
Read Only:true
Maximum Length:100
The alias of the source data contract attribute. -
SourceAttributeName: string
Title:
Source Attribute Name
Read Only:true
Maximum Length:100
The name of the source data contract attribute. -
SourceAttributeTypeCode: string
Title:
Source Attribute Type Code
Read Only:true
Maximum Length:30
The data type code of the source data contract attribute. -
SourceAttributeTypeMeaning: string
Title:
Source Attribute Type Meaning
Read Only:true
Maximum Length:80
The data type meaning of the source data contract attribute. -
SourceDataContractAttributeId: integer
(int64)
Title:
Source Data Contract Attribute ID
Read Only:true
The identifier of the source data contract attribute. -
SourceDataContractId: integer
(int64)
Title:
Source Data Contract ID
Read Only:true
The identifier of the source data contract.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source