SAP Open Connectors

Searching Formula Executions

Formula executions can be queried using one of the methods below:

1. Using the ObjectID from the trigger of the execution: 

To query an ObjectID to return the expected Formula execution, the ObjectId in the trigger event must have been recorded between three to seven days, since this represents the minimum and maximum amount of time the values are stored. Furthermore, the ObjectId in the trigger must have been generated by a polling or webhook event. If you manually triggered a Formula, then this query by ObjectId cannot locate the event and no Formula executions are returned by the query.

When a poller receives a new event that triggers a Formula execution, the objectId from the poller event aligns with the Formula execution trigger and a query retrieves the expected Formula execution. Note that if you have a Notified event that contains multiple ObjectId attributes in the events array, then a query of Formula Executions for any one of those ObjectId attributes result in all Formula executions being returned. The Formula execution query retrieves executions based on the event level.

2. Using ExecutionID of the execution:

In this method, the ExecutionId obtained after an execution trigger can be used to search for that execution. The ExecutionId can be at most seven days old.