Get all contests
get
/crmRestApi/resources/11.13.18.05/contests
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- PrimaryKey Find a contest using the primary key.
Finder Variables- ContestId; integer; The unique identifier of the contest
- RowFinder Find all contests using the contest number.
Finder Variables- ContestNumber; string; The unique alternate identifier of the contest.
- PrimaryKey Find a contest using the primary key.
-
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:- ConflictId; integer; Conflict ID
- ContestId; integer; Contest ID
- ContestName; string; Contest Name
- ContestNumber; string; Contest Number
- CreatedBy; string; Created By
- CreationDate; string; Creation Date
- Description; string; Description
- EndDate; string; End Date
- KPIAggregation; string; KPI Calculation Type
- KPIDescription; string; KPI Description
- KPIId; integer; KPI ID
- KPIName; string; KPI Name
- KPINumber; string; KPI Number
- LastUpdateDate; string; Last Updated Date
- LastUpdateLogin; string; Last Update Login
- LastUpdatedBy; string; Last Updated By
- ObjectVersionNumber; integer; Object Version Number
- OwnerId; integer; Owner ID
- OwnerName; string; Owner Name
- OwnerNumber; string; Owner Number
- OwnerUniqueName; string; Owner Unique Name
- StartDate; string; Start Date
-
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 : contests
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 : contests-item-response
Type:
Show Source
object-
ConflictId: integer
(int64)
Default Value:
0Conflict ID -
ContestHistory: array
Contest History
Title:
Contest HistoryContest History -
ContestId: integer
(int64)
Title:
Contest IDContest ID -
ContestName: string
Title:
Contest NameMaximum Length:275Contest Name -
ContestNumber: string
Title:
Contest NumberMaximum Length:64Contest Number -
ContestParticipants: array
Contest Resources
Title:
Contest ResourcesContest Resources -
ContestScores: array
Contest Scores
Title:
Contest ScoresContest Scores -
CreatedBy: string
Title:
Created ByRead Only:trueMaximum Length:64Created By -
CreationDate: string
(date-time)
Title:
Creation DateRead Only:trueCreation Date -
DeleteFlag: boolean
Read Only:
trueDelete Contest -
Description: string
Title:
DescriptionMaximum Length:3000Description -
EndDate: string
(date-time)
Title:
End DateEnd Date -
KPIAggregation: string
Title:
KPI Calculation TypeRead Only:trueMaximum Length:200KPI Calculation Type -
KPIDescription: string
Title:
KPI DescriptionRead Only:trueMaximum Length:3000KPI Description -
KPIId: integer
(int64)
Title:
KPI IDKPI ID -
KPIName: string
Title:
KPI NameRead Only:trueMaximum Length:275KPI Name -
KPINumber: string
Title:
KPI NumberMaximum Length:64KPI Number -
LastUpdateDate: string
(date-time)
Title:
Last Updated DateRead Only:trueLast Updated Date -
LastUpdatedBy: string
Title:
Last Updated ByRead Only:trueMaximum Length:64Last Updated By -
LastUpdateLogin: string
Title:
Last Update LoginRead Only:trueMaximum Length:32Last Update Login -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
ObjectVersionNumber: integer
(int32)
Read Only:
trueObject Version Number -
OwnerId: integer
(int64)
Title:
Owner IDOwner ID -
OwnerName: string
Title:
Owner NameRead Only:trueMaximum Length:360Owner Name -
OwnerNumber: string
Title:
Owner NumberRead Only:trueMaximum Length:30Owner Number -
OwnerUniqueName: string
Title:
Owner Unique NameRead Only:trueMaximum Length:900Owner Unique Name -
StartDate: string
(date-time)
Title:
Start DateStart Date -
UpdateFlag: boolean
Read Only:
trueUpdate Contest
Nested Schema : Contest Resources
Type:
arrayTitle:
Contest ResourcesContest Resources
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : contests-ContestHistory-item-response
Type:
Show Source
object-
ContestId: integer
(int64)
Read Only:
trueContest ID -
DynamicNumber1Name: string
Read Only:
trueMaximum Length:200Dynamic Number 1 Name -
DynamicNumber1UOM: string
Read Only:
trueMaximum Length:200Dynamic Number 1 UOM -
DynamicNumber1Value: integer
(int64)
Read Only:
trueDynamic Number 1 Value -
DynamicNumber2Name: string
Read Only:
trueMaximum Length:200Dynamic Number 2 Name -
DynamicNumber2UOM: string
Read Only:
trueMaximum Length:200Dynamic Number 2 UOM -
DynamicNumber2Value: integer
(int64)
Read Only:
trueDynamic Number 2 Value -
DynamicText1Name: string
Read Only:
trueMaximum Length:200Dynamic Text 1 Name -
DynamicText1Value: string
Read Only:
trueMaximum Length:200Dynamic Text 1 Value -
DynamicText2Name: string
Read Only:
trueMaximum Length:200Dynamic Text 2 Name -
DynamicText2Value: string
Read Only:
trueMaximum Length:200Dynamic Text 2 Value -
HistoryRecordDate: string
(date-time)
Read Only:
trueHistory Record Date -
HistoryRecordId: integer
Read Only:
trueHistory Record ID -
HistoryRecordObjectId: integer
(int64)
Read Only:
trueThe unique identifier of the history record object. -
HistoryRecordObjectNumber: string
Read Only:
trueMaximum Length:256The alternate unique identifier of the history record object. -
HistoryRecordOwnerId: integer
(int64)
Read Only:
trueHistory Resource Owner ID -
HistoryRecordOwnerName: string
Read Only:
trueMaximum Length:360The owner of the history record. -
HistoryRecordOwnerNumber: string
Read Only:
trueMaximum Length:30The alternate unique identifier of the history record owner. -
KPIId: integer
(int64)
Read Only:
trueKPI ID -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
StaticText: string
Read Only:
trueMaximum Length:4000Static Text
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 : contests-ContestParticipants-item-response
Type:
Show Source
object-
ConflictId: integer
(int64)
Default Value:
0Contest Participant Conflict ID -
ContestId: integer
(int64)
Title:
Contest IDContest ID -
ContestNumber: string
Title:
Contest NumberMaximum Length:64Contest Number -
ContestResourceId: integer
(int64)
Title:
Contest Resource IDContest Resource ID -
ContestResourceRole: string
Title:
Contest Resource RoleMaximum Length:40Contest Resource Role -
CreatedBy: string
Title:
Created ByRead Only:trueMaximum Length:64Created By -
CreationDate: string
(date-time)
Title:
Creation DateRead Only:trueCreation Date -
LastUpdateDate: string
(date-time)
Title:
Last Updated DateRead Only:trueLast Updated Date -
LastUpdatedBy: string
Title:
Last Updated ByRead Only:trueMaximum Length:64Last Updated By -
LastUpdateLogin: string
Title:
Last Update LoginRead Only:trueMaximum Length:32Last Update Login -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
ObjectVersionNumber: integer
(int32)
Read Only:
trueObject Version Number -
ResourceAvatarUri: string
Read Only:
trueParticipant Avatar URI -
ResourceId: integer
(int64)
Title:
Resource IDResource ID -
ResourceName: string
Title:
NameRead Only:trueMaximum Length:360Name -
ResourceNumber: string
Title:
Resource NumberRead Only:trueMaximum Length:30Resource Number
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : contests-ContestScores-item-response
Type:
Show Source
object-
ContestEndDate: string
(date-time)
Read Only:
trueContest End Date -
ContestId: integer
(int64)
Read Only:
trueContest ID -
ContestName: string
Read Only:
trueMaximum Length:275Contest Name -
ContestNumber: string
Read Only:
trueMaximum Length:64Contest Number -
ContestPcptScoreId: string
Read Only:
trueMaximum Length:255Contest Participant Score ID -
ContestScoreDetails: array
Contest Score Details
Title:
Contest Score DetailsContest Score Details -
ContestStartDate: string
(date-time)
Read Only:
trueContest Start Date -
DenomScore: number
Read Only:
trueThe denominator value of the KPI score. -
KPIAggregation: string
Read Only:
trueMaximum Length:200KPI Calculation Type for Contest Scores -
KPIId: integer
(int64)
Read Only:
trueKPI ID -
KPIName: string
Read Only:
trueMaximum Length:275KPI Name -
KPINumber: string
Read Only:
trueMaximum Length:64KPI Number -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
NumerScore: number
Read Only:
trueThe numerator value of the KPI score. -
PersonId: integer
(int64)
Read Only:
truePerson ID -
Rank: number
Read Only:
trueRank -
ResourceAvatarUri: string
Read Only:
trueResource Avatar URI -
ResourceId: integer
(int64)
Read Only:
trueResource ID -
ResourceName: string
Read Only:
trueMaximum Length:360Resource Name -
ResourceNumber: string
Read Only:
trueMaximum Length:30Resource Number -
Score: number
Read Only:
trueScore -
UOMCode: string
Read Only:
trueMaximum Length:40UOM Code
Nested Schema : Contest Score Details
Type:
arrayTitle:
Contest Score DetailsContest Score Details
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : contests-ContestScores-ContestScoreDetails-item-response
Type:
Show Source
object-
ContestEndDate: string
(date-time)
Read Only:
trueContest End Date -
ContestId: integer
(int64)
Read Only:
trueContest ID -
ContestName: string
Read Only:
trueMaximum Length:275Contest Name -
ContestNumber: string
Read Only:
trueMaximum Length:64Contest Number -
ContestStartDate: string
(date-time)
Read Only:
trueContest Start Date -
DenomScore: number
Read Only:
trueThe denominator value of the KPI score. -
KPICategoryCode: string
Read Only:
trueMaximum Length:100KPI Category Code -
KPICategoryName: string
Read Only:
trueMaximum Length:80KPI Category Name -
KPIId: integer
(int64)
Read Only:
trueKPI ID -
KPIName: string
Read Only:
trueMaximum Length:275KPI Name -
KPINumber: string
Read Only:
trueMaximum Length:64KPI Number -
KPIObject: string
Read Only:
trueMaximum Length:40KPI Object -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
NumerScore: number
Read Only:
trueThe numerator value of the KPI score. -
ResourceId: integer
(int64)
Read Only:
trueResource ID -
ResourceName: string
Read Only:
trueMaximum Length:900Resource Name -
ResourceNumber: string
Read Only:
trueMaximum Length:30Resource Number -
Score: number
Read Only:
trueScore -
UOMCode: string
Read Only:
trueMaximum Length:40UOM Code
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Examples
The following example shows how to get all contests by submitting a get request on the REST resource using cURL.
cURL Command
curl -u <username:password> \ -X
https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/contests
Example of Response Body
The following shows an example of the response body in JSON format.
{
"items": [
{
"ContestId": 300100547824052,
"ContestNumber": "CDRM_1039",
"ContestName": "ContestAppointmentsCompleted_2021-08-10 10:52:17",
"Description": "Testing_2021-08-10 10:52:17",
"OwnerId": 300100206486893,
"StartDate": "2021-08-10T10:51:38+00:00",
"EndDate": "2021-09-09T10:52:18+00:00",
"KPIId": 100100144204795,
"CreatedBy": "cbarry",
"CreationDate": "2021-08-10T10:50:40+00:00",
"LastUpdatedBy": "cbarry",
"LastUpdateDate": "2021-08-10T10:50:42.547+00:00",
"LastUpdateLogin": "C92581ABB72CF83AE0533AFDF40A3E1C",
"ObjectVersionNumber": 1,
"ConflictId": 0,
"OwnerName": "Conor Barry",
"OwnerNumber": "CDRM_900650",
"OwnerUniqueName": "Conor Barry",
"KPIName": "Appointments Completed",
"KPINumber": "SEED_6_S",
"KPIDescription": "Measures the number of appointments completed.",
"UpdateFlag": true,
"DeleteFlag": true,
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/contests/CDRM_1039",
"name": "contests",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
}
},
{
"rel": "canonical",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/contests/CDRM_1039",
"name": "contests",
"kind": "item"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/contests/CDRM_1039/child/ContestHistory",
"name": "ContestHistory",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/contests/CDRM_1039/child/ContestParticipants",
"name": "ContestParticipants",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/contests/CDRM_1039/child/ContestScores",
"name": "ContestScores",
"kind": "collection"
}
]
}
],
"count": 1,
"hasMore": false,
"limit": 25,
"offset": 0,
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/contests",
"name": "contests",
"kind": "collection"
}
]
}