Knowledgebase

Tips and tricks to work with formulas.

Articles

Formula Builder - Formulas and Multiple Triggers
Despite the fact that JSON has triggers as an array, you cannot define a to have multiple triggers. However, you can always manually trigger a that does not have the manual trigger by executing the through the POST /formulas/instances/{instanceI...
Formula Builder: Separating Email Addresses in Notification Settings
When specifying multiple email addresses in a step or in the notification settings of the instance, the email separator is the ,(comma).  For example:  df@fake.com ,dm@fake.com ...
Javascript in Formulas
You can choose from several step types that allow you to write your own custom Javascript. The function signature for all JS-related step types looks like: /** * @param trigger The trigger that started this execution * @param steps The li...
How to Use Bulk Within a Formula
Doing bulk within a can be a little difficult. Bulk by nature is an asynchronous job, while are a synchronous procedure. One way to get them to work together is via webhooks. There are two ways to know when a bulk job is completed. You can poll t...
Retrying with amqpRequest Step
If you have a service that is using the AMQP protocol and you want to build that into your but there is no option to retry the step upon failure, offers a solution. The basic idea behind the httpRequest step retry step option is to do just that, ...
How can I pass data between formula steps?
Sharing data between steps can be somewhat confusing when writing your first .  All steps make data available to other steps by exposing variables with the results of executing the step.  For most step types, this is specific to the partic...
Can you send notifications to a webhook in a formula step?
You can use a "httpRequest" Step to make a HTTP Request to any URL. You can choose the method to use (like POST), the headers and the body. You can also configure the expected Responses and steps on success or failure to the HTTP call. For...
Automatic Cleanup of Temporary Formula Instances
If temporary are a part of your use case, utilize the Time To Live setting for your instances.  To use this setting, provide the amount of time a instance should exist in seconds. After this amount of time has lapsed, the instance is automat...
Replaying Formula Executions Via API
Use the PUT /formulas/instances/executions/{executionId}/retries endpoint to replay executions via API.  We keep executions for a maximum of three days after which they can no longer be replayed.   To find and replay failed executions...
Formula Data Context Example
Below is an example of the actual data you have access to in a , and the structure of that data.  { "trigger": { }, "steps": { "stepname": { } }, "config": { ...
Searching Formula Executions
executions can be queried only by the ObjectID from the trigger of the execution. You cannot query by ExecutionID. To query an ObjectID to return the expected execution, the ObjectID in the trigger event must have been recorded within the last th...
Formulas - How to Aggregate Loop Step Results
To aggregate the results from a loop in a formula, use the last step of the loop as an aggregator. For example, you can make a Javascript step called aggregator   and use use the following code snippet: let arr = steps.aggregator ? steps.agg...