Caspio icon

Caspio

Interact with Caspio REST API.
Join our community

Actions21

Overview

This node uploads an attachment file to a specified record in a Caspio table. It is useful for automating the process of attaching files to database records in Caspio, such as uploading images, documents, or other file types to a record identified by its primary key. For example, it can be used to upload a user's profile picture or attach a contract document to a customer record.

Use Case Examples

  1. Uploading a PDF contract to a customer record in a Caspio table.
  2. Attaching an image file to a product record for an e-commerce application.

Properties

Name Meaning
Table The Caspio table where the record exists to which the attachment will be uploaded. It supports selecting from a list or specifying by name.
Attachment Field Name or ID The specific attachment field in the table where the file will be uploaded. This can be selected from available attachment fields or specified by ID.
Record PK ID The primary key ID of the record in the table to which the file will be attached. This identifies the exact record for the upload.
Binary Property The name of the binary property in the input data that contains the file to be uploaded.

Output

JSON

  • success - Indicates whether the upload operation was successful.
  • attachmentId - The identifier of the uploaded attachment file.
  • recordPkId - The primary key ID of the record to which the attachment was uploaded.

Dependencies

  • Requires Caspio OAuth2 API credentials for authentication to interact with Caspio REST API.

Troubleshooting

  • Ensure the table name or selection is correct and exists in Caspio.
  • Verify the attachment field name or ID is valid and corresponds to an attachment field in the table.
  • Confirm the record primary key ID exists in the specified table.
  • Check that the binary property name matches the input data containing the file to upload.
  • Authentication errors may occur if the OAuth2 credentials are invalid or expired; reauthenticate if needed.

Links

Discussion