Perfion Execute Action Query

The Perfion Execute Action query add the requested Action in a queue at the Applications server (Execute Action are introduced in Perfion 2022 R1). The Application server will execute the Action in chronological order from the queue.

The ActionID is the ID of the action to be executed

The ActionInput element is optional and the child elements in ActionInput must be serializable XML/JSON. The elements will be converted to Data Tables which can be used in the Action.

The query can be defined in either XML or JSON format.

XML:

<?xml version="1.0" encoding="utf-8"?>
<ExecuteAction ActionID="1234" >
    <ActionInput>
   <ActionTable1>
                  <Col1>123</Col1>
                  <Col2>456</Col2>
   </ActionTable1>
   <ActionTable1>
                  <Col1>123</Col1>
                  <Col3>456</Col3>
   </ActionTable1>
   <ActionTable2>
                  <Col1>123</Col1>
                  <Col2>456</Col2>
   </ActionTable2>
   </ActionInput>
</ExecuteAction>

XML query response:

<?xml version="1.0" encoding="utf-8"?>
<Response>
    <Result>
           <ExecutionQueueId>12</ExecutionQueueId>
    </Result>
</Response>

JSON:

{
"ExecuteAction": {
"ActionID": "123",
"ActionInput": {
"ActionTable1": {
"Col1": "123",
"Col2": "456" },
"ActionTable1": {
"Col1": "123",
"Col3": "456" },
"ActionTable2": {
"Col1": "123",
"Col2": "456" }
      }
   }
}

JSON query response: