Alternative to REST API

Clients (like PAWL) with direct SQL Server Database access can use direct access to the ‘tPA_PAASProcessing’ table instead of REST API.

In this chapter, you can read about:

1. How to create a new processing task
2. How to use Task ID from ‘nQId’ field for task monitoring
3. Getting results

1. How to create a new processing task?

For creating a new processing task we preform:

INSERT INTO tPA_PAASProcessing (acCommand, acParameters, acRequestedBy, acRunner) VALUES ('Printing', '{<JSON PRINTING PARAM>}', 'YourRequestID', 'YourRunnerString')

In the background, PAAS.exe monitors the ‘tPA_PAASProcessing’ table in all databases and will notify PANTHEON to execute a new task.

You can monitor ‘anStatus’ field to check execution state.

2. How to use Task ID from ‘nQId’ field for task monitoring

To use the Task ID from ‘nQId’ field for task monitoring we perform:

SELECT anStatus, acResult FROM tPA_PAASProcessing WHERE nQId=<taskID>

3. Getting results

When a task is finished, ‘anStatus’ is 200 or 400.

‘acResult’ then contains a JSON string (with results or error text) that can be decoded to get access to files.

Related topics:

• Meaning and operation of PAAS
• PAAS installation and testing
• Description of REST methods for processing tasks
• Default values and options for PAAS.exe
• Upgrading PAAS
• PANTHEON Automation Server