Softr icon

Softr

Softr.io Integration Node

Actions7

Database Record → Get Many

AI-generated

Overview

This node operation retrieves multiple records from a specified database table in Softr.io. It is useful for scenarios where you need to fetch a list of records based on certain filter conditions, paging, and sorting options. For example, you can use it to get all user entries from a user database or fetch filtered product listings from a product database.

Use Case Examples

  1. Fetch all records from a 'Customers' table with a filter to only include those from a specific city.
  2. Retrieve the first 100 records from an 'Orders' table sorted by order date in descending order.

Properties

Name Meaning
Database The Softr database from which to retrieve records. Can be selected from a list, by URL, or by ID.
Table The table within the selected database to query records from. Can be selected from a list, by URL, or by ID.
Filter Conditions to filter the records when searching. Supports logical operators (AND/OR) and multiple conditions with various comparison operators like Contains, Equals, Greater Than, etc.
Paging & Sorting Options to control the result set including offset (how many items to skip), limit (max number of results), sorting field, and sorting direction (ascending or descending).

Output

JSON

  • json - Each item represents a database record retrieved from the specified table, including all fields of the record.

Dependencies

  • Requires Softr API credentials for authentication.

Troubleshooting

  • Ensure the database and table IDs or URLs are correct and accessible.
  • Verify that the filter conditions are valid and fields used in filters exist in the table.
  • Check API credentials and permissions to access the Softr database.
  • If no records are returned, verify the filter and paging parameters to ensure they match existing data.

Links

Discussion