wecom-smartsheet-data

You can manage SmartSheet records via WeCom by applying query, add, update, and delete operations to a specific subtable identified by docid or URL with sheet_id, processing up to 500 records per batch.

To add or update multiple records in a WeCom SmartSheet subtable, use batch operations that support up to 500 records per call, requiring appropriate field definitions for accurate data synchronization.

A userid lookup via wecom-contact-lookup is required for user fields when updating WeCom SmartSheet records to ensure the correct user reference is applied to the appropriate field definitions.

Yes, you can delete obsolete records from a WeCom SmartSheet subtable in bulk, with batch delete operations supporting up to 500 records per API call to clean up data efficiently.

Each API call querying SmartSheet records via WeCom returns a JSON object containing an errcode and errmsg, indicating the success or failure of the retrieval operation for the targeted subtable.

You locate the target document for SmartSheet record management via WeCom by using a specific docid or URL, combined with a sheet_id, to identify the exact subtable for your operations.