Actions23
- Spreadsheet Actions
- Sheet Filter Actions
- Sheet Filter View Actions
- Filter Condition Filter View Actions
- Sheet Row Column Actions
- Sheet Data Actions
- Sheet Floating Image Actions
Overview
The "Update A Floating Image" operation in the "Sheet Floating Image" resource allows users to modify properties of an existing floating image within a spreadsheet sheet managed by Lark Sheets. This node is useful when you want to programmatically adjust the position, size, or token of a floating image embedded in a sheet without manually editing the document.
Practical scenarios include:
- Automatically repositioning images based on data changes.
- Resizing images to fit updated layouts.
- Updating the image token to replace the image content while keeping its placement.
Properties
| Name | Meaning |
|---|---|
| Authentication | Method of authentication: either "Tenant Token" or "OAuth2". |
| Spreadsheet Token | The unique token identifying the target spreadsheet. |
| Sheet Id | Identifier of the specific sheet within the spreadsheet where the floating image exists. |
| Float Image Id | Identifier of the floating image to update. |
| Float Image Token | Token representing the new image content (optional). |
| Height | New height of the floating image (number). |
| Offset X | Horizontal offset position of the floating image (number). |
| Offset Y | Vertical offset position of the floating image (number). |
| Range | Cell range reference related to the floating image positioning (string). |
| Width | New width of the floating image (number). |
| Custom Body | JSON object allowing full customization of the request body sent to the API. |
| Options > Use Custom Body | Boolean flag to indicate whether to send the custom JSON body instead of individual fields. |
Output
The node outputs JSON data representing the response from the Lark Sheets API after updating the floating image. This typically includes confirmation of the update and details of the modified floating image such as its ID, new dimensions, position, and token.
No binary data output is involved in this operation.
Dependencies
- Requires access to the Lark Sheets API endpoint at
https://open.larksuite.com/open-apis. - Requires valid authentication credentials, either via a tenant token or OAuth2 token.
- Proper configuration of authentication credentials in n8n is necessary for successful API calls.
Troubleshooting
- Invalid or missing tokens: Ensure that the spreadsheet token, sheet ID, and floating image ID are correct and correspond to existing resources.
- Authentication errors: Verify that the selected authentication method is correctly configured and the token has not expired.
- API request errors: If using the custom body option, ensure the JSON structure matches the expected API schema.
- Positioning issues: Offsets and range values must be valid; otherwise, the floating image may not update as expected.
Common error messages might include unauthorized access, resource not found, or invalid parameters. Resolving these usually involves checking credentials, verifying IDs, and validating input data formats.