Overview
The node named "SmartProxy" interacts with the SmartProxy API to perform various operations on sheets and rows. Specifically, for the "Update Row" operation, it updates an existing row in a specified sheet by providing new values for that row. This is useful in scenarios where you need to modify data dynamically within a spreadsheet-like structure managed by the SmartProxy API, such as updating user information, correcting data entries, or automating data workflows.
Practical examples include:
- Updating a customer's contact details in a row of a sales tracking sheet.
- Modifying inventory quantities in a warehouse management sheet.
- Changing status or progress indicators in project management sheets.
Properties
| Name | Meaning |
|---|---|
| Sheet ID | The unique identifier of the sheet where the row exists. |
| Row ID | The unique identifier of the row to update within the specified sheet. |
| Values | A JSON object containing the key-value pairs representing the columns and their new values to update in the row. |
Output
The node outputs JSON data representing the updated row after the operation completes successfully. This output typically includes the updated fields and any metadata returned by the SmartProxy API about the row. If the node supports binary data output, it would represent associated files or attachments related to the row, but this is not indicated in the provided code snippet.
Dependencies
- Requires an API key credential for authenticating with the SmartProxy API.
- Needs the base URL of the SmartProxy API configured in the credentials.
- Depends on the SmartProxy API being accessible and operational.
Troubleshooting
- Common issues:
- Invalid or missing Sheet ID or Row ID will cause the update to fail.
- Incorrectly formatted JSON in the "Values" property can lead to errors.
- Network or authentication failures due to invalid API keys or unreachable API endpoints.
- Error messages:
- Errors indicating "Row not found" suggest the Row ID does not exist in the specified sheet.
- Authentication errors imply issues with the provided API key or credentials.
- Validation errors may occur if the "Values" JSON does not conform to expected schema; ensure correct field names and data types.
Links and References
- SmartProxy API Documentation (hypothetical link)
- n8n documentation on Creating Custom Nodes