Understanding REST API Endpoints for PeopleSoft Fetch by Status

This topic lists the REST resources and methods for the Fetch by Status API (exfetchbystatus and exfetchbystatusexternal). Use this API to retrieve expense report by status. The Fetch by Status 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 Status API.

API Resource

Description

statusinintent

API resource to retrieve expense report by status. This API is to be used with the digital assistant.

statusinintentexternal

API resource to retrieve expense report by status. This API is to be used for external consumption.

API resource to retrieve expense report by status. This API is to be used with the digital assistant.

Method: GET

Path: /statusinintent/{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 expense report by status. This API is to be used for external consumption.

Method: GET

Path: /statusinintentexternal/{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.