PeopleSoft

PeopleSoft Queries API

Query execution and management operations

Documentation GitHub OpenAPI

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this

find_apisBrowse and filter every API in the catalog.
get_api_artifactsOne API's artifacts, grouped by type.
get_openapiThe primary OpenAPI for this API.
find_similar_apisAPIs that look like this one.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.

All 92 tools

Call it yourself

curl for this page

This API

curl "https://apis.io/api/v1/apis/peoplesoft-queries-api"

All apis

curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no email required.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

openapi: 3.1.0
info:
  title: PeopleSoft Application Services Framework Accounts Payable Queries API
  description: Modern REST API layer introduced in PeopleTools 8.59 that produces fully compliant OpenAPI/Swagger specifications, supports proper HTTP status codes, uniform URLs, and JSON payloads for integration with Oracle Integration Cloud, mobile apps, and microservices.
  version: 1.0.0
  contact:
    name: Oracle Support
    email: support@oracle.com
    url: https://support.oracle.com
  license:
    name: Proprietary
    url: https://www.oracle.com/contracts/
servers:
- url: https://{hostname}:{port}/psft/asf/v1
  description: PeopleSoft Instance
  variables:
    hostname:
      description: PeopleSoft server hostname
      default: localhost
    port:
      description: PeopleSoft server port
      default: '8000'
tags:
- name: Queries
  description: Query execution and management operations
paths:
  /queries:
    get:
      summary: PeopleSoft List Queries
      description: Retrieve a list of available PeopleSoft Query definitions.
      operationId: listQueries
      tags:
      - Queries
      security:
      - basicAuth: []
      responses:
        '200':
          description: Successful response with query list
          content:
            application/json:
              schema:
                type: object
                properties:
                  queries:
                    type: array
                    items:
                      type: object
                      properties:
                        queryName:
                          type: string
                        description:
                          type: string
                        folder:
                          type: string
        '401':
          description: Unauthorized
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /queries/{queryName}:
    get:
      summary: PeopleSoft Execute Query
      description: Execute a PeopleSoft Query by name and retrieve results.
      operationId: executeQuery
      tags:
      - Queries
      security:
      - basicAuth: []
      parameters:
      - name: queryName
        in: path
        required: true
        description: The PeopleSoft Query name
        schema:
          type: string
        example: Example Record
      - name: isConnectedQuery
        in: query
        description: Whether this is a Connected Query
        schema:
          type: boolean
          default: false
        example: true
      - name: maxRows
        in: query
        description: Maximum number of rows to return
        schema:
          type: integer
        example: 42
      - name: offset
        in: query
        description: Row offset for pagination
        schema:
          type: integer
        example: 42
      responses:
        '200':
          description: Query results
          content:
            application/json:
              schema:
                type: object
                properties:
                  rows:
                    type: array
                    items:
                      type: object
                  totalRows:
                    type: integer
        '401':
          description: Unauthorized
        '404':
          description: Query not found
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
components:
  securitySchemes:
    basicAuth:
      type: http
      scheme: basic
    oauth2:
      type: oauth2
      flows:
        authorizationCode:
          authorizationUrl: https://{hostname}:{port}/psft/oauth/authorize
          tokenUrl: https://{hostname}:{port}/psft/oauth/token
          scopes: {}
externalDocs:
  description: Application Services Framework Documentation
  url: https://docs.oracle.com/cd/E52319_01/infoportal/asf.html