Knack icon

Knack

Knack Api

Actions5

Overview

The Knack node for n8n allows you to interact with the Knack API, specifically to retrieve records from a selected Knack object. Using the "Get All" operation under the "Default" resource, this node fetches multiple records from a specified object, supporting advanced filtering and pagination.

Common scenarios:

  • Extracting all customer records from a Knack database for reporting or synchronization.
  • Filtering records based on complex criteria (e.g., date ranges, text matches, boolean fields).
  • Automating data exports from Knack to other systems.

Practical example:
You could use this node to pull all orders placed in the last month, filter them by status, and then send the results to a spreadsheet or another application.

Properties

Name Meaning
Object Name or ID Choose the Knack object to retrieve records from. You can select from a list or specify an object ID using an expression. This is required.
Record Limit Maximum number of results to return. Must be at least 1. Default is 50.
Match Determines how filter rules are combined:
- And: All records must match all filters.
- Or: Records matching at least one filter will be returned.
Filter Rules Add one or more filters to narrow down the results. Each filter type supports different field types and operators:

Address
- Field Key Name or ID
- Operator: Contains, Does Not Contain, Ends With, Is, Is Blank, Is Not, Is Not Blank, Near, Starts With
- Field Value

Boolean (Yes/No) / Link
- Field Key Name or ID
- Operator: Is, Is Not, Is Blank, Is Not Blank
- Field Value

Date/Time (Single Date)
- Field Key Name or ID
- Operator: Is, Is After, Is After Current Time, Is After the Next, Is After Today, Is Before, Is Before Current Time, Is Before the Previous, Is Before Today, Is Blank, Is During the Current, Is During the Next, Is During the Previous, Is Not, Is Not Blank, Is Today, Is Today or After, Is Today or Before
- Field Value
- Range
- Type

File / Image / Signature
- Field Key Name or ID
- Operator: Is Blank, Is Not Blank

MultipleChoice
- Field Key Name or ID
- Operator: Contains, Does Not Contain, Is, Is Any, Is Blank, Is Not, Is Not Blank
- Field Value

Number
- Field Key Name or ID
- Operator: Higher Than, Is, Is Blank, Is Not, Is Not Blank, Lower Than
- Field Value

Text / Other
- Field Key Name or ID
- Operator: Contains, Does Not Contain, Ends With, Is, Is Blank, Is Not, Is Not Blank, Starts With
- Field Value

Output

  • The output is an array of objects, each representing a record from the selected Knack object.
  • Each json field contains the record's data, with field names mapped to their human-readable names (not internal IDs).
  • No binary data is produced by this operation.

Example output:

[
  {
    "json": {
      "Name": "John Doe",
      "Email": "john@example.com",
      "Status": "Active"
    }
  },
  {
    "json": {
      "Name": "Jane Smith",
      "Email": "jane@example.com",
      "Status": "Inactive"
    }
  }
]

Dependencies

  • External Service: Requires access to a Knack account and the relevant application.
  • API Credentials: You must configure Knack API credentials in n8n (knackApi).
  • n8n Configuration: No special environment variables are needed beyond standard credential setup.

Troubleshooting

Common issues:

  • Invalid Object ID: If the "Object Name or ID" is incorrect, no records will be returned or an error may occur.
  • Filter Mismatch: Overly restrictive filters may result in zero records.
  • API Limits: The node enforces a maximum of 1000 records per page; requesting more than this may require additional logic.
  • Authentication Errors: Incorrect or missing API credentials will cause authentication failures.

Error messages and resolutions:

  • "error": "Request failed with status code 401" — Check your Knack API credentials.
  • "error": "Object not found" — Verify the Object Name or ID.
  • "error": "Field not found" — Ensure filter fields exist in the selected object.

Links and References

Discussion