Understanding REST API Endpoints for PeopleSoft Fetch Last Five Transactions

This topic lists the REST resources and methods for the Fetch Last Five Transactions API (exfetchlast5 and exfetchlast5external). Use this API to retrieve the five most recent expense report transactions. The Fetch Last Five Transactions 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 Last Five Transactions API.

API Resource

Description

exfetchlast5root

API resource to retrieve the five most recent expense report transactions. This API is to be used with the digital assistant.

exfetchlast5rootexternal

API resource to retrieve the five most recent expense report transactions. This API is to be used for external consumption.

API resource to retrieve the five most recent expense report transactions. This API is to be used with the digital assistant.

Method: GET

Path: /exfetchlast5root/{iDesc}/{iStatus}

Request Parameters

Description

iDesc

Expense report description.

iStatus

Expense report status.

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 the five most recent expense report transactions. This API is to be used for external consumption.

Method: GET

Path: /exfetchlast5rootexternal/{iDesc}/{iStatus}

Request Parameters

Description

iDesc

Expense report description.

iStatus

Expense report status.

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.