N8N Tools - Pipefy Database icon

N8N Tools - Pipefy Database

Manage Pipefy database tables and records with advanced data operations

Overview

This node enables managing records within Pipefy database tables, specifically allowing operations such as creating, updating, retrieving, and deleting table records. The "Delete" operation for the "Table Record" resource removes a specific record from a Pipefy table by its unique ID.

Common scenarios where this node is beneficial include:

  • Automating cleanup of outdated or irrelevant records in Pipefy tables.
  • Integrating Pipefy with other systems to synchronize data deletions.
  • Managing data lifecycle by programmatically removing records based on workflow conditions.

For example, you might use this node to delete a customer record from a Pipefy table when that customer unsubscribes from your service.

Properties

Name Meaning
Table Record ID ID of the table record to delete (required)

Output

The output JSON contains the result of the deletion operation with the following fields:

  • success (boolean): Indicates whether the deletion was successful.
  • tableRecordId (string): The ID of the deleted table record.
  • message (string): A human-readable message indicating success ("Table record deleted successfully") or failure ("Failed to delete table record").

No binary data is output by this operation.

Example output JSON:

{
  "success": true,
  "tableRecordId": "record_12345",
  "message": "Table record deleted successfully"
}

Dependencies

  • Requires an API key credential for authenticating with the Pipefy API.
  • Requires a Pipefy-specific API authentication token configured in n8n credentials.
  • The node uses GraphQL queries/mutations internally to communicate with the Pipefy API.

Troubleshooting

  • Missing or invalid Table Record ID: The node requires a valid Table Record ID. If omitted or incorrect, the node will throw an error indicating the missing required field.
  • API authentication errors: Ensure that the API credentials are correctly set up and have sufficient permissions to delete records.
  • Deletion failure: If the API returns a failure, the output message will indicate "Failed to delete table record". Check if the record exists and if the user has permission to delete it.
  • Invalid JSON in input properties: Not applicable for this operation but relevant for bulk create/update operations.

Links and References

Discussion