Actions7
- Database Record Actions
- Application User Actions
Database Record → Get One
AI-generatedOverview
This node operation retrieves a single record from a specified database and table within the Softr.io platform. It is useful when you need to fetch detailed information about a specific database entry by its record ID. For example, you might use this to get user details, product information, or any other individual record stored in a Softr database.
Use Case Examples
- Fetch a user profile by record ID from a user database.
- Retrieve a specific product's details from an inventory table.
Properties
| Name | Meaning |
|---|---|
| Database | The Softr database from which to retrieve the record. It can be selected from a list, specified by URL, or entered as an ID. |
| Table | The table within the selected database containing the record. It can be selected from a list, specified by URL, or entered as an ID. |
| Record ID | The unique identifier of the record to retrieve from the specified table. |
Output
JSON
json- The JSON object representing the retrieved database record's data.
Dependencies
- Requires Softr API credentials for authentication.
Troubleshooting
- Ensure the Database ID, Table ID, and Record ID are correctly specified and valid.
- Check that the Softr API credentials are correctly configured and have the necessary permissions.
- If the record is not found, verify that the Record ID exists in the specified table.
Links
- Softr API Documentation - Official API documentation for Softr, useful for understanding database and record operations.