Call history record reporting workflow
Planning example. Stacksync support for the required connection and record operations needs a technical review.
Starting event: A change to the selected Proposed call history record table in Snowflake (choose its name) or Zoom Phone Call Logs record needs a defined result in the other system.
- Start with Snowflake Proposed call history record table in Snowflake (choose its name) and Zoom Zoom Phone Call Logs. Use the record-matching and field-ownership rules from your mapping worksheet.
- Resolve participant and business-record identities, provider/account scope, and any related recording access.
- Test a normal update and one failed or repeated update in the supported direction. Keep both record IDs with the test results.
Expected result: Test two calls to the same number, a corrected disposition, and a delayed call completion. Verify that the intended CRM activity is updated once.
If it fails: Look up the current call and destination activity before retrying; repairing history must not place another call or expose a restricted recording.
Message or conversation reporting workflow
Planning example. Stacksync support for the required connection and record operations needs a technical review.
Starting event: A change to the selected Proposed message or conversation table in Snowflake (choose its name) or Team Chat Channels and Messages record needs a defined result in the other system.
- Start with Snowflake Proposed message or conversation table in Snowflake (choose its name) and Zoom Team Chat Channels and Messages. Use the record-matching and field-ownership rules from your mapping worksheet.
- Resolve conversation, participant, and customer context before associating messages.
- Test a normal update and one failed or repeated update in the supported direction. Keep both record IDs with the test results.
Expected result: Test a delivery-state change, repeated message, private conversation, and reply linked to the correct thread.
If it fails: Check provider delivery state before retrying a send; replaying history must not send the message again.
Application user or identity reporting workflow
Planning example. Stacksync support for the required connection and record operations needs a technical review.
Starting event: A change to the selected Proposed application user or identity table in Snowflake (choose its name) or Users record needs a defined result in the other system.
- Start with Snowflake Proposed application user or identity table in Snowflake (choose its name) and Zoom Users. Use the record-matching and field-ownership rules from your mapping worksheet.
- Resolve tenant and group references and establish a protected administrative-account policy.
- Test a normal update and one failed or repeated update in the supported direction. Keep both record IDs with the test results.
Expected result: Test a renamed login, disabled account, missing group, and a user existing in two tenants.
If it fails: Review access impact before retrying a lifecycle change; reconcile current identity state and retain an approval trail.
Link communication history with Snowflake context
This is an evaluation scenario; connector and operation support require confirmation.
Starting event: A communication in Zoom needs an association with a selected destination dataset in Snowflake.
- Select the communication records from Users or Groups and preserve message/call and thread IDs.
- Resolve the participant-to-business-record relationship explicitly; phone number or display name alone may be ambiguous.
- Keep history replication separate from sending a message, placing a call, or changing consent. Confirm a separate authorized operation for any action.
Expected result: Repeated delivery updates the same history record; a private conversation stays private; a history replay sends no new message.
If it fails: Check source delivery state and the destination relationship before retrying. Do not resend to repair an analytical or history discrepancy.