PeopleSoft · Capability
PeopleSoft Reporting And Analytics
Unified workflow for analysts combining query execution, pivot grid dashboards, full-text search, and performance analytics across PeopleSoft Query, Pivot Grid, Search Framework, and EPM APIs.
What You Can Do
GET
List queries
— Retrieve available PeopleSoft Query definitions.
/v1/queries
GET
Execute query
— Execute a PeopleSoft Query by name.
/v1/queries/{queryName}
GET
List pivot grids
— Retrieve available pivot grid definitions.
/v1/pivot-grids
GET
Get pivot grid data
— Retrieve data for a specific pivot grid.
/v1/pivot-grids/{gridId}/data
GET
Search content
— Execute a full-text search across PeopleSoft indexed content.
/v1/search-results
POST
Trigger index build
— Trigger a search index build or incremental update.
/v1/search-indexes
GET
List budgets
— Retrieve budget definitions and data.
/v1/budgets
GET
List forecasts
— Retrieve forecast data and projections.
/v1/forecasts
GET
List analytics reports
— Retrieve performance analytics reports.
/v1/analytics-reports
MCP Tools
list-queries
Retrieve available PeopleSoft Query definitions.
read-only
execute-query
Execute a PeopleSoft Query by name and retrieve results.
read-only
list-pivot-grids
Retrieve available pivot grid definitions.
read-only
get-pivot-grid-data
Retrieve data for a specific pivot grid with optional filters.
read-only
search-content
Execute a full-text search across PeopleSoft indexed content.
read-only
trigger-index-build
Trigger a search index build or incremental update.
list-budgets
Retrieve budget definitions and data.
read-only
list-forecasts
Retrieve forecast data and projections.
read-only
list-analytics-reports
Retrieve performance analytics reports.
read-only
APIs Used
query
pivot-grid
search-framework
epm