Knowledge Base
Welcome to the Knowledge Base. Here you will find an ever expanding list of technical knowledge mostly around PeopleTools technology. However, other areas are covered here as well.
Recent Articles
SQL Generator To Delete EMPLIDs
An Example of a SQL that generates a series of delete statements for every PeopleSoft table that contains the EMPLID field.
Compare Permissions on Two Roles
A useful SQL statement to compare to roles and see what differs
(Opinionated) App Engine Template
This article shows a template application engine that you can use which is entirely PeopleCode and NO SQL objects. It will help you have more simple and maintainable application engine program
Integrating Student Data into PeopleSoft Campus Solutions - A Practical Guide
A high level overview of integrating with PeopleSoft Campus Solutions for admitting students.
New IB Book Section - HttpTargetConnector
A new book chapter about HttpTargetConnector
Knowledge Base Content by Category
All KB articles organized by category.
Administration
SQL Generator To Delete EMPLIDs
An Example of a SQL that generates a series of delete statements for every PeopleSoft table that contains the EMPLID field.
Admissions
Integrating Student Data into PeopleSoft Campus Solutions - A Practical Guide
A high level overview of integrating with PeopleSoft Campus Solutions for admitting students.
Application engine
(Opinionated) App Engine Template
This article shows a template application engine that you can use which is entirely PeopleCode and NO SQL objects. It will help you have more simple and maintainable application engine program
PeopleSoft Daemon Application Engine Example
An example usage of a daemon Application Engine
SFTP Example using PeopleCode
A PeopleCode example of using sftp to transfer a file.
How to get files to show up in the Process Monitor/Report Repository
A common problem for SQR and application engine developers is how to make files generated in SQR and Application Engine accessible to the end user(s).
Some Thoughts on Application Engine Temporary Tables
Pros and cons of using temp tables.
Campus solutions
Integrating Student Data into PeopleSoft Campus Solutions - A Practical Guide
A high level overview of integrating with PeopleSoft Campus Solutions for admitting students.
Component interface
Strategies to Integrate with PeopleSoft
New book chapter on strategies to integration with PeopleSoft.
Best Practices with PeopleSoft Table Updates and Inserts
New book chapter on table update strategies in PeopleSoft.
Find Component Interfaces with NO Menu Attached
SQL audit to find problematic CI's for event mapping
Should You Expose a Component Interface as a Web Service
Should you expose a CI Definition as a web service?
An Example of using the CI Find Method
An example looking at CS Course Catalog Component Interface to use the Component Interface Find Method.
ScrollSort and Component Interface Lost Pointer
An issue with ScrollSort and Component Interface.
Page and Component Interface: A Warning
A warning about %page and Component Interface
Criteria to Use Component Interface
What Criteria should lead to the use of CI?
Should I Re-use An Existing Component Interface (CI) Definition Or Create A New One?
Should you create a new CI definition if one already exists?
Using ExcelTOCI to Delete a User Profile
A walk-thru for using excel to CI to call the DELETE_USER_PROFILE component interface.
PeopleCode Events that do not fire in Component Interface
A summary of the PeopleCode events that do not fire in Component Interface.
Signs you should be using a Component Interface
Some indications of when you should be using CI.
Component Interface EditHistoryItems Gotcha
When you are writing code against a Component Interface API, there is an important boolean property on the CI called EditHistoryItems.
Limitations of PeopleTools Component Interfaces and Web Services
We documented some limitations with Component Interface that are useful to publish.
Stop Using Page Activate PeopleCode
Read about the dangers of using Page Activate PeopleCode
Problems with Component Interface and COBOL remotecalls
Having problems with remote call and component interface?
How to Change Search Records in Component Interface
There are times when coding with **Component Interface** that you need a different search record that the one defined on the component.
How to Press a Button in Component Interface
When developing with component interfaces you often need to mimic a user pressing a button on the page.
Deleting Rows in ExcelToCI
A quick code fix to allow for row deletions in excelToCI.
Find Missing Component Interfaces for user
This sql should find component interfaces that a specific user does not have.
10 Step Component Interface Development Process
10 steps to follow when coding using a CI.
Debugging
Resolving "Highlighted fields are required (15,30)" Errors
A quick hack to resolve 15,30 error messages.
PeopleTools Cache Clearing Guide
Some guidelines on different types of PeopleSoft Cache.
The Importance of Having a Unit Test Page
An example of my simple Unit Test page that has saved me hours of development time.
DataDumper Documentation
Documentation for our datadumper application package.
Introduction to the DataDumper Logger
Introduction to the CHG_DataDumper Application Class used for logging.
Design
(Opinionated) App Engine Template
This article shows a template application engine that you can use which is entirely PeopleCode and NO SQL objects. It will help you have more simple and maintainable application engine program
SAML Authentication in PeopleSoft
A summary of SAML authentication software for PeopleSoft PeopleSoft.
Should You Expose a Component Interface as a Web Service
Should you expose a CI Definition as a web service?
PeopleSoft FluidUI Resources
Resources for Learning PeopleSoft Fluid UI.
Understanding Local Integration Broker Routings
A look into the who, what, when, where, why of local integration broker service operations.
How to Bypass a PeopleSoft search record
Ways to bypass a PeopleSoft search record
Should I Re-use An Existing Component Interface (CI) Definition Or Create A New One?
Should you create a new CI definition if one already exists?
Some Options for Sending Emails in PeopleTools
Some options and thoughts on sending email from PeopleSoft/PeopleTools
Some Strengths And Weaknesses Of PeopleTools
Some thoughts on what PeopleTools is good and bad at.
The Pros and Cons of PeopleSoft Bolt-ons versus Customization's
Some pros and cons for bolt-ons versus customization
Should I ever use the current date in SQL?
If you are using the current date in SQL, you are probably setting yourself up for a disaster.
Design Principles
Some thoughts on effective design
PeopleCode Events that do not fire in Component Interface
A summary of the PeopleCode events that do not fire in Component Interface.
Removing MS Word Smart quotes in PeopleSoft Pages
How to remove MS Word smart quotes that get turned into upside down question marks.
The Importance of Having a Unit Test Page
An example of my simple Unit Test page that has saved me hours of development time.
Creating an Effective Audit Subrecord
An overview of an audit subrecord you should have on all your custom records.
File Attachment Storage Options
Pros and cons of different storage options.
Signs you should be using a Component Interface
Some indications of when you should be using CI.
A Better Run Control Page Standard
A new run control record proposal
The only Peoplecode events you should be using
Key Peoplecode events to use
Using Record Objects to perform inserts and updates
Advantages of using Record Objects to do inserts
Limitations of PeopleTools Component Interfaces and Web Services
We documented some limitations with Component Interface that are useful to publish.
Stop Using Page Activate PeopleCode
Read about the dangers of using Page Activate PeopleCode
Avoid Global Variables with query string parameters
Global variables are evil!
Effectively Organizing your PeopleCode
Some tips on how to organize your PeopleCode better.
Making Pretty Page Text with HTML Areas
Do you want to give your users readable formatted messages and instructions?
Some Thoughts on Application Engine Temporary Tables
Pros and cons of using temp tables.
Using Record Objects as Parameters and Returns
This article contains some discussion around using record objects and function parameters.
Effdt
Should I ever use the current date in SQL?
If you are using the current date in SQL, you are probably setting yourself up for a disaster.
Fluid
PeopleSoft FluidUI Resources
Resources for Learning PeopleSoft Fluid UI.
Integration
Integrating Student Data into PeopleSoft Campus Solutions - A Practical Guide
A high level overview of integrating with PeopleSoft Campus Solutions for admitting students.
Integration broker
New IB Book Section - HttpTargetConnector
A new book chapter about HttpTargetConnector
Strategies to Integrate with PeopleSoft
New book chapter on strategies to integration with PeopleSoft.
Best Practices with PeopleSoft Table Updates and Inserts
New book chapter on table update strategies in PeopleSoft.
REST HTTP DELETE Example
A full REST Delete Example
REST HTTP Post Example
A full REST Post Example
How set HTTP Status codes in REST
Example code and documentation on controlling the HTTP status codes in REST web services.
How to use the SetRestCache Method
Using REST Cache in PeopleSoft REST Web Services.
JSON Parsing Using PeopleTools JsonParser
An example of using JSON parsing built into PeopleSoft starting in 8.55 with JsonParser.
PsoftToXML Application Class - Convert PeopleSoft Object to XML
PeopleCode Application Class that converts a Peoplesoft Object to XML for web services.
REST Web Services - Generating and Working with Error Responses
A look at sending error responses in PeopleSoft REST web services and some nuances with using them.
A Complete PeopleSoft REST Web Service Example
A complete example of providing a REST web service in PeopleSoft.
JSONtoXML Application Class - An Alternative Method to Parse JSON in Peoplecode
A new custom solution to convert JSON to XML in PeopleSoft. It makes parsing JSON in PeopleCode easier.
A look at the 'List of Values' (SCC_GET_LOV) Web Service
This article looks at the PeopleSoft Campus Solutions "List of Values" (SCC\_GET\_LOV) web service which a third party can pull setup data out of PeopleSoft. It is helpful for integrations.
Using Chunking Rules with OnRouteSend PeopleCode
A look at using OnRouteSend Combined with PeopleCode\
What are FULLSYNC Chunking Rules?
A look at FULLSYNC chunking rules
Using Apache HttpClient from PeopleCode
Some code examples of using Apache httpClient from PeopleCode (bypassing Integration Broker)
PeopleTools REST Based Web Services Removing Response
A look at a strange issue/bug/limitation of calling a REST based service from PeopleSoft.
Delay Processing in Inbound Asynchronous Subscription Handlers
A look at how the PeopleTools integration broker delay processing works.
JSON Parsing Limitations in 8.53
A warning in 8.53 JSON parsing limitations.
Using SwitchUser in Integration Broker Subscriptions
An example of using switchuser to change user context in subscription PeopleCode.
Parsing Cookies in Integration Broker Request Handler
An example method of parsing cookies in an integration broker handler.
Deleting Service Operation Log Tables During Development
An alternative to appmsgpurgeall.dms for one service operation.
Properly Securing the ANONYMOUS IB Node
Some notes and warnings about the Anonymous node configuration.
Find and Audit Active Service Operations
Some SQL that will show you active service operations
How to FULLSYNC tables between PeopleSoft databases
This will show you how you can easily do a FULLSYNC of a table from one PeopleSoft database to another with mostly setup and a small amount of generic code.
Understanding Local Integration Broker Routings
A look into the who, what, when, where, why of local integration broker service operations.
Synchronous HTTP Post to PeopleSoft Integration Broker using Python
An example python script that post a synchronous message to the PeopleSoft Integration broker HTTP connector and gets a response.
HTTP Post to PeopleSoft Integration Broker using Python
An example python script that posts to the PeopleSoft Integration broker HTTP connector.
Why Exclude PSFT Auth Tokens in Integration Broker?
Some thoughts on excluding PSFT Auth token to simplify security for Web Services
Understanding the difference between SYNC and FULLSYNC integrations
An Explanation of the differences and limitations of FULLSYNC and SYNC PeopleSoft Service Operations.
Getting Integration Broker Code to Run as a Different User
We will explore how to run integration broker code as another user.
8.52 and REST support in Integration Broker
Some updated information on REST API support
Understanding Integration Broker Queue Partitioning
This article will explain Message Queue partitioning in PeopleTools Integration Broker.
HTTP Form Posts and the PeopleTools Integration Broker
When integrating with 3rd Party applications the question often comes up can the PeopleTools integration broker handle http from post data either sending or receiving. The short answer is no.
Will PeopleSoft Support REST Web Services?
For PeopleTools 8.51 and lower the answer is **No**.
Understanding the Integration Broker Monitor
A look at how to use the Integration Broker Monitor page.
High Level Overview of Integration Broker Publishing Steps
The Application Messaging / Integration Broker is a complicated PeopleSoft module and can be very confusing if you don’t know what to look for.
Java
Renaming files using PeopleCode
A simple code example to rename or move a file in PeopleCode.
Using Apache HttpClient from PeopleCode
Some code examples of using Apache httpClient from PeopleCode (bypassing Integration Broker)
Doing more with files with Java and PeopleCode
Some code examples of using java within PeopleCode.
JSON
JSON Parsing Using PeopleTools JsonParser
An example of using JSON parsing built into PeopleSoft starting in 8.55 with JsonParser.
JSON Parsing using PeopleCode Classes Starting in PeopleTools 8.55.11
A newly discovered JSON parsing PeopleCode Class in 8.55.11
Reporting Web Services :REST JSON Responses
Using the REST Reporting Web Services to get a JSON response
JSONtoXML Application Class - An Alternative Method to Parse JSON in Peoplecode
A new custom solution to convert JSON to XML in PeopleSoft. It makes parsing JSON in PeopleCode easier.
JSON Parsing Limitations in 8.53
A warning in 8.53 JSON parsing limitations.
Most read
JSON Parsing Using PeopleTools JsonParser
An example of using JSON parsing built into PeopleSoft starting in 8.55 with JsonParser.
REST Web Services - Generating and Working with Error Responses
A look at sending error responses in PeopleSoft REST web services and some nuances with using them.
SAML Authentication in PeopleSoft
A summary of SAML authentication software for PeopleSoft PeopleSoft.
JSON Parsing using PeopleCode Classes Starting in PeopleTools 8.55.11
A newly discovered JSON parsing PeopleCode Class in 8.55.11
A Complete PeopleSoft REST Web Service Example
A complete example of providing a REST web service in PeopleSoft.
Resolving "Highlighted fields are required (15,30)" Errors
A quick hack to resolve 15,30 error messages.
PeopleSoft FluidUI Resources
Resources for Learning PeopleSoft Fluid UI.
How to Bypass a PeopleSoft search record
Ways to bypass a PeopleSoft search record
The PSACCESSLOG PeopleTools Table Explained
A look at the PSACCESSLOG security table.
How to get files to show up in the Process Monitor/Report Repository
A common problem for SQR and application engine developers is how to make files generated in SQR and Application Engine accessible to the end user(s).
Online development
How to Bypass a PeopleSoft search record
Ways to bypass a PeopleSoft search record
A Better Run Control Page Standard
A new run control record proposal
Making Pretty Page Text with HTML Areas
Do you want to give your users readable formatted messages and instructions?
Peoplecode
(Opinionated) App Engine Template
This article shows a template application engine that you can use which is entirely PeopleCode and NO SQL objects. It will help you have more simple and maintainable application engine program
Strategies to Integrate with PeopleSoft
New book chapter on strategies to integration with PeopleSoft.
Best Practices with PeopleSoft Table Updates and Inserts
New book chapter on table update strategies in PeopleSoft.
REST HTTP DELETE Example
A full REST Delete Example
REST HTTP Post Example
A full REST Post Example
How set HTTP Status codes in REST
Example code and documentation on controlling the HTTP status codes in REST web services.
Find Component Interfaces with NO Menu Attached
SQL audit to find problematic CI's for event mapping
How to use the SetRestCache Method
Using REST Cache in PeopleSoft REST Web Services.
JSON Parsing Using PeopleTools JsonParser
An example of using JSON parsing built into PeopleSoft starting in 8.55 with JsonParser.
PsoftToXML Application Class - Convert PeopleSoft Object to XML
PeopleCode Application Class that converts a Peoplesoft Object to XML for web services.
REST Web Services - Generating and Working with Error Responses
A look at sending error responses in PeopleSoft REST web services and some nuances with using them.
JSON Parsing using PeopleCode Classes Starting in PeopleTools 8.55.11
A newly discovered JSON parsing PeopleCode Class in 8.55.11
PeopleCode Function To Validate Email
PeopleCode email REGEX Function
Using Sign On PeopleCode to redirect Users to Specific pages
Some examples of how to redirect user to specific pages at login.
A Complete PeopleSoft REST Web Service Example
A complete example of providing a REST web service in PeopleSoft.
Renaming files using PeopleCode
A simple code example to rename or move a file in PeopleCode.
JSONtoXML Application Class - An Alternative Method to Parse JSON in Peoplecode
A new custom solution to convert JSON to XML in PeopleSoft. It makes parsing JSON in PeopleCode easier.
Executing System Commands from PeopleCode and Getting STDOUT
Some PeopleCode examples to run operations system commands from PeopleCode and get the output.
New 8.55 Feature - Assigning Application Class PeopleCode to Component Events
A new 8.55 feature that may reduce the amount of custom PeopleCode.
An Example of using the CI Find Method
An example looking at CS Course Catalog Component Interface to use the Component Interface Find Method.
Resolving "Highlighted fields are required (15,30)" Errors
A quick hack to resolve 15,30 error messages.
Page and Component Interface: A Warning
A warning about %page and Component Interface
Using Apache HttpClient from PeopleCode
Some code examples of using Apache httpClient from PeopleCode (bypassing Integration Broker)
JSON Parsing Limitations in 8.53
A warning in 8.53 JSON parsing limitations.
How to FULLSYNC tables between PeopleSoft databases
This will show you how you can easily do a FULLSYNC of a table from one PeopleSoft database to another with mostly setup and a small amount of generic code.
Criteria to Use Component Interface
What Criteria should lead to the use of CI?
HTTP Post to PeopleSoft Integration Broker using Python
An example python script that posts to the PeopleSoft Integration broker HTTP connector.
Application Classes and Global Variables are like Oil and Water
An example of the perils of using Global Variables in your Application Classes
Understanding the difference between SYNC and FULLSYNC integrations
An Explanation of the differences and limitations of FULLSYNC and SYNC PeopleSoft Service Operations.
Linking Between PeopleSoft Components in HTML
How you can link between two PeopleSoft components using an "a" HTML tag.
Running a PeopleSoft Query with Ruby over HTTP
Some ruby code showing how to extract data from PeopleSoft over HTTP.
Some Options for Sending Emails in PeopleTools
Some options and thoughts on sending email from PeopleSoft/PeopleTools
How to Cancel a Queued Process in PeopleCode
Here is a sample PeopleCode snippet to cancel a process request.
PeopleTools Cache Clearing Guide
Some guidelines on different types of PeopleSoft Cache.
PeopleCode Events that do not fire in Component Interface
A summary of the PeopleCode events that do not fire in Component Interface.
The PeopleTools Component Object Model
An overview of the PeopleSoft Component object model.
Understanding PeopleCode Current Context functions
Understanding the PeopleCode current context functions: getrow(), getrowset(), and getfield()
SFTP Example using PeopleCode
A PeopleCode example of using sftp to transfer a file.
Removing MS Word Smart quotes in PeopleSoft Pages
How to remove MS Word smart quotes that get turned into upside down question marks.
Create a PDF file in PeopleCode using the Query API
An example of how to create a PDF file using PeopleCode and the Query API.
The Importance of Having a Unit Test Page
An example of my simple Unit Test page that has saved me hours of development time.
Creating an Effective Audit Subrecord
An overview of an audit subrecord you should have on all your custom records.
File Attachment Storage Options
Pros and cons of different storage options.
Word Count in PeopleCode Using Regular Expressions
PeopleCode example to get word count using java regular expressions
The only Peoplecode events you should be using
Key Peoplecode events to use
Using Record Objects to perform inserts and updates
Advantages of using Record Objects to do inserts
Effectively Customizing Online Pages with PeopleCode
A few tips on how effectively customize a page with PeopleCode
Explaining the PeopleCode @ operator
Have you ever seen the PeopleCode @ operator and wondered when and why you would use it?
Using SQLExec and Record Objects
Here is a quick code snippet to show how to use SQLExec to pull data into a record object not using the key fields of the record.
Running Dynamic SQL with SQLEXEC
How to run Dynamic SQL in PeopleCode
Stop Using Page Activate PeopleCode
Read about the dangers of using Page Activate PeopleCode
Avoid Global Variables with query string parameters
Global variables are evil!
Effectively Organizing your PeopleCode
Some tips on how to organize your PeopleCode better.
DataDumper Documentation
Documentation for our datadumper application package.
Doing more with files with Java and PeopleCode
Some code examples of using java within PeopleCode.
Introduction to the DataDumper Logger
Introduction to the CHG_DataDumper Application Class used for logging.
Signon PeopleCode and 3rd party connections
A note about 3rd party CI connections and signon PeopleCode.
Using Record Objects as Parameters and Returns
This article contains some discussion around using record objects and function parameters.
Accessing Related Fields in PeopleCode
How to programmatically access related fields in PeopleCode.
Copy Field values between different records
Copy like named fields between two different records.
Create Excel Files in SQR and PeopleCode
An open source project that creates Office XML files from SQR.
Peopletools
Find Component Interfaces with NO Menu Attached
SQL audit to find problematic CI's for event mapping
A Look at the PSPTLOGINAUDIT Security Table
Exploring the PSPTLOGINAUDIT PeopleTools Table
New 8.55 Feature - Assigning Application Class PeopleCode to Component Events
A new 8.55 feature that may reduce the amount of custom PeopleCode.
Resolving "Highlighted fields are required (15,30)" Errors
A quick hack to resolve 15,30 error messages.
PeopleSoft FluidUI Resources
Resources for Learning PeopleSoft Fluid UI.
How to Visually Compare Two Pages in Application Designer
We show how to visually compare a page between two databases or a file.
A Simple Procedure to Compare Application Designer Projects Prior to a DB Refresh
Two methods to determine what Application Designer Projects are different between databases. This is useful prior to a refresh.
List URLs Accessible to a Permission List
Sample SQL to generate a list of component based URL accessible by a permission list.
Some Strengths And Weaknesses Of PeopleTools
Some thoughts on what PeopleTools is good and bad at.
The PSACCESSLOG PeopleTools Table Explained
A look at the PSACCESSLOG security table.
My Love Hate Relationship with PeopleTools Development
Some things I love and hate about PeopleTools development
The PeopleTools Component Object Model
An overview of the PeopleSoft Component object model.
Find Tables with Specific Field Names
Have you ever wanted to find a table that had specific combination of fields on it?
PeopleTools Tables - The Important Ones
List of Key PeopleTools Tables
Updating PS Query References in the Tools Tables
How to update query record references from the back-end.
Portal
Find and Delete Empty Portal CREF Folder Permissions
Some SQL to find and delete Portal CREF permissions where there are no children.
Migrate PeopleSoft Enterprise Portal Managed Content Data with DMS
A DMS script to migrate managed content data between databases.
Deleting Portal User favorites
How to delete user favorites
Find Missing Portal Pagelets on a user’s home page
Here is query that will find those missing missing pagelets.
Find Portal CREF in Navigation
Here is a quick way to find where a component shows up in the portal navigation for a given component.
Force a CREF Open in a New Window
Here is a quick tip to make a portal Content Reference (CREF) open in a new window.
Adding Custom CREF Images to Folders
How to add custom images to a portal CREF
Process scheduler
A Look at Max Concurrent Process Definition Property
A look at the "Max Concurrent" process definition property
Can I Guarantee a Process Will Run at a Certain Time?
I schedule a process to run at 9 pm but it did not run until 2am? Why?
How to Cancel a Queued Process in PeopleCode
Here is a sample PeopleCode snippet to cancel a process request.
How to get files to show up in the Process Monitor/Report Repository
A common problem for SQR and application engine developers is how to make files generated in SQR and Application Engine accessible to the end user(s).
Unique Constraint Error on PS_MESSAGE_LOG
ORA-00001: unique constraint (SYSADM.PS_MESSAGE_LOG) violated
Python
Synchronous HTTP Post to PeopleSoft Integration Broker using Python
An example python script that post a synchronous message to the PeopleSoft Integration broker HTTP connector and gets a response.
HTTP Post to PeopleSoft Integration Broker using Python
An example python script that posts to the PeopleSoft Integration broker HTTP connector.
Query
Reporting Web Services: Using the REST Web Services to run a Query
Using the REST Reporting Web Services in PeopleSoft to run a query.
Updating PS Query References in the Tools Tables
How to update query record references from the back-end.
Rest
REST HTTP DELETE Example
A full REST Delete Example
REST HTTP Post Example
A full REST Post Example
How set HTTP Status codes in REST
Example code and documentation on controlling the HTTP status codes in REST web services.
How to use the SetRestCache Method
Using REST Cache in PeopleSoft REST Web Services.
JSON Parsing Using PeopleTools JsonParser
An example of using JSON parsing built into PeopleSoft starting in 8.55 with JsonParser.
PsoftToXML Application Class - Convert PeopleSoft Object to XML
PeopleCode Application Class that converts a Peoplesoft Object to XML for web services.
REST Web Services - Generating and Working with Error Responses
A look at sending error responses in PeopleSoft REST web services and some nuances with using them.
JSON Parsing using PeopleCode Classes Starting in PeopleTools 8.55.11
A newly discovered JSON parsing PeopleCode Class in 8.55.11
A Complete PeopleSoft REST Web Service Example
A complete example of providing a REST web service in PeopleSoft.
JSONtoXML Application Class - An Alternative Method to Parse JSON in Peoplecode
A new custom solution to convert JSON to XML in PeopleSoft. It makes parsing JSON in PeopleCode easier.
Reporting Web Services: Using the REST Web Services to run a Query
Using the REST Reporting Web Services in PeopleSoft to run a query.
Using Apache HttpClient from PeopleCode
Some code examples of using Apache httpClient from PeopleCode (bypassing Integration Broker)
PeopleTools REST Based Web Services Removing Response
A look at a strange issue/bug/limitation of calling a REST based service from PeopleSoft.
JSON Parsing Limitations in 8.53
A warning in 8.53 JSON parsing limitations.
PeopleSoft RESTListeningConnector Not So "RESTful"
RESTListeningConnector not returning RESTful faults.
8.52 and REST support in Integration Broker
Some updated information on REST API support
Will PeopleSoft Support REST Web Services?
For PeopleTools 8.51 and lower the answer is **No**.
Ruby
Running a PeopleSoft Query with Ruby over HTTP
Some ruby code showing how to extract data from PeopleSoft over HTTP.
Saml
SAML Authentication in PeopleSoft
A summary of SAML authentication software for PeopleSoft PeopleSoft.
Security
Compare Permissions on Two Roles
A useful SQL statement to compare to roles and see what differs
SAML Authentication in PeopleSoft
A summary of SAML authentication software for PeopleSoft PeopleSoft.
Using Sign On PeopleCode to redirect Users to Specific pages
Some examples of how to redirect user to specific pages at login.
A Look at the PSPTLOGINAUDIT Security Table
Exploring the PSPTLOGINAUDIT PeopleTools Table
Properly Securing the ANONYMOUS IB Node
Some notes and warnings about the Anonymous node configuration.
Why Exclude PSFT Auth Tokens in Integration Broker?
Some thoughts on excluding PSFT Auth token to simplify security for Web Services
Find and Delete Empty Portal CREF Folder Permissions
Some SQL to find and delete Portal CREF permissions where there are no children.
List URLs Accessible to a Permission List
Sample SQL to generate a list of component based URL accessible by a permission list.
Data Security and Self Service Search Records
An explanation of search records for self-service components.
The PSACCESSLOG PeopleTools Table Explained
A look at the PSACCESSLOG security table.
Find Missing Component Interfaces for user
This sql should find component interfaces that a specific user does not have.
Find Unused Permission Lists
This query should find unused permission lists that could be deleted.
Password Extractor
This script will extract password as an update statement to be moved to another database.
Reset Password from back end
Reset a user's password via the back end.
Signon PeopleCode and 3rd party connections
A note about 3rd party CI connections and signon PeopleCode.
Back End Role Insert
A simple script to insert roles into a user via SQL.
SQL
SQL Generator To Delete EMPLIDs
An Example of a SQL that generates a series of delete statements for every PeopleSoft table that contains the EMPLID field.
Sqr
How to get files to show up in the Process Monitor/Report Repository
A common problem for SQR and application engine developers is how to make files generated in SQR and Application Engine accessible to the end user(s).
Create Excel Files in SQR and PeopleCode
An open source project that creates Office XML files from SQR.
Upgrade
Updating PS Query References in the Tools Tables
How to update query record references from the back-end.
Web services
Reporting Web Services :REST JSON Responses
Using the REST Reporting Web Services to get a JSON response
Reporting Web Services: Using the REST Web Services to run a Query
Using the REST Reporting Web Services in PeopleSoft to run a query.
A look at the 'List of Values' (SCC_GET_LOV) Web Service
This article looks at the PeopleSoft Campus Solutions "List of Values" (SCC\_GET\_LOV) web service which a third party can pull setup data out of PeopleSoft. It is helpful for integrations.
Running a PeopleSoft Query using the Reporting Web Services
Using the Reporting Web Services in PeopleSoft to run a query.
Should You Expose a Component Interface as a Web Service
Should you expose a CI Definition as a web service?
PeopleTools REST Based Web Services Removing Response
A look at a strange issue/bug/limitation of calling a REST based service from PeopleSoft.
Find and Audit Active Service Operations
Some SQL that will show you active service operations
How to FULLSYNC tables between PeopleSoft databases
This will show you how you can easily do a FULLSYNC of a table from one PeopleSoft database to another with mostly setup and a small amount of generic code.
PeopleSoft RESTListeningConnector Not So "RESTful"
RESTListeningConnector not returning RESTful faults.
Synchronous HTTP Post to PeopleSoft Integration Broker using Python
An example python script that post a synchronous message to the PeopleSoft Integration broker HTTP connector and gets a response.
HTTP Post to PeopleSoft Integration Broker using Python
An example python script that posts to the PeopleSoft Integration broker HTTP connector.
Understanding the difference between SYNC and FULLSYNC integrations
An Explanation of the differences and limitations of FULLSYNC and SYNC PeopleSoft Service Operations.
Running a PeopleSoft Query with Ruby over HTTP
Some ruby code showing how to extract data from PeopleSoft over HTTP.
Should I Re-use An Existing Component Interface (CI) Definition Or Create A New One?
Should you create a new CI definition if one already exists?
8.52 and REST support in Integration Broker
Some updated information on REST API support
Limitations of PeopleTools Component Interfaces and Web Services
We documented some limitations with Component Interface that are useful to publish.
HTTP Form Posts and the PeopleTools Integration Broker
When integrating with 3rd Party applications the question often comes up can the PeopleTools integration broker handle http from post data either sending or receiving. The short answer is no.
Will PeopleSoft Support REST Web Services?
For PeopleTools 8.51 and lower the answer is **No**.