Fetch Appointment
The Fetch Appointment action allows chatbot builders to retrieve booked appointment details dynamically from a connected Zoho Bookings account inside Ownchat.
This connection action helps businesses automate appointment management workflows by filtering and retrieving bookings based on:
Service ID
Staff ID
Date filters
Appointment status
Customer phone numbers
The walkthrough demonstrates configuring Zoho Bookings connections, mapping service and staff variables, applying appointment filters, storing API responses, and publishing the workflow.
When to Use Fetch Appointment
Use the Fetch Appointment action when your chatbot needs to retrieve appointment information from Zoho Bookings.
Common Use Cases
Appointment history retrieval
Upcoming booking verification
Cancelled appointment tracking
Customer booking lookup
Staff schedule management
Booking support automation
Example Interaction
Bot: 📅 Here are your recent appointments from the last 30 days.
The chatbot dynamically retrieves booking details from Zoho Bookings.
Prerequisites
Before configuring the Fetch Appointment action:
Zoho Bookings integration must already be connected.
Service and staff information should already exist.
Previous booking workflows should already be configured.
The walkthrough demonstrates using variables retrieved from earlier booking actions such as:
services
staff_id
How to Add Fetch Appointment
Follow these steps to add the Fetch Appointment action to your bot workflow.
Open Bot Builder
Drag the Success node from the previous booking action
Open the Connections tab
Select Zoho Bookings
Click Fetch Appointment
Configure booking filters and variables
Configure response variables
Click Create
Click Publish to deploy the workflow
The walkthrough demonstrates connecting the Success path to the Fetch Appointment workflow.
Connecting the Workflow Node
To connect the Fetch Appointment action:
Drag the Success output dot
Connect it to the next workflow action
The walkthrough specifically notes:
Drag and drop the success dot to connect it to the next action, Fetch Appointment.
Accessing the Connections Section
To access Zoho Bookings integrations:
Open the action selection panel
Click the Connections tab
The walkthrough demonstrates opening the Connections section from the bot workflow builder.
Selecting Fetch Appointment
Inside the Zoho Bookings integration:
Locate Fetch Appointment
Click the action to open the configuration dialog
The walkthrough demonstrates opening the Fetch Appointments form successfully.
Fetch Appointment Configuration
When configuring the Fetch Appointment action, several fields must be completed.
Action Name
The Action Name identifies the booking retrieval workflow inside the bot builder.
This name is visible only within the workflow editor.
Example
Fetch Customer Appointments Retrieve Booking History Appointment Lookup
The walkthrough demonstrates renaming the action to:
Fetch bookings
before saving the configuration.
Select Connection
The Select Connection field allows you to choose the connected Zoho Bookings integration.
To configure:
Open the dropdown menu
Select the required connection
The walkthrough specifically selects:
test_zoho_bookings
from the available connection list.
Other available connections shown include:
Janaki Bookings
Service ID
The Service ID field specifies the appointment service for retrieving bookings.
To configure:
Enter the service ID manually or
Insert a dynamic variable
The walkthrough specifically demonstrates using a dynamic variable for the service ID.
Adding Service ID Variable
To dynamically insert the Service ID:
Click Add Variable
Search for the required variable
Select the variable
The walkthrough specifically selects:
services
from the available variables list.
Final example:
{{variables.services}}
Staff ID
The Staff ID field specifies the staff member associated with the appointments.
To configure:
Enter the staff ID manually or
Insert a dynamic variable
The walkthrough demonstrates configuring the Staff ID dynamically.
Adding Staff ID Variable
To dynamically insert the Staff ID:
Click Add Variable
Select the required variable
The walkthrough specifically selects:
staff_id
from the variable list.
Final example:
{{variables.staff_id}}
Filter
The Filter field defines the date range used to retrieve appointments.
Available options shown include:
Last 30 days
Last 60 days
Custom
The walkthrough specifically selects:
Last 30 days
to retrieve appointments from the previous month.
Status
The Status field filters appointments based on booking status.
Available options shown include:
Upcoming
Cancel
Payment Failure
The walkthrough specifically selects:
Cancel
from the appointment status dropdown.
Customer Phone Number
The Customer Phone Number field maps customer phone details for appointment retrieval.
To configure:
Click Add Variable
Search for the customer phone field
Select the phone variable
The walkthrough specifically selects:
phone
from customer fields.
Example variable usage:
{{customer.phone}}
Store Response in the Variable
The Store Response in the Variable field specifies where the appointment response data should be stored.
To configure:
Select an existing variable or
Create a new variable
The walkthrough demonstrates creating:
fetch_booking
as the appointment response variable.
Creating a New Variable
If the required variable does not exist:
Click Create New Variable
Enter the variable name
Save the variable configuration
Example
fetch_booking
The walkthrough demonstrates creating the response variable before finalizing the workflow.
Creating the Fetch Appointment Action
After configuring all settings:
Review the booking filters and variable mappings
Click the Create button
The Fetch Appointment node will now appear in the workflow canvas.
Workflow Behavior
Once triggered, the Fetch Appointment action:
Connects with Zoho Bookings
Retrieves appointment data dynamically
Supports filtering by date and status
Uses service and staff-based lookup
Stores appointment response data automatically
The walkthrough demonstrates retrieving cancelled appointments from the last 30 days successfully.
Example Workflow
Example Chatbot Workflow
Book An Appointment ↓ Fetch Appointment ↓ Retrieve Booking History ↓ Display Customer Appointments
Example Interaction
Bot: 📅 Here are your cancelled appointments from the last 30 days.
The chatbot dynamically retrieves filtered booking data from Zoho Bookings.
Publishing the Bot Changes
After configuring the Fetch Appointment workflow:
Review all workflow connections
Click the Publish button
Deploy the updated chatbot workflow to production
The walkthrough concludes by publishing the configured appointment retrieval workflow successfully.
Best Practices
Follow these recommendations when using Fetch Appointment.
Use dynamic variables for service and staff mapping
Reuse data collected from earlier booking workflows.
Apply appropriate filters
Use filters such as Last 30 days or Custom for accurate results.
Filter by status carefully
Retrieve only the required appointment types.
Store response data properly
Use meaningful variable names for booking response storage.
Test booking retrieval flows before publishing
Verify that appointment data loads correctly from Zoho Bookings.
Summary
The Fetch Appointment action allows chatbot builders to retrieve appointment data dynamically from Zoho Bookings inside OwnChat workflows.
With Fetch Appointment, you can:
Retrieve customer appointment data dynamically
Filter appointments by date and status
Use service and staff-based lookup
Map customer phone data
Store booking responses automatically
Build appointment management workflows
This connection action helps businesses create advanced appointment retrieval automation and intelligent scheduling workflows within Ownhat.
Last updated