/
PeopleSoft Connection Web Services

PeopleSoft Connection Web Services

Owned by Stonebranch (Deactivated)
Last updated: Nov 11, 2024 by Alec Berger

Overview

Universal Controller supports the following RESTful-based web services for PeopleSoft Connection operations, which are listed alphabetically on this page.


Formatting specifications for each web service, including details about property requirements, are provided.

Create a PeopleSoft Connection


Description

URI

http://host_name/uc/resources/peoplesoftconnection

HTTP Method

POST

Description

Creates a PeopleSoft Connection.

Example URI

http://localhost:8080/uc/resources/peoplesoftconnection

Consumes Content-Type

application/xml, application/json

Produces Content-Type

n/a

Example Request

See Create a PeopleSoft Connection: Example Request, below.

Example Response

  • Status 200 /OK
    Successfully created the PeopleSoft Connection with sysId {sysId}.
  • Status 400 /Bad Request
    Create PeopleSoft Connection failed. A duplicate value has been detected. Name must be unique.

PeopleSoft Connection Properties

See PeopleSoft Connection Properties, below.

Create a PeopleSoft Connection: Example Request

XML Request

JSON Request

 XML Request
<peoplesoftConnection retainSysIds="true">
    <credentials>user 1</credentials>
    <description>description</description>
    <endpoint>upps.stone.branch:8080</endpoint>
    <name>PeopleSoft Connection 1</name>
    <opswiseGroups />
    <port>8080</port>
    <server>upps.stone.branch</server>
    <sysId>62701879a6264107bb757a952bcc65cc</sysId>
</peoplesoftConnection>
 JSON Request
{
    "credentials": "user 1",
    "description": "description",
    "endpoint": "upps.stone.branch:8080",
    "name": "PeopleSoft Connection 1",
    "opswiseGroups": null,
    "port": "8080",
    "retainSysIds": true,
    "server": "upps.stone.branch",
    "sysId": "62701879a6264107bb757a952bcc65cc"
}

PeopleSoft Connection Properties

Property

UI Field Name

Description

Specifications

Required

credentials

Credentials

Credentials for the PeopleSoft connection.


N

description

Description

User-defined; description of this record.


N

exportReleaseLevel

n/a

Universal Controller release that the record was exported from.

read onlyN

exportTable

n/aRecord table information.read onlyN

name

Connection Name

Name used within the Controller to identify this PeopleSoft Connection.


Y

endpoint

Endpoint

Web service endpoint for the PROCESSREQUEST service.


Y

opswiseGroups

Member of Business Services

Business Services that this record belongs to.
 
XML


<opswiseGroups>
      <opswiseGroup>group1</opswiseGroup>
      <opswiseGroup>group2</opswiseGroup>
</opswiseGroups>

 
JSON


"opswiseGroups": ["group1","group2"]


N

port

Port

Port number for the PeopleSoft application server.


N

retainSysIds

n/a

Specification for whether or not the Create a PeopleSoft Connection web service will persist the sysId property.

  • If retainSysIds="true" and sysId is included in the request/response, sysId will be persisted to the database.
  • If retainSysIds="false" and sysId is included in the request/response, sysId will be ignored; it will be autogenerated by the Controller.


Note

In XML web services, retainSysIds is specified as an attribute in the <PeopleSoftConnection> element.

Valid values: true/false (default is true).

N

server

Server

Host name of the Name or IP address of the PeopleSoft application server.


Y

sysId

n/a

System ID field in the database for this PeopleSoft Connection record.

Persisted only if retainSysIds is set to true.

N

Delete a PeopleSoft Connection


Description

URI

http://host_name/uc/resources/peoplesoftconnection

HTTP Method

DELETE

Description

Deletes a PeopleSoft Connection.

URI Parameters

See Delete a PeopleSoft Connection: URI Parameters, below.

Example URI

http://localhost:8080/uc/resources/peoplesoftconnection?connectionname=Test4

Example Response

  • Status 200 /OK
    PeopleSoft Connection deleted successfully.
  • Status 400 /Bad Request
    Mutual exclusion violation. Cannot specify connectionname and connectionid at the same time.
  • Status 404 /Not Found
    a PeopleSoft Connection with {name/id} "test" does not exist.

Delete a PeopleSoft Connection: URI Parameters

Parameter

Description

Specifications

Required

Mutually Exclusive With

connectionid

ID used within the Controller to identify this PeopleSoft Connection.

String; URI parameter.

Y
(unless connectionname
is specified)

connectionname

connectionname

Name used within the Controller to identify this PeopleSoft Connection.

String; URI parameter.

Y
(unless connectionid
is specified)

connectionid

List PeopleSoft Connections


Description

URI

http://host_name/uc/resources/peoplesoftconnection/list

HTTP Method

GET

Description

Retrieves information on all PeopleSoft Connections.

Example URI

http://localhost:8080/uc/resources/peoplesoftconnection/list

Authentication

HTTP Basic

Consumes Content-Type

n/a

Produces Content-Type

application/xml, application/json

Example Response

See List PeopleSoft Connections: Example Response, below.

PeopleSoft Connection Properties

See PeopleSoft Connection Properties.

List PeopleSoft Connections: Example Response

XML Response

JSON Response

 XML Response
<peoplesoftConnections>
    <peoplesoftConnection exportReleaseLevel="7.2.0.0" exportTable="ops_peoplesoft_connection" version="7">
        <credentials>user 1</credentials>
        <description>description</description>
        <endpoint>upps.stone.branch:8080</endpoint>
        <name>PeopleSoft Connection 1</name>
        <opswiseGroups />
        <port>8080</port>
        <server>upps.stone.branch</server>
        <sysId>62701879a6264107bb757a952bcc65cc</sysId>
    </peoplesoftConnection>
    <peoplesoftConnection exportReleaseLevel="7.2.0.0" exportTable="ops_peoplesoft_connection" version="2">
        <credentials>user 2</credentials>
        <description>description</description>
        <endpoint>upps.stone.branch:8090</endpoint>
        <name>PeopleSoft Connection 2</name>
        <opswiseGroups />
        <port>8090</port>
        <server>upps.stone.branch</server>
        <sysId>3d7a03053ad64de1b21b6849e6deafd9</sysId>
    </peoplesoftConnection>
<peoplesoftConnections>
 JSON Response
[ {
{
    "credentials": "user 1",
    "description": "description",
    "endpoint": "upps.stone.branch:8080",
    "exportReleaseLevel": "7.2.0.0",
    "exportTable": "ops_peoplesoft_connection",
    "name": "PeopleSoft Connection 1",
    "opswiseGroups": null,
    "port": "8080",
    "server": "upps.stone.branch",
    "sysId": "62701879a6264107bb757a952bcc65cc",
    "version": 7
    },
    {
{
    "credentials": "user 2",
    "description": "description",
    "endpoint": "upps.stone.branch:80p0",
    "exportReleaseLevel": "7.2.0.0",
    "exportTable": "ops_peoplesoft_connection",
    "name": "PeopleSoft Connection 2",
    "opswiseGroups": null,
    "port": "8090",
    "server": "upps.stone.branch",
    "sysId": "3d7a03053ad64de1b21b6849e6deafd9",
    "version": 2
    }
]

Modify a PeopleSoft Connection


Description

URI

http://host_name/uc/resources/peoplesoftconnection

HTTP Method

PUT

Description

Modifies the PeopleSoft Connection specified by the sysId.

Example URI

http://localhost:8080/uc/resources/peoplesoftconnection

Consumes Content-Type

application/xml, application/json

Produces Content-Type

n/a

Example Request

See Modify a PeopleSoft Connection: Example Request, below.

PeopleSoft Connection Properties

See PeopleSoft Connection Properties.

Example Response

  • Status 200 /OK
    Successfully updated the PeopleSoft Connection with sysId <sysId> to version <version>.

Modify a PeopleSoft Connection: Example Request

XML Request

JSON Request

 XML Request
<peoplesoftConnection>
    <credentials>user 1</credentials>
    <description>description</description>
    <endpoint>upps.stone.branch:8080</endpoint>
    <name>PeopleSoft Connection 1</name>
    <opswiseGroups />
    <port>8080</port>
    <server>upps.stone.branch</server>
    <sysId>62701879a6264107bb757a952bcc65cc</sysId>
</peoplesoftConnection>
 JSON Request
{
    "credentials": "user 1",
    "description": "description",
    "endpoint": "upps.stone.branch:8080",
    "name": "PeopleSoft Connection 1",
    "opswiseGroups": null,
    "port": "8080",
    "server": "upps.stone.branch",
    "sysId": "62701879a6264107bb757a952bcc65cc"
}

Read a PeopleSoft Connection

URI

http://host_name/uc/resources/peoplesoftconnection

HTTP Method

GET

Description

Retrieves information on a specific PeopleSoft Connection.

URI Parameters

See Read a PeopleSoft Connection: URI Parameters, below.

Example URI

http://localhost:8080/uc/resources/peoplesoftconnection?connectionname=Test4

Consumes Content-Type

n/a

Produces Content-Type

application/xml, application/json

Example Response

See Read a PeopleSoft Connection: Example Response, below.

PeopleSoft Connection Properties

See PeopleSoft Connection Properties.

Read a PeopleSoft Connection: URI Parameters

Parameter

Description

Specifications

Required

Mutually Exclusive With

connectionid

ID used within the Controller to identify this PeopleSoft Connection.

String; URI parameter.

Y
(unless connectionname
is specified)

connectionname

connectionname

Name used within the Controller to identify this PeopleSoft Connection.

String; URI parameter.

Y
(unless connectionid
is specified)

connectionid

Read a PeopleSoft Connection: Example Response

XML Response

JSON Response

 XML Request
<peoplesoftConnection exportReleaseLevel="7.2.0.0" exportTable="ops_peoplesoft_connection" retainSysIds="true" version="1">
    <credentials>user 1</credentials>
    <description>description</description>
    <endpoint>upps.stone.branch:8080</endpoint>
    <name>PeopleSoft Connection 1</name>
    <opswiseGroups />
    <port>8080</port>
    <server>upps.stone.branch</server>
    <sysId>62701879a6264107bb757a952bcc65cc</sysId>
</peoplesoftConnection>
 JSON Response
{
    "credentials": "user 1",
    "description": "description",
    "endpoint": "upps.stone.branch:8080",
    "exportReleaseLevel": "7.2.0.0",
    "exportTable": "ops_peoplesoft_connection",
    "name": "PeopleSoft Connection 1",
    "opswiseGroups": null,
    "port": "8080",
    "retainSysIds": true,
    "server": "upps.stone.branch",
    "sysId": "62701879a6264107bb757a952bcc65cc",
    "version": 1
}

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Related content

PeopleSoft Connection Web Services
PeopleSoft Connection Web Services
Universal Controller 7.3.x
More like this
PeopleSoft Connection Web Services
PeopleSoft Connection Web Services
Universal Controller 7.2.x
More like this
PeopleSoft Connection Web Services
PeopleSoft Connection Web Services
Universal Controller 7.4.x
More like this
PeopleSoft Connection Web Services
PeopleSoft Connection Web Services
Universal Controller 7.5.x
More like this
PeopleSoft Connection Web Services
PeopleSoft Connection Web Services
Universal Controller 7.6.x
More like this
PeopleSoft Web Services
PeopleSoft Web Services
Universal Agent 7.5.x
More like this