Description:

This PR adds a new integration for SmartSuite, a collaborative work management platform that combines the power of databases with the flexibility of spreadsheets. The integration enables users to automate workflows involving SmartSuite data, including creating, updating, and retrieving records.

Features Implemented:

Authentication:

• API key-based authentication with validation to ensure the key is valid before allowing users to proceed

Triggers:

1. New Record - Triggers when a new record is created in a specified table

   • Uses webhook-based implementation for real-time notifications
   • Automatically creates and manages webhooks in SmartSuite

2. Updated Record - Triggers when a record is updated in a specified table

   • Uses webhook-based implementation for real-time notifications
   • Automatically cleans up webhooks when the flow is disabled

Actions:

1. Create Record - Creates a new record in a specified table

   • Dynamically loads table fields based on the selected table
   • Handles field validation and provides clear error messages

2. Update Record - Updates an existing record in a specified table

   • Allows updating any field in the record
   • Provides proper error handling for non-existent records

3. Delete Record - Deletes a record from a specified table

   • Confirms successful deletion
   • Handles permissions and not-found errors gracefully

4. Upload File - Uploads a file and attaches it to a record

   • Supports file uploads to file-type fields
   • Handles various file upload errors with clear messages

5. Find Records - Searches for records in a specified table based on criteria

   • Supports sorting and filtering
   • Allows limiting the number of results returned

6. Get Record - Retrieves a specific record by ID

   • Returns all fields and values for the record
   • Handles not-found scenarios with clear error messages

Technical Implementation:

• Used dynamic properties to load solutions, tables, and fields from SmartSuite
• Implemented comprehensive error handling for all API interactions
• Added proper validation for user inputs
• Used webhook-based triggers for real-time notifications
• Followed Activepieces architecture and best practices
• Structured the code in a modular way for maintainability

Testing:

The integration has been tested with a SmartSuite account to ensure all actions and triggers work as expected. Edge cases have been handled, including:

• Creating records with missing required fields
• Updating non-existent records
• Uploading invalid file types
• Testing with insufficient permissions
• Error handling for various HTTP status codes

Documentation:

Each action and trigger includes detailed descriptions and helpful error messages to guide users. The integration follows the SmartSuite API documentation and handles all the complexities of the API behind the scenes.

Related Issue:

Closes #7662 /claim #7662