How to query multiple buffer lookups in one step

If you require to query multiple buffer lookups in one step, there is a Buffer Query Lookup step that is now available! It assists with flow optimization and flow performance as a bonus.

Illustrated below is an example of a part of a flow where multiple buffer lookup steps are used

To optimize the buffer lookup steps in the flow, you can query the buffer lookups in one step using the Buffer Query Lookup step. To add a buffer and a query to lookup on, click on the highlighted Add Lookup button in the below image. Select the concurrent method you require for the lookup/s. Prefer Secondary is reading the data from a second instance which is quicker to lookup but the results may be a bit delayed.

The below page will appear when you click on the Add Lookup button. You can add multiple lookups by clicking on the Add Lookup button. Type the object name that you require to be returned with the data that is being looked up on from the selected buffer. There is a Limit field of how many records you require to be returned. Select the required buffer by clicking on the drop down list that is circled in red. This will return the buffer ID which is highlighted. Type out your SQL query and you can reference a record in the data set by using {@record.fieldName} in your SQL query. Click on the Validate button to validate your SQL query and save the step. Multiple buffer lookups can be done in this step.

For more complex queries, click on the below link to see the available syntax:

@synatic/sql-to-mongo - npm

How to query a buffer using SQL

How to use the Buffer Lookup step