Database Mapping Table

The KiviCare Google Meet Addon uses a dedicated database table to maintain a reliable connection between WordPress appointments and Google Meet events. This local mapping minimizes unnecessary API calls by securely caching Google Calendar event details.

Table Name: wp_kc_appointment_google_meet_mappings

This table stores Google Meet information associated with each KiviCare appointment.

Programmatic Data Access

Developers can retrieve Google Meet mapping data using the
KCGMAppointmentGoogleMeetMapping model.

use KCGMApp\models\KCGMAppointmentGoogleMeetMapping;

// Retrieve Google Meet mapping for a specific appointment
$mapping = KCGMAppointmentGoogleMeetMapping::where('appointment_id', $id)->first();

if ($mapping) {
    echo 'Google Meet URL: ' . $mapping->url;
}

This approach allows seamless access to meeting links for custom workflows or integrations.

Automatic Data Cleanup

When an appointment is deleted from KiviCare, the addon automatically:

1. Cancels the corresponding Google Calendar event using the stored event_id.
2. Removes the related entry from the mapping table to keep the database clean.

This ensures data consistency between WordPress and Google Calendar at all times.