Get all grants personnel
get
/fscmRestApi/resources/11.13.18.05/grantsPersonnel
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: Finds a grants personnel with the specified primary key.
Finder Variables:- PersonId; integer; Identifier of the person selected from Human Resources to administer and manage awards.
- PrimaryKey: Finds a grants personnel with the specified 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:- ActivePerson; string; Indicates if the person has an active primary assignment in Human Resources as of the current date.
- CertifiedDate; string; Date when the person completed the conflict of interest review. Enter a start date in this format: YYYY-MM-DD.
- EligiblePiFlag; boolean; Indicates whether the person is qualified to be a principal investigator, the person primarily responsible for research. List of accepted values are True or False.
- EmailAddress; string; Email of the person selected from Human Resources to administer and manage awards. The application checks the attributes of this person in the following order: Email, Person Number, Person Name. The application first searches for a matching email, then a matching person number, then a matching person name.
- JobName; string; Job assigned to the primary assignment of the person in Human Resources.
- OrganizationName; string; Organization assigned to the primary assignment of the person in Human Resources.
- PersonId; integer; Identifier of the person selected from Human Resources to administer and manage awards.
- PersonName; string; Name of the person selected from Human Resources to administer and manage awards. The application checks the attributes of this person in the following order: Email, Person Number, Person Name. The application first searches for a matching email, then a matching person number, then a matching person name.
- PersonNumber; string; Number of the person selected from Human Resources to administer and manage awards. The application checks the attributes of this person in the following order: Email, Person Number, Person Name. The application first searches for a matching email, then a matching person number, then a matching person name.
- ReviewCompleted; string; Indicates whether a conflict of interest exists according to the institution policy and whether the person has completed the review. List of accepted values are True or False.
- 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 : grantsPersonnel
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 : grantsPersonnel-item-response
Type:
Show Source object- ActivePerson: string Title:
Active PersonRead Only:trueMaximum Length:255Indicates if the person has an active primary assignment in Human Resources as of the current date. - CertifiedDate: string (date) Title:
Certified DateDate when the person completed the conflict of interest review. Enter a start date in this format: YYYY-MM-DD. - EligiblePiFlag: boolean Title:
Principal InvestigatorMaximum Length:1Indicates whether the person is qualified to be a principal investigator, the person primarily responsible for research. List of accepted values are True or False. - EmailAddress: string Maximum Length:
255Email of the person selected from Human Resources to administer and manage awards. The application checks the attributes of this person in the following order: Email, Person Number, Person Name. The application first searches for a matching email, then a matching person number, then a matching person name. - GrantsPersonnelDFF: array Grants Personnel Descriptive Flexfields Title:
Grants Personnel Descriptive FlexfieldsA listing of all the descriptive flexfields available for Grants personnel. - GrantsPersonnelKeyword: array Grants Personnel Keywords Title:
Grants Personnel KeywordsThe Grants Personnel Keywords resource is used to view, create, and delete keywords that are associated to Grants personnel. - JobName: string Title:
JobRead Only:trueMaximum Length:240Job assigned to the primary assignment of the person in Human Resources. - links: array Links Title:
LinksThe link relations associated with the resource instance. - OrganizationName: string Title:
DepartmentRead Only:trueMaximum Length:240Organization assigned to the primary assignment of the person in Human Resources. - PersonId: integer (int64) Title:
Person NameIdentifier of the person selected from Human Resources to administer and manage awards. - PersonName: string Maximum Length:
255Name of the person selected from Human Resources to administer and manage awards. The application checks the attributes of this person in the following order: Email, Person Number, Person Name. The application first searches for a matching email, then a matching person number, then a matching person name. - PersonNumber: string Maximum Length:
30Number of the person selected from Human Resources to administer and manage awards. The application checks the attributes of this person in the following order: Email, Person Number, Person Name. The application first searches for a matching email, then a matching person number, then a matching person name. - ReviewCompleted: string Title:
Review CompletedMaximum Length:10Indicates whether a conflict of interest exists according to the institution policy and whether the person has completed the review. List of accepted values are True or False.
Nested Schema : Grants Personnel Descriptive Flexfields
Type:
arrayTitle:
Grants Personnel Descriptive FlexfieldsA listing of all the descriptive flexfields available for Grants personnel.
Show Source Nested Schema : Grants Personnel Keywords
Type:
arrayTitle:
Grants Personnel KeywordsThe Grants Personnel Keywords resource is used to view, create, and delete keywords that are associated to Grants personnel.
Show Source Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source Nested Schema : grantsPersonnel-GrantsPersonnelDFF-item-response
Type:
Show Source object- __FLEX_Context: string Title:
Context SegmentMaximum Length:30Context of the descriptive flexfield. - __FLEX_Context_DisplayValue: string Title:
Context SegmentContext display value of the descriptive flexfield. - links: array Links Title:
LinksThe link relations associated with the resource instance. - PersonId: integer (int64) Title:
Person NameIdentifier of the person selected from Human Resources to administer and manage awards.
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 : grantsPersonnel-GrantsPersonnelKeyword-item-response
Type:
Show Source object- Description: string Title:
DescriptionRead Only:trueMaximum Length:240Details of the keyword that is used to track the key subject area for the Grants personnel. - FromDate: string (date) Title:
From DateRead Only:trueDate when the keyword becomes active. - KeywordId: number Title:
KeywordIdentifier of the keyword selected from Grants keywords. - KeywordName: string Title:
Keyword NameMaximum Length:80Name of the keyword that is used to uniquely describe and track the key subject area for the Grants personnel. - links: array Links Title:
LinksThe link relations associated with the resource instance. - PersonId: number Title:
Person NameIdentifier of the person selected from Human Resources to administer and manage awards. - PersonnelKeywordId: integer (int64) Identifier of the keyword associated with the Grants personnel.
- ToDate: string (date) Title:
To DateRead Only:trueDate after which the keyword is inactive.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source Examples
The following example shows how to get all grants personnel by submitting a GET request on the REST resource using cURL.
curl --user ppm_cloud_user https://your_organization.com:port/fscmRestApi/resources/11.13.18.05/awards/300100047724327/child/grantsPersonnel
Response Body Example
The following shows an example of the response body in JSON format of all the grants personnel..
{ "items": [ { "PersonId": 300100031721179, "EligiblePiFlag": null, "CertifiedDate": null, "OrganizationName": "Vision City Maintenance", "JobName": "Consultant", "PersonName": "Mark Williams", "EmailAddress": "prj_mark_williams_grp@oracle.com", "PersonNumber": "955160008176607", "ActivePerson": "Y", "ReviewCompleted": "false", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/11.13.18.05/grantsPersonnel/300100031721179", "name": "grantsPersonnel", "kind": "item", "properties": { "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178" } }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/11.13.18.05/grantsPersonnel/300100031721179", "name": "grantsPersonnel", "kind": "item" }, { "rel": "lov", "href": "https://servername/fscmRestApi/resources/11.13.18.05/grantsPersonnel/300100031721179/lov/PersonNameDPVO", "name": "PersonNameDPVO", "kind": "collection" }, { "rel": "lov", "href": "https://servername/fscmRestApi/resources/11.13.18.05/grantsPersonnel/300100031721179/lov/PersonDPVO", "name": "PersonDPVO", "kind": "collection" }, { "rel": "lov", "href": "https://servername/fscmRestApi/resources/11.13.18.05/grantsPersonnel/300100031721179/lov/PersonEmailPVO", "name": "PersonEmailPVO", "kind": "collection" }, { "rel": "child", "href": "https://servername/fscmRestApi/resources/11.13.18.05/grantsPersonnel/300100031721179/child/GrantsPersonnelKeyword", "name": "GrantsPersonnelKeyword", "kind": "collection" }, { "rel": "child", "href": "https://servername/fscmRestApi/resources/11.13.18.05/grantsPersonnel/300100031721179/child/GrantsPersonnelDFF", "name": "GrantsPersonnelDFF", "kind": "collection" } ], } ... }