List and Execute a Query
A 2-step recipe with PeopleSoft. We can help you get access.
Recipe · 2 steps
List and Execute a Query
with PeopleSoft
Discover a PS Query definition then execute it for results.
- Retrieve the catalog of available PeopleSoft Query definitions.
- Execute the named query and retrieve the result rows with paging applied.
What you'll need to have ready
- authorization: HTTP Basic auth header value (e.g. "Basic dXNlcjpwYXNz").
- queryName: The PeopleSoft Query name to execute.
- isConnectedQuery: Whether the named query is a Connected Query.
- maxRows: Maximum number of rows to return.
- offset: Row offset for pagination.
For your developer
Arazzo workflow peoplesoft:query-export, 2 operations: listQueries → executeQuery. Specs on APIs.io.