View as Markdown
Zoho Books icon

Zoho Books ACTION

List Expenses

List all the Expenses. See the documentation
  • Action
  • Read only
  • OAuth
  • SDK
  • MCP

IMPLEMENTATION

Call this tool

Connect a user's Zoho Books account once, then configure and run List Expenses from your backend or agent.

import { PipedreamClient } from "@pipedream/sdk"

const pd = new PipedreamClient({
  projectId: process.env.PIPEDREAM_PROJECT_ID!,
  clientId: process.env.PIPEDREAM_CLIENT_ID!,
  clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
  projectEnvironment: "production",
})

const result = await pd.actions.run({
  id: "zoho_books-list-expenses",
  externalUserId: "{external_user_id}", // any stable ID for this user in your system
  configuredProps: {
    zoho_books: { authProvisionId: "apn_xxxxxxx" },
    description: "Description",
    referenceNumber: "Reference Number",
  },
})

console.log(result)

SCHEMA

Inputs

Pipedream supplies the connected account. Your application provides the operation-specific values below. Dynamic inputs are resolved against that user's account.

List Expenses inputs
Property Type Description
description Description string
Search expenses by description.Variants description_startswith and description_contains. Max-length [100]
Optional
referenceNumber Reference Number string
Search expenses by reference number. Variants reference_number_startswith and reference_number_contains. Max-length [100]
Optional
date Date string
Search expenses by expense date. Variants date_start, date_end, date_before and date_after. Format [yyyy-mm-dd]
Optional
status Status string
Search expenses by expense status.
Optional
amount Amount string
Search expenses by amount.
Optional
accountName Account Name string
Search expenses by expense account name. Max-length [100]
Optional
customerName Customer Name string
Search expenses by customer name. Max-length [100]
Optional
vendorName Vendor Name string
Search expenses by vendor name.
Optional
customerId Customer Id string
ID of the expense account.
Optional
vendorId Vendor Id string
ID of the vendor the expense is made.
Optional
recurringExpenseId Recurring Expense Id string
Search expenses by recurring expense id.
Optional
paidThroughAccountId Paid Through Account Id string
Search expenses by paid through account id.
Optional
searchText Search Text string
Search expenses by account name or description or customer name or vendor name. Max-length [100]
Optional
sortColumn Sort Column string
Sort expenses.
Optional
filterBy Filter By string
Filter expenses by expense status.
Optional

REFERENCE

Tool details

Behavior hints are published with the component in the Pipedream registry and surface as MCP tool annotations, so an agent can reason about a tool before it calls it.

Registry key
zoho_books-list-expenses
Version
0.3.1
App
Zoho Books
Authentication
OAuth
Read-only
Yes
Destructive
No
Open world
Yes