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:
ItemsThe items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
LinksThe 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:
arrayTitle:
LinksThe 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 AttributesData 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 CodeRead Only:trueMaximum Length:30The 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 MeaningRead Only:trueMaximum Length:80The 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 ByRead Only:trueMaximum Length:64The user who created the data contract. -
CreationDate: string
(date-time)
Title:
Creation DateRead Only:trueThe date when the data contract was created. -
DataContractCode: string
Title:
Data Contract CodeRead Only:trueMaximum Length:80The unique code for the data contract. -
DataContractId: integer
(int64)
Title:
Data Contract IDRead Only:trueThe unique identifier for the data contract. -
LastUpdateBy: string
Title:
Last Update ByRead Only:trueMaximum Length:64The user who last updated the data contract. -
LastUpdateDate: string
(date-time)
Title:
Last Update DateRead Only:trueThe date and time the data contract was last updated. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
mappedDataAttributes: array
Mapped Data Contract Attributes
Title:
Mapped Data Contract AttributesData 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 ObjectRead Only:trueMaximum Length:50The source object that's associated with the data contract, such as an event or a business rule. -
SourceObjectCode: string
Title:
Source Object CodeRead Only:trueMaximum Length:30The unique code of the source object that's associated with the data contract. -
SourceObjectDescription: string
Title:
Source Object DescriptionRead Only:trueMaximum Length:1000The description of the source object that's associated with the data contract. -
SourceObjectId: integer
(int64)
Title:
Source Object IDRead Only:trueThe unique identifier of the source object that's associated with the data contract. -
SourceObjectName: string
Title:
Source Object NameRead Only:trueMaximum Length:100The name of the source object that's associated with the data contract.
Nested Schema : Data Contract Attributes
Type:
arrayTitle:
Data Contract AttributesData 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:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Mapped Data Contract Attributes
Type:
arrayTitle:
Mapped Data Contract AttributesData 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 ValueRead Only:trueMaximum Length:100The alias of the attribute related to the data contract. -
AttributeId: integer
(int64)
Title:
Attribute IDRead Only:trueThe unique identifier for an attribute of a data contract. -
AttributeName: string
Title:
Attribute NameRead Only:trueMaximum Length:100The name of the attribute related to the data contract. -
AttributeTypeCode: string
Title:
Attribute Type CodeRead Only:trueMaximum Length:30The 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 MeaningRead Only:trueMaximum Length:80The 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 ByRead Only:trueMaximum Length:64The user who created the data contract attribute. -
CreationDate: string
(date-time)
Title:
Creation DateRead Only:trueThe date when the data contract attribute was created. -
DefaultValue: string
Title:
Default ValueRead Only:trueMaximum Length:512Indicates the default value of an attribute in data contract attribute resource. -
DefaultValueTypeCode: string
Title:
Default Value Type CodeRead Only:trueMaximum Length:30Indicates 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 MeaningRead Only:trueMaximum Length:80The 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 ByRead Only:trueMaximum Length:64The user who last updated the data contract attribute. -
LastUpdateDate: string
(date-time)
Title:
Last Update DateRead Only:trueThe date and time when the data contract attribute was last updated. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
RequiredFlag: boolean
Title:
RequiredRead Only:trueMaximum Length:1Default Value:falseIndicates whether the attribute is required. If true, then the attribute is required. If false, then the attribute isn't required.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object-
href: string
Title:
hyperlink referenceThe URI to the related resource. -
kind: string
Title:
kindAllowed Values:[ "collection", "item", "describe", "other" ]The kind of the related resource. -
name: string
Title:
nameThe name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relationAllowed 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 ByRead Only:trueMaximum Length:64The user who created the data contract attribute map. -
CreationDate: string
(date-time)
Title:
Creation DateRead Only:trueThe date and time when the data contract attribute map was created. -
DataContractMapId: integer
(int64)
Title:
Data Contract Map IDRead Only:trueIndicates the unique identifier for a data contract attribute map. -
DefaultValue: string
Title:
Default ValueRead Only:trueMaximum Length:512The value that the data contract attribute will have, when it's null or no value is passed. -
DefaultValueTypeCode: string
Title:
Default Value Type CodeRead Only:trueMaximum Length:30The 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 MeaningRead Only:trueMaximum Length:80The data type of the default value. For example, string, number and so on. -
DestinationAttributeAlias: string
Title:
Destination Attribute AliasRead Only:trueMaximum Length:100The alias of the destination data contract attribute. -
DestinationAttributeName: string
Title:
Destination Attribute NameRead Only:trueMaximum Length:100The name of the destination data contract attribute. -
DestinationAttributeTypeCode: string
Title:
Destination Attribute Type CodeRead Only:trueMaximum Length:30The data type code of the destination data contract attribute. -
DestinationAttributeTypeMeaning: string
Title:
Destination Attribute Type MeaningRead Only:trueMaximum Length:80The data type meaning of the destination data contract attribute. -
DestinationDataContractAttributeId: integer
(int64)
Title:
Destination Data Contract Attribute IDRead Only:trueThe identifier of the destination data contract. -
DestinationDataContractId: integer
(int64)
Title:
Destination Data Contract IDRead Only:trueThe identifier of the destination data contract attribute. -
LastUpdateBy: string
Title:
Last Update ByRead Only:trueMaximum Length:64The user who last updated the data contract attribute map. -
LastUpdateDate: string
(date-time)
Title:
Last Update DateRead Only:trueThe date and time when the data contract attribute map was updated. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
MappingTypeCode: string
Title:
Mapping Type CodeRead Only:trueMaximum Length:30The 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 MeaningRead Only:trueMaximum Length:50The meaning that indicates if the data contract is a source or destination in the mapping definition. -
SourceAttributeAlias: string
Title:
Source Attribute AliasRead Only:trueMaximum Length:100The alias of the source data contract attribute. -
SourceAttributeName: string
Title:
Source Attribute NameRead Only:trueMaximum Length:100The name of the source data contract attribute. -
SourceAttributeTypeCode: string
Title:
Source Attribute Type CodeRead Only:trueMaximum Length:30The data type code of the source data contract attribute. -
SourceAttributeTypeMeaning: string
Title:
Source Attribute Type MeaningRead Only:trueMaximum Length:80The data type meaning of the source data contract attribute. -
SourceDataContractAttributeId: integer
(int64)
Title:
Source Data Contract Attribute IDRead Only:trueThe identifier of the source data contract attribute. -
SourceDataContractId: integer
(int64)
Title:
Source Data Contract IDRead Only:trueThe identifier of the source data contract.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source