SUPPA AI Tool icon

SUPPA AI Tool

AI Tool to perform actions on Suppa API
Join our community

Overview

This node provides an AI tool to interact with the Suppa API, enabling various database operations through JSON commands. It supports actions like retrieving tables, fetching table fields, querying records by ID or filter, creating, updating, and deleting records. This node is useful for automating database management tasks within workflows, such as dynamically querying or modifying data in Suppa without manual API calls.

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 new 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. For 'getTables', it returns an array of table objects with name and id; for other actions, it returns the corresponding data or confirmation from the API.

Dependencies

  • Requires Suppa API credentials including base URL and API key for authentication.

Troubleshooting

  • Common errors include missing required parameters such as 'action', 'table', or 'data.id' depending on the action, which will throw descriptive errors.
  • Errors related to missing or invalid API credentials will prevent API calls and throw errors indicating credentials are not found.
  • Unknown actions will result in an error specifying the action is unknown.

Links

Discussion