Deals
Retrieve deal/opportunity records from Apollo.io CRM system
Columns
| Name | Type | References | |
| Id [KEY] | String | ||
| AccountId | String |
Accounts.Id | |
| CreatedById | String | ||
| OwnerId | String | ||
| TeamId | String | ||
| Name | String | ||
| Source | String | ||
| CreatedAt | Datetime | ||
| LastActivityDate | Datetime | ||
| NextStepLastUpdatedAt | Datetime | ||
| StageUpdatedAt | Datetime | ||
| AccountData | String | ||
| ActualCloseDate | Datetime | ||
| Amount | Decimal | ||
| AmountInTeamCurrency | Decimal | ||
| ClosedDate | Datetime | ||
| ClosedLostReason | String | ||
| ClosedWonReason | String | ||
| CrmId | String | ||
| CrmOwnerId | String | ||
| CrmRecordUrl | String | ||
| CurrencyIsoCode | String | ||
| CurrencyName | String | ||
| CurrencySymbol | String | ||
| CurrentSolutions | String | ||
| DealProbability | Decimal | ||
| DealSource | String | ||
| Description | String | ||
| ExchangeRateCode | String | ||
| ExchangeRateValue | Decimal | ||
| ExistenceLevel | String | ||
| ForecastCategory | String | ||
| ForecastedRevenue | Decimal | ||
| IsClosed | Boolean | ||
| IsWon | Boolean | ||
| ManuallyUpdatedForecast | String | ||
| ManuallyUpdatedProbability | Decimal | ||
| NextStep | String | ||
| NextStepDate | Datetime | ||
| OpportunityContactRoles | String | ||
| OpportunityPipelineId | String | ||
| OpportunityStageId | String | ||
| Probability | Decimal | ||
| SalesforceId | String | ||
| SalesforceOwnerId | String | ||
| StageName | String | ||
| TypedCustomFields | String | ||
| AlexaRanking | Long | ||
| AngellistUrl | String | ||
| BlogUrl | String | ||
| City | String | ||
| Country | String | ||
| CrunchbaseUrl | String | ||
| EstimatedNumEmployees | Long | ||
| FacebookUrl | String | ||
| FoundedYear | Integer | ||
| Industries | String | ||
| IndustryTagHash | String | ||
| IndustryTagId | String | ||
| Keywords | String | ||
| Languages | String | ||
| LinkedinUid | String | ||
| LinkedinUrl | String | ||
| LogoUrl | String | ||
| NaicsCodes | String | ||
| OrganizationRevenue | Decimal | ||
| OrganizationRevenuePrinted | String | ||
| Phone | String | ||
| PostalCode | String | ||
| PrimaryDomain | String | ||
| PrimaryPhone | String | ||
| PubliclyTradedExchange | String | ||
| PubliclyTradedSymbol | String | ||
| RawAddress | String | ||
| RetailLocationCount | Integer | ||
| SanitizedPhone | String | ||
| SecondaryIndustries | String | ||
| SicCodes | String | ||
| IsSnippetsLoaded | Boolean | ||
| State | String | ||
| StreetAddress | String | ||
| TwitterUrl | String | ||
| WebsiteUrl | String | ||
| AccountCity | String | ||
| AccountCountry | String | ||
| AccountFacebookUrl | String | ||
| AccountObjectId | String | ||
| AccountHeadcountSixMonthGrowth | Integer | ||
| AccountHeadcountTwelveMonthGrowth | Integer | ||
| AccountHeadcountTwentyFourMonthGrowth | Integer | ||
| AccountOrganizationId | String | ||
| AccountPostalCode | String | ||
| AccountRawAddress | String | ||
| AccountState | String | ||
| AccountStreetAddress | String | ||
| AccountSuggestedFromRuleEngineConfigId | String |