Append Mode

When you use Append Mode in Note API Connector, the tool always adds new rows to your Notion database. It never changes or deletes existing rows, whether they were created manually, by another request, or during a previous import.

This mode is perfect when you want to keep a growing log of data or import new records without touching old ones.

How It Works

Imagine you’re importing orders from your online store:

• Today, your API returns 10 orders.
• Tomorrow, you run the request again and your API now has 15 orders — 10 old ones and 5 new ones.
• Append Mode will only add the 5 new orders to Notion. The original 10 stay exactly the same.

Using Query Parameter & Response Field

Append Mode works best when you tell Note API Connector how to fetch only new records.

1. Query Parameter — the name of the filter your API uses for “created after” or “updated after” dates (e.g., created_after, updated_at_min, modifiedAfter)
2. Response Field — the date or time field from your API response (e.g., created_at, updated_at) that the connector will use to remember the latest record’s timestamp.

When you run the import, the connector will:

• Record the latest timestamp from your chosen field.
• Add your Query Parameter to the next API call, so it only fetches data after that timestamp.
• Append only those new records into Notion.

Example

Let’s say you connect to an Orders API and set:

• Query Parameter: created_after
• Response Field: created_at

First Import: Your API returns these orders:

Order ID	Created At
101	2025-08-01 10:00:00
102	2025-08-01 10:30:00

Both are added to your Notion table.

Second Import: Since the last import, two more orders were created:

Order ID	Created At
103	2025-08-02 09:15:00
104	2025-08-02 12:20:00

The connector sends your API a request like:

GET /orders?created_after=2025-08-01T10:30:00

Only orders 103 and 104 are fetched and added, orders 101 and 102 remain untouched.

Use a Field to Identify Records

This option is helpful if you want to create a relation between this database and another one in Notion.

When you select a field that uniquely identifies each record (for example, an ID or email), Note API Connector can use this value to automatically link records between databases during import.

Example

Imagine you have two databases in Notion:

1. Customers – each record represents a customer and has an email field. Example rows:

   Name	Email
   Alice Smith	[email protected]
   Bob Jones	[email protected]

2. Orders – each record represents an order and has a customer_email field. Example rows:

   Order ID	customer_email	Product
   101	[email protected]	Coffee Mug
   102	[email protected]	T-Shirt

If you import data into the Customers database and set Email as the Field to Identify Records, Note API Connector will know how to match those customers to orders in the Orders database.

Later, when importing into Orders, you can map the customer_email field to the Relation property that links to the Customers database. The connector will automatically match [email protected] to Alice’s record and [email protected] to Bob’s record.