Understanding REST API Endpoints for PeopleSoft Fetch By Sheet Name (exfetchbysheetname)
This topic lists the REST resources and methods for the Fetch By Sheet Name API (exfetchbysheetname). Use this API to retrieve expense report by description.The Fetch By Sheet Name REST API can be used for the Expense skill.
This table lists the delivered API resource used with the Fetch By Sheet Name API.
|
API Resource |
Description |
|---|---|
|
API resource to retrieve expense report by description. |
API resource to retrieve expense report by description.
Method: GET
Path: /exfetchbysheetnameroot/{iSheetName}
|
Request Parameters |
Description |
|---|---|
|
iSheetName |
Expense report description. |
|
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. |