...
These are the fields displayed in these tables:
| Rw ui tabs macro |
|---|
crm.salesforceobjectsField | Type | Field transformation | Source field name | Extra fields |
|---|
eventdate | timestamp
| | | | hostname | str
| | | | attributes_type | str
| | | | attributes_url | str
| | | | Id | str
| | | | IsClosed | bool
| | | | IsDeleted | bool
| | | | MasterRecordId | str
| | | | UserId | str
| | | | AccountId | str
| | | | ContactId | str
| | | | OwnerId | str
| | | | ParentId | str
| | | | Name | str
| | | | Description | str
| | | | Status | str
| | | | Title | str
| | | | Type | str
| | | | Username | str
| | | | UserType | str
| | | | LastActivityDate | str
| | | | CreatedById | str
| | | | CreatedDate | str
| | | | LastModifiedById | str
| | | | LastModifiedDate | timestamp
| | Code Block |
|---|
parsedate(LastModifiedDate_str, "YYYY-MM-DD[T]HH:mm:ss.SSSZZ") |
| LastModifiedDate_str | | SystemModstamp | str
| | | | LastReferencedDate | str
| | | | LastViewedDate | str
| | | | DeveloperName | str
| | | | FolderName | str
| | | | LoginType | str
| | | | NamespacePrefix | str
| | | | SourceIp | ip4
| | | | Application | str
| | | | Browser | str
| | | | City | str
| | | | CountryIso | str
| | | | Origin | str
| | | | Platform | str
| | | | hostchain | str
| | | ✓ | tag | str
| | | ✓ | rawMessage | str
| | | ✓ |
Field | Type | Field transformation | Source field name | Extra fields |
|---|
eventdate | timestamp
| | | | hostname | str
| | | | attributes_type | str
| | | | attributes_url | str
| | | | Id | str
| | | | IsDeleted | bool
| | | | MasterRecordId | str
| | | | Name | str
| | | | Type | str
| | | | ParentId | str
| | | | BillingStreet | str
| | | | BillingCity | str
| | | | BillingState | str
| | | | BillingPostalCode | str
| | | | BillingCountry | str
| | | | BillingLatitude | str
| | | | BillingLongitude | str
| | | | BillingGeocodeAccuracy | str
| | | | BillingAddress_city | str
| | | | BillingAddress_country | str
| | | | BillingAddress_geocodeAccuracy | str
| | | | BillingAddress_latitude | str
| | | | BillingAddress_longitude | str
| | | | BillingAddress_postalCode | str
| | | | BillingAddress_state | str
| | | | BillingAddress_street | str
| | | | ShippingStreet | str
| | | | ShippingCity | str
| | | | ShippingState | str
| | | | ShippingPostalCode | str
| | | | ShippingCountry | str
| | | | ShippingLatitude | str
| | | | ShippingLongitude | str
| | | | ShippingGeocodeAccuracy | str
| | | | ShippingAddress_city | str
| | | | ShippingAddress_country | str
| | | | ShippingAddress_geocodeAccuracy | str
| | | | ShippingAddress_latitude | str
| | | | ShippingAddress_longitude | str
| | | | ShippingAddress_postalCode | str
| | | | ShippingAddress_state | str
| | | | ShippingAddress_street | str
| | | | Phone | str
| | | | Fax | str
| | | | AccountNumber | str
| | | | Website | str
| | | | PhotoUrl | str
| | | | Sic | str
| | | | Industry | str
| | | | AnnualRevenue | str
| | | | NumberOfEmployees | int8
| | | | Ownership | str
| | | | TickerSymbol | str
| | | | Description | str
| | | | Rating | str
| | | | Site | str
| | | | OwnerId | str
| | | | CreatedDate | str
| | | | CreatedById | str
| | | | LastModifiedDate | timestamp
| | Code Block |
|---|
parsedate(LastModifiedDate_str, "YYYY-MM-DD[T]HH:mm:ss.SSSZZ") |
| LastModifiedDate_str | | LastModifiedById | str
| | | | SystemModstamp | str
| | | | LastActivityDate | str
| | | | LastViewedDate | str
| | | | LastReferencedDate | str
| | | | Jigsaw | str
| | | | JigsawCompanyId | str
| | | | CleanStatus | str
| | | | AccountSource | str
| | | | DunsNumber | str
| | | | Tradestyle | str
| | | | NaicsCode | str
| | | | NaicsDesc | str
| | | | YearStarted | str
| | | | SicDesc | str
| | | | DandbCompanyId | str
| | | | OperatingHoursId | str
| | | | IsBuyer | bool
| | | | hostchain | str
| | | ✓ | tag | str
| | | ✓ | rawMessage | str
| | | ✓ |
Field | Type | Field transformation | Source field name | Extra fields |
|---|
eventdate | timestamp
| | | | hostname | str
| | | | attributes_type | str
| | | | attributes_url | str
| | | | Id | str
| | | | IsDeleted | bool
| | | | MasterRecordId | str
| | | | CaseNumber | str
| | | | ContactId | str
| | | | AccountId | str
| | | | AssetId | str
| | | | SourceId | str
| | | | ParentId | str
| | | | SuppliedName | str
| | | | SuppliedEmail | str
| | | | SuppliedPhone | str
| | | | SuppliedCompany | str
| | | | Type | str
| | | | Status | str
| | | | Reason | str
| | | | Origin | str
| | | | Subject | str
| | | | Priority | str
| | | | Description | str
| | | | IsClosed | bool
| | | | ClosedDate | str
| | | | IsEscalated | bool
| | | | OwnerId | str
| | | | CreatedDate | str
| | | | CreatedById | str
| | | | LastModifiedDate | timestamp
| | Code Block |
|---|
parsedate(LastModifiedDate_str, "YYYY-MM-DD[T]HH:mm:ss.SSSZZ") |
| LastModifiedDate_str | | LastModifiedById | str
| | | | SystemModstamp | str
| | | | ContactPhone | str
| | | | ContactMobile | str
| | | | ContactEmail | str
| | | | ContactFax | str
| | | | Comments | str
| | | | LastViewedDate | str
| | | | LastReferencedDate | str
| | | | hostchain | str
| | | ✓ | tag | str
| | | ✓ | rawMessage | str
| | | ✓ |
Field | Type | Field transformation | Source field name | Extra fields |
|---|
eventdate | timestamp
| | | | hostname | str
| | | | attributes_type | str
| | | | attributes_url | str
| | | | Id | str
| | | | ContentDocumentId | str
| | | | IsLatest | bool
| | | | ContentUrl | str
| | | | ContentBodyId | str
| | | | VersionNumber | str
| | | | Title | str
| | | | Description | str
| | | | ReasonForChange | str
| | | | SharingOption | str
| | | | SharingPrivacy | str
| | | | PathOnClient | str
| | | | RatingCount | int8
| | | | IsDeleted | bool
| | | | ContentModifiedDate | str
| | | | ContentModifiedById | str
| | | | PositiveRatingCount | int8
| | | | NegativeRatingCount | int8
| | | | FeaturedContentBoost | str
| | | | FeaturedContentDate | str
| | | | OwnerId | str
| | | | CreatedById | str
| | | | CreatedDate | str
| | | | LastModifiedDate | timestamp
| | Code Block |
|---|
parsedate(LastModifiedDate_str, "YYYY-MM-DD[T]HH:mm:ss.SSSZZ") |
| LastModifiedDate_str | | LastModifiedById | str
| | | | SystemModstamp | str
| | | | TagCsv | str
| | | | FileType | str
| | | | PublishStatus | str
| | | | VersionData | str
| | | | ContentSize | int8
| | | | FileExtension | str
| | | | FirstPublishLocationId | str
| | | | Origin | str
| | | | ContentLocation | str
| | | | TextPreview | str
| | | | ExternalDocumentInfo1 | str
| | | | ExternalDocumentInfo2 | str
| | | | ExternalDataSourceId | str
| | | | Checksum | str
| | | | IsMajorVersion | bool
| | | | IsAssetEnabled | bool
| | | | hostchain | str
| | | ✓ | tag | str
| | | ✓ | rawMessage | str
| | | ✓ |
Field | Type | Field transformation | Source field name | Extra fields |
|---|
eventdate | timestamp
| | | | hostname | str
| | | | attributes_type | str
| | | | attributes_url | str
| | | | Id | str
| | | | IsDeleted | bool
| | | | FolderId | str
| | | | FolderName | str
| | | | Title | str
| | | | DeveloperName | str
| | | | NamespacePrefix | str
| | | | Description | str
| | | | LeftSize | str
| | | | MiddleSize | str
| | | | RightSize | str
| | | | CreatedDate | str
| | | | CreatedById | str
| | | | LastModifiedDate | timestamp
| | Code Block |
|---|
parsedate(LastModifiedDate_str, "YYYY-MM-DD[T]HH:mm:ss.SSSZZ") |
| LastModifiedDate_str | | LastModifiedById | str
| | | | SystemModstamp | str
| | | | RunningUserId | str
| | | | TitleColor | int8
| | | | TitleSize | int8
| | | | TextColor | int8
| | | | BackgroundStart | int8
| | | | BackgroundEnd | int8
| | | | BackgroundDirection | str
| | | | Type | str
| | | | LastViewedDate | str
| | | | LastReferencedDate | str
| | | | DashboardResultRefreshedDate | str
| | | | DashboardResultRunningUser | str
| | | | ColorPalette | str
| | | | ChartTheme | str
| | | | hostchain | str
| | | ✓ | tag | str
| | | ✓ | rawMessage | str
| | | ✓ |
Field | Type | Field transformation | Source field name | Extra fields |
|---|
eventdate | timestamp
| | | | hostname | str
| | | | attributes_type | str
| | | | attributes_url | str
| | | | Id | str
| | | | IsDeleted | bool
| | | | CreatedDate | str
| | | | CreatedById | str
| | | | LastModifiedDate | timestamp
| | Code Block |
|---|
parsedate(LastModifiedDate_str, "YYYY-MM-DD[T]HH:mm:ss.SSSZZ") |
| LastModifiedDate_str | | LastModifiedById | str
| | | | SystemModstamp | str
| | | | EventType | str
| | | | LogDate | timestamp
| | | | LogFileLength | float8
| | | | LogFileContentType | str
| | | | ApiVersion | str
| | | | Sequence | int4
| | | | Interval | str
| | | | LogFileFieldNames | str
| | | | LogFileFieldTypes | str
| | | | LogFile | str
| | | | hostchain | str
| | | ✓ | tag | str
| | | ✓ | rawMessage | str
| | | ✓ |
Field | Type | Extra fields |
|---|
eventdate | timestamp
| | hostname | str
| | attributes_type | str
| | attributes_url | str
| | Application | str
| | Browser | str
| | City | str
| | CountryIso | str
| | EventDate | timestamp
| | EventIdentifier | str
| | RelatedEventIdentifier | str
| | LoginType | str
| | Platform | str
| | SourceIp | ip4
| | UserId | str
| | Username | str
| | UserType | str
| | Status | str
| | hostchain | str
| ✓ | tag | str
| ✓ | rawMessage | str
| ✓ |
Field | Type | Field transformation | Source field name | Extra fields |
|---|
eventdate | timestamp
| | | | hostname | str
| | | | attributes_type | str
| | | | attributes_url | str
| | | | Id | str
| | | | UserId | str
| | | | LoginTime | timestamp
| | Code Block |
|---|
parsedate(LoginTime_str, "YYYY-MM-DD[T]HH:mm:ss.SSSZZ") |
| LoginTime_str | | LoginType | str
| | | | SourceIp | ip4
| | | | LoginUrl | str
| | | | AuthenticationServiceId | str
| | | | LoginGeoId | str
| | | | TlsProtocol | str
| | | | CipherSuite | str
| | | | OptionsIsGet | bool
| | | | OptionsIsPost | bool
| | | | Browser | str
| | | | Platform | str
| | | | Status | str
| | | | Application | str
| | | | ClientVersion | str
| | | | ApiType | str
| | | | ApiVersion | str
| | | | CountryIso | str
| | | | hostchain | str
| | | ✓ | tag | str
| | | ✓ | rawMessage | str
| | | ✓ |
Field | Type | Extra fields |
|---|
eventdate | timestamp
| | hostname | str
| | attributes_type | str
| | attributes_url | str
| | EventDate | timestamp
| | EventIdentifier | str
| | LoginKey | str
| | SessionKey | str
| | SourceIp | ip4
| | UserId | str
| | Username | str
| | hostchain | str
| ✓ | tag | str
| ✓ | rawMessage | str
| ✓ |
Field | Type | Field transformation | Source field name | Extra fields |
|---|
eventdate | timestamp
| | | | hostname | str
| | | | attributes_type | str
| | | | attributes_url | str
| | | | Id | str
| | | | IsDeleted | bool
| | | | AccountId | str
| | | | IsPrivate | bool
| | | | Name | str
| | | | Description | str
| | | | StageName | str
| | | | Amount | float8
| | | | Probability | float8
| | | | ExpectedRevenue | float8
| | | | TotalOpportunityQuantity | str
| | | | CloseDate | str
| | | | Type | str
| | | | NextStep | str
| | | | LeadSource | str
| | | | IsClosed | bool
| | | | IsWon | bool
| | | | ForecastCategory | str
| | | | ForecastCategoryName | str
| | | | CampaignId | str
| | | | HasOpportunityLineItem | bool
| | | | Pricebook2Id | str
| | | | OwnerId | str
| | | | CreatedDate | str
| | | | CreatedById | str
| | | | LastModifiedDate | timestamp
| | Code Block |
|---|
parsedate(LastModifiedDate_str, "YYYY-MM-DD[T]HH:mm:ss.SSSZZ") |
| LastModifiedDate_str | | LastModifiedById | str
| | | | SystemModstamp | str
| | | | LastActivityDate | str
| | | | FiscalQuarter | int8
| | | | FiscalYear | int8
| | | | Fiscal | str
| | | | ContactId | str
| | | | LastViewedDate | str
| | | | LastReferencedDate | str
| | | | HasOpenActivity | bool
| | | | HasOverdueTask | bool
| | | | hostchain | str
| | | ✓ | tag | str
| | | ✓ | rawMessage | str
| | | ✓ |
Field | Type | Field transformation | Source field name | Extra fields |
|---|
eventdate | timestamp
| | | | hostname | str
| | | | attributes_type | str
| | | | attributes_url | str
| | | | Id | str
| | | | OwnerId | str
| | | | FolderName | str
| | | | CreatedDate | str
| | | | CreatedById | str
| | | | LastModifiedDate | timestamp
| | Code Block |
|---|
parsedate(LastModifiedDate_str, "YYYY-MM-DD[T]HH:mm:ss.SSSZZ") |
| LastModifiedDate_str | | LastModifiedById | str
| | | | IsDeleted | bool
| | | | Name | str
| | | | Description | str
| | | | DeveloperName | str
| | | | NamespacePrefix | str
| | | | LastRunDate | str
| | | | SystemModstamp | str
| | | | Format | str
| | | | LastViewedDate | str
| | | | LastReferencedDate | str
| | | | hostchain | str
| | | ✓ | tag | str
| | | ✓ | rawMessage | str
| | | ✓ |
Field | Type | Field transformation | Source field name | Extra fields |
|---|
eventdate | timestamp
| | | | hostname | str
| | | | attributes_type | str
| | | | attributes_url | str
| | | | Id | str
| | | | IsDeleted | bool
| | | | MasterRecordId | str
| | | | Name | str
| | | | Type | str
| | | | ParentId | str
| | | | BillingStreet | str
| | | | BillingCity | str
| | | | BillingState | str
| | | | BillingPostalCode | str
| | | | BillingCountry | str
| | | | BillingLatitude | str
| | | | BillingLongitude | str
| | | | BillingGeocodeAccuracy | str
| | | | BillingAddress_city | str
| | | | BillingAddress_country | str
| | | | BillingAddress_geocodeAccuracy | str
| | | | BillingAddress_latitude | str
| | | | BillingAddress_longitude | str
| | | | BillingAddress_postalCode | str
| | | | BillingAddress_state | str
| | | | BillingAddress_street | str
| | | | ShippingStreet | str
| | | | ShippingCity | str
| | | | ShippingState | str
| | | | ShippingPostalCode | str
| | | | ShippingCountry | str
| | | | ShippingLatitude | str
| | | | ShippingLongitude | str
| | | | ShippingGeocodeAccuracy | str
| | | | ShippingAddress_city | str
| | | | ShippingAddress_country | str
| | | | ShippingAddress_geocodeAccuracy | str
| | | | ShippingAddress_latitude | str
| | | | ShippingAddress_longitude | str
| | | | ShippingAddress_postalCode | str
| | | | ShippingAddress_state | str
| | | | ShippingAddress_street | str
| | | | Phone | str
| | | | Fax | str
| | | | AccountNumber | str
| | | | Website | str
| | | | PhotoUrl | str
| | | | Sic | str
| | | | Industry | str
| | | | AnnualRevenue | str
| | | | NumberOfEmployees | int8
| | | | Ownership | str
| | | | TickerSymbol | str
| | | | Description | str
| | | | Rating | str
| | | | Site | str
| | | | OwnerId | str
| | | | CreatedDate | str
| | | | CreatedById | str
| | | | LastModifiedDate | timestamp
| | Code Block |
|---|
parsedate(LastModifiedDate_str, "YYYY-MM-DD[T]HH:mm:ss.SSSZZ") |
| LastModifiedDate_str | | LastModifiedById | str
| | | | SystemModstamp | str
| | | | LastActivityDate | str
| | | | LastViewedDate | str
| | | | LastReferencedDate | str
| | | | Jigsaw | str
| | | | JigsawCompanyId | str
| | | | CleanStatus | str
| | | | AccountSource | str
| | | | DunsNumber | str
| | | | Tradestyle | str
| | | | NaicsCode | str
| | | | NaicsDesc | str
| | | | YearStarted | str
| | | | SicDesc | str
| | | | DandbCompanyId | str
| | | | OperatingHoursId | str
| | | | IsBuyer | bool
| | | | hostchain | str
| | | ✓ | tag | str
| | | ✓ | rawMessage | str
| | | ✓ |
Field | Type | Extra fields |
|---|
eventdate | timestamp
| | hostname | str
| | attributes_type | str
| | attributes_url | str
| | Id | str
| | Action | str
| | CreatedBy__attributes__type | str
| | CreatedBy__attributes__url | str
| | CreatedBy__Id | str
| | CreatedBy__Name | str
| | CreatedDate | str
| | Display | str
| | Section | str
| | hostchain | str
| ✓ | tag | str
| ✓ | rawMessage | str
| ✓ |
Field | Type | Field transformation | Source field name | Extra fields |
|---|
eventdate | timestamp
| | | | hostname | str
| | | | attributes_url | str
| | | | attributes_type | str
| | | | Id | str
| | | | IsActive | bool
| | | | Name | str
| | | | LastLoginDate | timestamp
| | Code Block |
|---|
parsedate(LastLoginDate_str, "YYYY-MM-DD[T]HH:mm:ss.SSSZZ") |
| LastLoginDate_str | | LastModifiedDate | timestamp
| | Code Block |
|---|
parsedate(LastModifiedDate_str, "YYYY-MM-DD[T]HH:mm:ss.SSSZZ") |
| LastModifiedDate_str | | FirstName | str
| | | | LastName | str
| | | | City | str
| | | | Country | str
| | | | Latitude | float8
| | | | Longitude | float8
| | | | MobilePhone | str
| | | | PostalCode | str
| | | | State | str
| | | | Username | str
| | | | UserRoleId | str
| | | | UserType | str
| | | | Email | str
| | | | CompanyName | str
| | | | ProfileId | str
| | | | Profile_PermissionsApiEnabled | bool
| | | | Profile_PermissionsModifyAllData | bool
| | | | Profile_PermissionsViewSetup | bool
| | | | hostchain | str
| | | ✓ | tag | str
| | | ✓ | rawMessage | str
| | | ✓ |
|
