Overview

This node implements a tool to interact with the Suppa API, allowing users to perform various database-related actions such as retrieving tables, fetching table fields, querying records, and managing records (create, update, delete) via JSON commands. It is useful for automating and integrating Suppa API operations within workflows, for example, fetching user data by ID or creating new records in a specified table.

Use Case Examples

1. Get all tables: {"action": "getTables"}
2. Get a user by ID: {"action": "getById", "table": "users", "data": {"id": "123"}}
3. Create a user: {"action": "create", "table": "users", "data": {"name": "John", "email": "john@example.com"}}

Output

JSON

• response - The JSON string response from the Suppa API based on the requested action

Dependencies

• Suppa API credentials (API key and base URL) required for authentication

Troubleshooting

• Common errors include missing required parameters such as 'action', 'table', or 'data.id' depending on the action, which will throw descriptive error messages.
• Errors related to missing or invalid Suppa API credentials will also be thrown if credentials are not found or invalid.
• Unknown actions will result in an error indicating the action is not recognized.

Links

• Suppa API Documentation - Official documentation for the Suppa API, detailing available endpoints and usage.