BizTalk Adapter for Zoho Books

Build 20.0.7654

EstimateApprovers

Get the details of approvers for estimates.

Table Specific Information

Select

The {i will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the {i.

  • EstimateId supports the '=' comparison.
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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654