Power BI Connector for Zoho Books

Build 24.0.9060

EstimateApprovers

Get the details of approvers for estimates.

Table Specific Information

Select

The connector 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 connector.

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