/
Perfion Execute Action Query
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:
, multiple selections available,
Related content
The Perfion Query - WHERE
The Perfion Query - WHERE
Read with this
Actions Management
Actions Management
More like this
SuperQuery Factsheet
SuperQuery Factsheet
Read with this
Use Global Table To Retrieve Data From Loop
Use Global Table To Retrieve Data From Loop
More like this
Perfion Core - Latest Version
Perfion Core - Latest Version
Read with this
Export to XML (custom format)
Export to XML (custom format)
More like this