Request types

Otera supports two types of requests:

Run once

This executes your API request a single time. This is useful for bulk imports where you need to import a large dataset from a single API request.

When you choose run once, you can choose these output modes:

• Append: imported data will be added as new rows to your database
• Overwrite: imported data will update and overwrite existing data in your database

Run for each row

This executes your API request multiple times - once for each row in your Notion database. This is useful for when you need to run a new API request based on specific values in your Notion database cell. For example, fetching the stock price for each ticker symbol in your database.

When you choose run for each row, you can choose these output modes:

• Overwrite: imported data will update and overwrite existing data in your database

You'll also be able to use variables (i.e. table values) in your requests.

Run usage

• Run once: counts as a single run toward your monthly limit.
• Run for each row: each row processed counts as one run. For example, if you have 100 rows, this will use 100 runs from your monthly limit.