Excel Add-In for Zoho Books

Build 24.0.9060

EstimateApprovers

Get the details of approvers for estimates.

Table Specific Information

Select

The add-in uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:

  • EstimateId supports the '=' comparison.

The rest of the filter is executed client-side in the add-in.

For example:

    SELECT * FROM EstimateApprovers WHERE EstimateId = '1894553000000077244'

Columns

Name Type References SupportedOperators Description
EstimateId String

Estimates.EstimateId

Id of an estimate.
ApproverUserId [KEY] String

Users.UserId

User Id of an approver.
Order String Order number.
ApproverName String Name of the approver.
Email String Email Id of the approver.
Has_approved Boolean Check if the User has approved the estimate.
ApprovalStatus String Status of an approval.
IsNextApprover String Check if it is a next approver.
SubmittedDate Date Date of submission.
ApprovedDate Date Date of approval.
PhotoUrl String Photo Url.
UserStatus String Status of a user.
IsFinalApprover Boolean Check if this is a final approver.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060