N8N Tools - Pipefy Database icon

N8N Tools - Pipefy Database

Manage Pipefy database tables and records with advanced data operations

Overview

The node provides functionality to manage tables within a Pipefy database, specifically allowing users to update existing tables. This includes modifying the table's name and various optional attributes such as description, color theme, public form availability, and authorization level.

This node is beneficial in scenarios where you need to programmatically maintain or adjust metadata of your Pipefy tables without manual intervention. For example, automating updates to table descriptions or changing access permissions based on workflow conditions.

Practical examples:

  • Automatically updating a table’s description to reflect new project details.
  • Changing the color theme of a table to visually categorize it according to status.
  • Enabling or disabling the public form feature for a table based on organizational policies.
  • Adjusting authorization levels to control user access dynamically.

Properties

Name Meaning
Table ID The unique identifier of the table to update (required).
Table Name New name for the table (optional; if provided, updates the table's name).
Additional Fields A collection of optional fields to update:
- Description Text description of the table.
- Color Color theme for the table. Options: Blue, Red, Green, Yellow, Purple, Orange, Pink, Gray.
- Public Form Boolean indicating whether the table has a public form (true/false).
- Authorization Authorization level for the table. Options: Read, Write, Admin.

Output

The output JSON object represents the updated table with its current properties after the update operation. It typically includes:

  • id: The table's unique identifier.
  • name: The updated name of the table.
  • description: Updated description if provided.
  • color: The selected color theme.
  • publicForm: Whether the public form is enabled.
  • authorization: The authorization level set for the table.

This output allows downstream nodes or workflows to use the updated table information immediately.

Dependencies

  • Requires an API key credential for authenticating requests to the Pipefy database service.
  • Uses GraphQL API calls to perform the update operation.
  • The node depends on utility functions for validation and making authenticated API requests.
  • Proper configuration of credentials and network access to Pipefy API endpoints is necessary.

Troubleshooting

  • Missing Required Fields: If "Table ID" is not provided, the node will throw an error indicating that this field is required. Ensure all mandatory inputs are filled.
  • Invalid Authorization Values: Selecting an unsupported authorization level may cause API errors. Use only the provided options.
  • API Request Failures: Network issues or invalid credentials can cause failures. Verify API keys and connectivity.
  • JSON Parsing Errors: Although not directly relevant to update table, other operations involving JSON input must be valid JSON.
  • Permission Denied: If the API key does not have sufficient rights to update the table, the request will fail. Confirm the API key has appropriate permissions.

Links and References

Discussion