Skip to content
For the complete documentation index, see llms.txt. This page is also available as Markdown.

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.

  1. Open Bot Builder

  2. Drag the Success node from the previous booking action

  3. Open the Connections tab

  4. Select Zoho Bookings

  5. Click Fetch Appointment

  6. Configure booking filters and variables

  7. Configure response variables

  8. Click Create

  9. 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:

  1. Drag the Success output dot

  2. 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:

  1. Open the action selection panel

  2. Click the Connections tab

The walkthrough demonstrates opening the Connections section from the bot workflow builder.

Selecting Fetch Appointment

Inside the Zoho Bookings integration:

  1. Locate Fetch Appointment

  2. 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:

  1. Open the dropdown menu

  2. 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:

  1. Enter the service ID manually or

  2. 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:

  1. Click Add Variable

  1. Search for the required variable

  2. 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:

  1. Enter the staff ID manually or

  2. Insert a dynamic variable

The walkthrough demonstrates configuring the Staff ID dynamically.

Adding Staff ID Variable

To dynamically insert the Staff ID:

  1. Click Add Variable

  1. 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:

  1. Click Add Variable

  1. Search for the customer phone field

  2. 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:

  1. Select an existing variable or

  2. 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:

  1. Click Create New Variable

  2. Enter the variable name

  3. 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:

  1. Review the booking filters and variable mappings

  2. 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:

  1. Review all workflow connections

  2. Click the Publish button

  3. 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