SSIS Components for Zoho CRM

Build 24.0.9062

StageHistories

Query information regarding stage histories for a particular deal.

Columns

Name Type Description
Id [KEY] String A unique numeric identifier for the stage.
DealId String A unique numeric identifier for the deal this stage belongs to.
Stage String The stage number for this stage.
Amount Decimal The amount of money spent for this stage.
DurationDays Integer The duration of this stage.
ExpectedRevenue Decimal The expected revenue from this stage.
Probability Decimal The probability for the stage to happen.
CloseDate Date The date when this stage closes.
LastModifiedTime Datetime The time this stage was last modified.
ModifiedById String The id of the user who modified the stage.
ModifiedByName String The name of the user who modified the stage.
ModifiedByEmail String The email of the user who modified the stage.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Fields String The fields that must be shown in response.

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