Understanding REST API Endpoints for PeopleSoft Fetch by Creation Date
This topic lists the REST resources and methods for the Fetch by Creation Date API (exfetchbycreationdate and exfetchbycreationdaterootexternal). Use this API to retrieve expense report by creation date. The Fetch by Creation Date REST API can be used for the Expense skill.
API's that have "external" as the suffix are used by external systems. API's that do not have "external" as the suffix are used by PeopleSoft Intelligent Chat ASsistance from Oracle (PICASO) digital assistant.
This table lists the delivered API resource used with the Fetch by Creation Date API.
|
API Resource |
Description |
|---|---|
|
API resource to retrieve expense report by creation date. This API is to be used with the digital assistant. |
|
|
API resource to retrieve expense report by creation date. This API is to be used for external consumption. |
API resource to retrieve expense report by creation date. This API is to be used with the digital assistant.
Method: GET
Path: /exfetchbycreationdateroot/{iDesc}/{iStatus}/{iFromDate}/{iToDate}
|
Request Parameters |
Description |
|---|---|
|
iDesc |
Expense report description. |
|
iFromDate |
Expense report search from date. |
|
iStatus |
Expense report status. |
|
iToDate |
Expense report search to date. |
|
Response Parameters |
Response Result Type |
Description |
|---|---|---|
|
oSHEETAMOUNT |
Success |
Expense report amount. |
|
oSHEETCREATE |
Success |
Expense report creation date. |
|
oSHEETDESC |
Success |
Expense report description. |
|
oSHEETNAME |
Success |
Expense report name. |
|
oSHEETSTATUS |
Success |
Expense report status. |
API resource to retrieve expense report by creation date. This API is to be used for external consumption.
Method: GET
Path: /exfetchbycreationdaterootexternal/{iDesc}/{iStatus}/{iFromDate}/{iToDate}
|
Request Parameters |
Description |
|---|---|
|
iDesc |
Expense report description. |
|
iFromDate |
Expense report search from date. |
|
iStatus |
Expense report status. |
|
iToDate |
Expense report search to date. |
|
Response Parameters |
Response Result Type |
Description |
|---|---|---|
|
oSHEETAMOUNT |
Success |
Expense report amount. |
|
oSHEETCREATE |
Success |
Expense report creation date. |
|
oSHEETDESC |
Success |
Expense report description. |
|
oSHEETNAME |
Success |
Expense report name. |
|
oSHEETSTATUS |
Success |
Expense report status. |