Salesforce

Guide to integrate your Salesforce with Sprinkle

Datasource Concepts

Before setting up the datasource, learn about datasource concepts here

Step by Step Guide

STEP-1: Configure Connection

To learn about Connection, refer here

  • Log into Sprinkle application

  • Navigate to Datasources -> Connections Tab -> New Connection ->

  • Select Salesforce

  • Provide all the mandatory details

    • Name: Name to identify this connection

    • Server Location: After login to salesforce account, from url you can copy server location. ex- https://ap16.lightning.force.com/lightning/page/home for this url ap16 is domain.

    • Username: This is same username/email which is used to login to salesforce.

    • Password: This is same password which is used to login salesforce.

    • Security Token: To generate the security key, go to personal settings on the Salesforce portal and reset the security token. Then you will receive the token via email. For more details visit this page or watch this video.

    • Advance Settings : Refer here

  • Test Connection

  • Create

STEP-2: Configure Datasource

To learn about datasource, refer here

  • Navigate to Datasources -> Datasources Tab -> Add ->

  • Select Salesforce

  • Provide the name -> Create

  • Connection Tab:

    • From the drop-down, select the name of connection created in STEP-2

    • Update

STEP-3: Create Dataset

Datasets Tab: To learn about Dataset, refer here. Add Dataset for each report/dataset that you want to integrate, providing following details

  • Table Type (Required) :

    • Standard Objects

      • Standard Object: Select the name from the drop-down

    • Query

      • Query: Provide the Query string

  • Flatten Level(Required) : Select One Level or Multi Level. In one level, flattening will not be applied on complex type. They will be stored as string. In multi level, flattening will be applied in complex level till they become simple type.

  • Destination Schema (Required) : Data warehouse schema where the table will be ingested into

  • Destination Table name (Required) : It is the table name to be created on the warehouse. If not given, sprinkle will create like ds_<datasourcename>_<tablename>

  • Destination Create Table Clause: Provide additional clauses to warehouse-create table queries such as clustering, partitioning, and more, useful for optimizing DML statements. Learn more on how to use this field.

  • Create

STEP-4: Run and schedule Ingestion

In the Ingestion Jobs tab:

  • Trigger the Job, using Run button

  • To schedule, enable Auto-Run. Change the frequency if required

Advanced Connection Settings

  • API Read Timeout (In seconds) : Maximum time of inactivity between two data packets when waiting for the server's response. The default value is 30 seconds

  • API Connection Timeout (In seconds) : Time period within which a connection between a client and a server must be established.

  • Version : It gives information about the version of Salesforce API being used.

DataSet Fields

AIApplication
  • DeveloperName

  • Language

  • MasterLabel

  • NamespacePrefix

  • Status

  • Type

AIApplicationConfig
  • DeveloperName

  • Language

  • MasterLabel

  • NamespacePrefix

AIInsightAction
  • ActionId

  • ActionName

  • AiRecordInsightId

  • Confidence

  • Name

  • Type

AIInsightFeedback
  • ActualValue

  • AiFeedbacK

  • AiInsightFeedbackType

  • AiRecordInsightId

  • Name

  • Rank

  • ValueId

AIInsightReason
  • AiInsightValueId

  • Contribution

  • FeatureType

  • FeatureValue

  • FieldName

  • FieldValue

  • Intensity

  • Name

  • Operator

  • ReasonLabelKey (Beta)

  • RelatedInsightReasonId (Beta)

  • SortOrder (Beta)

  • Variance

AIInsightValue
  • AiInsightActionId

  • AiRecordInsightId

  • Confidence

  • Field

  • FieldValueLowerBound

  • FieldValueUpperBound

  • Name

  • SobjectLookupValueId

  • SobjectType

  • Value

  • ValueType

AIRecordInsight
  • AiApplicationId

  • Confidence

  • MlPredictionDefinitionId

  • Name

  • PredictionField

  • RunGuid

  • RunStartTime

  • Staus

  • TargetField

  • TargetId

  • TargetSobjectType

  • Type

  • ValidUntil

AcceptedEventRelation
  • EventId

  • RelationId

  • RespondedDate

  • Response

  • Type

Account
  • AccountNumber

  • AccountSource

  • AnnualRevenue

  • BillingAddress

  • BillingCity

  • BillingCountry

  • BillingCountryCode

  • BillingGeoCodeAccuracy

  • BillingLatitude

  • BillingLongitude

  • BilllingPostalCode

  • BillingState

  • BillingStateCode

  • BillingStreet

  • ChannelProgramName

  • ChannelProgramLevelName

  • CleanStatus

  • ConnectionReceivedId

  • ConnectionSentId

  • Description

  • DunsNumber

  • Fax

  • HasOptedOutOfEmail

  • Industry

  • IsCustomerPortal

  • IsDeleted

  • IsPartner

  • IsPersonAccount

  • Jigsaw

  • LastActivityDate

  • LastReferencedDate

  • LastViewedDate

  • MasterRecordId

  • NaicsCode

  • NaicsDesc

  • Name

  • NumberOfEmployees

  • OperatingHoursId

  • OwnerId

  • Ownership

  • ParentId

  • PersonIndividualId

  • Phone

  • PhotoUrl

  • Rating

  • RecordTypeId

  • Salutation

  • ShippingAddress

  • ShippingCity

  • ShippingCountry

  • ShippingCountryCode

  • ShippingGeocodeAccuracy

  • ShippingLatitude

  • ShippingLongitude

  • ShippingPostalCode

  • ShippingState

  • ShippingStateCode

  • ShippingStreet

  • Sic

  • SicDesc

  • Site

  • TickerSymbol

  • Tradestyle

  • Type

  • Website

  • YearStarted

AccountCleanInfo
  • AccountId

  • AccountSite

  • Address

  • AnnualRevenue

  • City

  • CleanedByJob

  • CleanedByUser

  • CompanyName

  • CompanyStatusDataDotCom

  • Country

  • DandBCompanyDunsNumber

  • Description

  • DataDotComId

  • DunsNumber

  • DunsRightMatchConfidence

  • DunsRightMatchGrade

  • Fax

  • Industry

  • IsDifferentAccountSite

  • IsDifferentAnnualRevenue

  • IsDifferentCity

  • IsDifferentCompanyName

  • IsDifferentCountry

  • sDifferentCountryCode

  • IsDifferentDandBCompanyDunsNumber

  • IsDifferentDescription

  • IsDifferentDunsNumber

  • IsDifferentFax

  • IsDifferentIndustry

  • IsDifferentNaicsCode

  • IsDifferentNaicsDescription

  • IsDifferentNumberOfEmployees

  • IsDifferentOwnership

  • IsDifferentPhone

  • IsDIfferentPostalCode

  • IsDifferentSic

  • IsDifferentSicDescription

  • IsDifferentState

  • IsDifferentStateCode

  • IsDifferentStreet

  • IsDifferentTickerSymbol

  • IsDifferentTradestyle

  • IsDifferentWebsite

  • IsDifferentYearStarted

  • IsFlaggedWrongAccountSite

  • IsFlaggedWrongAddress

  • IsFlaggedWrongAnnualRevenue

  • IsFlaggedWrongCompanyName

  • IsFlaggedWrongDescription

  • IsFlaggedWrongDunsNumber

  • IsFlaggedWrongFax

  • IsFlaggedWrongIndustry

  • IsFlaggedWrongNaicsCode

  • IsFlaggedWrongNaicsDescription

  • IsFlaggedWrongNumberOfEmployees

  • IsFlaggedWrongOwnership

  • IsFlaggedWrongPhone

  • IsFlaggedWrongSic

  • IsFlaggedWrongSicDescription

  • IsFlaggedWrongTickerSymbol

  • IsFlaggedWrongTradestyle

  • IsFlaggedWrongWebsite

  • IsFlaggedWrongYearStarted

  • IsInactive

  • IsReviewedAccountSite

  • IsReviewedAddress

  • IsReviewedAnnualRevenue

  • IsReviewedCompanyName

  • IsReviewedDandBCompanyDunsNumber

  • IsReviewedDescription

  • IsReviewedDunsNumber

  • IsReviewedFax

  • IsReviewedIndustry

  • IsReviewedNaicsCode

  • IsReviewedNaicsDescription

  • IsFlaIsReviewedNumberOfEmployees

  • IsReviewedOwnership

  • IsReviewedPhone

  • IsReviewedSic

  • IsReviewedSicDescription

  • IsReviewedTickerSymbol

  • IsReviewedTradestyle

  • IsReviewedWebsite

  • IsReviewedYearStarted

  • LastMatchedDate

  • LastStatusChangedById

  • LastStatusChangedDate

  • Latitude

  • Longitude

  • Naicscode

  • NaicsDescription

  • Name

  • NumberOfEmployees

  • Ownership

  • Phone

  • PostalCode

  • Sic

  • SicDescription

  • State

  • Street

  • TickerSymbol

  • TradeStyle

  • Website

  • YearStarted

AccountContactRole
  • AccountId

  • ContactId

  • IsDeleted

  • IsPrimary

  • Role

AccountPartner
  • AccountFromId

  • AccountToId

  • IsPrimary

  • OpportunityId

  • ReversePartnerId

  • Role

AccountShare
  • AccountAccessLevel

  • AccountId

  • CaseAccessLevel

  • ContactAccessLevel

  • OpportunityAccessLevel

  • RowCause

  • UserOrGroupId

ActionLinkGroupTemplate
  • Category

  • DeveloperName

  • ExecutionsAllowed

  • HoursUntilExpiration

  • IsPublished

  • Language

  • MasterLabel

  • NamespacePrefix

ActionLinkTemplate
  • ActionLinkGroupTemplateId

  • ActionUrl

  • Headers

  • IsConfirmationRequired

  • IsGroupDefault

  • Label

  • LabelKey

  • LinkType

  • Method

  • Position

  • RequestBody

  • UserAlias

  • UserVisibility

ActiveFeatureLicenseMetric
  • ActiveUserCount

  • AssignedUserCount

  • FeatureType

  • MetricsDate

  • TotalLicenseCount

  • attributes_type

  • attributes_url

  • id

  • systemmoddate

ActivePermSetLicenseMetric
  • ActiveUserCount

  • AssignedUserCount

  • MetricsDate

  • PermissionSetLicenseId

  • attributes_type

  • attributes_url

  • id

  • systemmoddate

ActiveProfileMetric
  • ActiveUserAccount

  • AssignedUserCount

  • MetricsDate

  • ProfileId

  • UserLicenseId

  • attributes_type

  • attributes_url

  • id

  • systemmoddate

ActivityHistory
  • AccountId

  • ActivityDate

  • ActivityDateTime

  • ActivitySubtype

  • ActivityType

  • AlternateDetailId

  • CallDisposition

  • CallDurationInSeconds

  • CallObject

  • CallType

  • CompletedDateTime

  • ConnectionReceivedId

  • ConnectionSentId

  • Description

  • Division

  • DurationInMinutes

  • EndDateTime

  • IsAllDayEvent

  • IsClosed

  • IsDeleted

  • IsHighPriority

  • IsOnlineMeeting

  • IsReminderSet

  • IsTask

  • IsVisibleInSelfService

  • Location

  • OwnerId

  • PrimaryAccountId

  • PrimaryWhoId

  • Priority

  • ReminderDateTime

  • StartDateTime

  • Status

  • Subject

  • WhatId

  • WhoId

AdditionalNumber
  • CallCentreId

  • Description

  • Name

  • Phone

AlternativePaymentMethod
  • AccountId

  • AlternativePaymentMethodNumber

  • AuditEmail

  • Comments

  • CompanyName

  • Email

  • GatewayToken

  • GatewayTokenDetails

  • IpAddress

  • LastReferencedDate

  • LastViewedDate

  • MacAddress

  • Nickname

  • OwnerId

  • PaymentGatewayId

  • PaymentMethodAddress

  • PaymentMethodCity

  • PaymentMethodCountry

  • PaymentMethodGeocodeAccuracy

  • PaymentMethodLatitude

  • PaymentMethodLongitude

  • PaymentMethodState

  • PaymentMethodPostalCode

  • PaymentMethodStreet

  • Phone

  • ProcessingMode

  • Status

Announcement
  • ExpirationDate

  • FeedItemId

  • ParentId

  • SendEmails

ApexClass
  • ApiVersion

  • Body

  • BodyCrc

  • IsValid

  • LengthWithoutComments

  • Name

  • NamespacePrefix

  • Status

ApexComponent
  • ApiVersion

  • ControllerKey

  • ControllerType

  • Description

  • Markup

  • MasterLabel

  • Name

  • NamespacePrefix

ApexLog
  • Application

  • DurationMilliseconds

  • Location

  • LogLength

  • LogUserId

  • Operation

  • Request

  • RequestIdentifier

  • StartTime

  • Status

ApexPage
  • ApiVersion

  • ControllerKey

  • ControllerType

  • Description

  • IsAvailableInTouch

  • IsConfirmationTokenRequired

  • Markup

  • MasterLabel

  • Name

  • NamespacePrefix

ApexPageInfo
  • ApexPageId

  • ApiVersion

  • Description

  • DurableId

  • IsAvailableInTouch

  • IsShowHeader

  • MasterLabel

  • Name

  • NameSpacePrefix

ApexTestQueueItem
  • ApexClassId

  • ExtendedStatus

  • ParentJobId

  • ShouldSkipCodeCoverage

  • Status

  • TestRunResultId

ApexTestResult
  • ApexClassId

  • ApexLogId

  • ApexTestRunResultId

  • AsyncApexJobId

  • Message

  • Method

  • Outcome

  • QueueItemId

  • RunTime

  • StackTrace

  • TestTimestamp

ApexTestResultLimits
  • ApexTestResultId

  • AsyncCalls

  • Callouts

  • Cpu

  • Dml

  • DmlRows

  • Email

  • LimitContext

  • LimitExceptions

  • MobilePush

  • QueryRows

  • Soql

  • Sosl

ApexTestRunResult
  • AsyncApexJobId

  • ClassesCompleted

  • ClassesEnqueued

  • EndTime

  • IsAllTests

  • JobName

  • MethodsCompleted

  • MethodsEnqueued

  • MethodsFailed

  • Source

  • StartTime

  • Status

  • TestTime

  • UserId

ApexTestSuite
  • TestSuiteName

ApexTrigger
  • ApiVersion

  • Body

  • BodyCrc

  • IsValid

  • LengthWithoutComments

  • Name

  • NamespacePrefix

  • Status

  • TableEnumOrId

  • UsageAfterDelete

  • UsageAfterInsert

  • UsageAfterUndelete

  • UsageAfterUpdate

  • UsageBeforeDelete

  • UsageBeforeInsert

  • UsageBeforeUpdate

  • UsageIsBulk

AppAnalyticsQueryRequest
  • AvailableSince

  • DataType

  • DownloadExpirationTime

  • DownloadSize

  • DownloadUrl

  • EndTime

  • ErrorMessage

  • FileCompression

  • FileType

  • LastReferencedDate

  • LastViewedDate

  • Name

  • OrganizationIds

  • PackageIds

  • QuerySubmittedTime

  • RequestState

  • StartTime

AppDefinition
  • Description

  • DeveloperName

  • DurableId

  • HeaderColor

  • Id

  • IsLargeFormFactorSupported

  • IsMediumFormFactorSupported

  • IsNavAutoTempTabsDisabled

  • IsNavPersonalizationDisabled

  • IsNavTabPersistenceDisabled

  • IsOverrideOrgTheme

  • IsSmallFormFactorSupported

  • Label

  • LogoUrl

  • MasterLabel

  • NamespacePrefix

  • NavType

  • UiType

  • UtilityBar

AppMenuId
  • ApplicationId

  • CanvasAccessMethod

  • CanvasEnabled

  • CanvasOptions

  • CanvasReferenceId

  • CanvasSelectedLocations

  • CanvasUrl

  • Description

  • IconUrl

  • InfoUrl

  • IsAccessible

  • IsRegisteredDeviceOnly

  • IsUsingAdminAuthorization

  • IsVisible

  • Label

  • LogoUrl

  • MobileAppBinaryId

  • MobileAppInstallUrl

  • MobileAppInstalledDate

  • MobileAppInstalledVersion

  • MobileAppVer

  • MobileDeviceType

  • MobileMinOsVer

  • MobilePlatform

  • MobileStartUrl

  • Name

  • NamespacePrefix

  • SortOrder

  • StartUrl

  • Type

  • UserSortOrder

AppTabMember
  • AppDefinitionId

  • DurableId

  • SortOrder

  • TabDefinitionId

  • WorkspaceDriverField

AppUsageAssignment
  • AppUsageType

  • Name

  • RecordId

Asset
  • AccountId

  • AssetLevel

  • AssetProvidedById

  • AssetServicedById

  • Availability

  • AverageUptimePerDay

  • ConsequenceOfFailure

  • ContactId

  • CurrentAmount

  • CurrentLifecycleEndDate

  • CurrentMrr

  • CurrentQuantity

  • Description

  • DigitalAssetStatus

  • ExternalIdentifier

  • HasLifecycleManagement

  • InstallDate

  • IsCompetitorProduct

  • IsInternal

  • LastReferencedDate

  • LastViewedDate

  • LifecycleEndDate

  • LifecycleStartDate

  • LocationId

  • ManufactureDate

  • Name

  • OwnerId

  • ParentId

  • Price

  • Product2Id

  • ProductCode

  • ProductDescription

  • ProductFamily

  • PurchaseDate

  • Quantity

  • Reliability

  • RootAssetId

  • SerialNumber

  • Status

  • StatusReason

  • StockKeepingUnit

  • SumDowntime

  • SumUnplannedDowntime

  • TotalLifecycleAmount

  • UptimeRecordEnd

  • UptimeRecordStart

  • UsageEndDate

  • Uuid

AssetAction
  • ActionDate

  • ActualTaxChange

  • AdjustmentAmountChange

  • Amount

  • AssetActionNumber

  • AssetId

  • Category

  • CategoryEnum

  • EstimatedTaxChange

  • MrrChange

  • ProductAmountChange

  • QuantityChange

  • SubtotalChange

  • TotalAmount

  • TotalCancellationsAmount

  • TotalCrossSellsAmount

  • TotalDownSellsAmount

  • TotalInitialSaleAmount

  • TotalMrr

  • TotalOtherAmount

  • TotalQuantity

  • TotalRenewalsAmount

  • TotalTermsAndConditionsAmount

  • TotalTransfersAmount

  • TotalUpsellsAmount

  • Type

AssetActionSource
  • ActualTax

  • AdjustmentAmount

  • AssetActionId

  • AssetActionSourceNumber

  • EndDate

  • EstimatedTax

  • ExternalReference

  • ExternalReferenceDataSource

  • ProductAmount

  • Quantity

  • ReferenceEntityItemId

  • StartDate

  • Subtotal

  • TransactionDate

AssetRelationship
  • AssetId

  • AssetRelationshipNumber

  • FromDate

  • LastReferencedDate

  • LastViewedDate

  • RelatedAssetId

  • RelationshipType

  • ToDate

AssetShare
  • AssetAccessLevel

  • AssetId

  • IsDeleted

  • RowCause

  • UserOrGroupId

AssetStatePeriod
  • Amount

  • AssetId

  • AssetStatePeriodNumber

  • EndDate

  • Mrr

  • Quantity

  • StartDate

AssetTokenEvent
  • ActorTokenPayload

  • AssetId

  • AssetName

  • AssetSerialNumber

  • ConnectedAppId

  • DeviceId

  • DeviceKey

  • EventUuid

  • Expiration

  • Name

  • ReplayId

  • UserId

AssignmentRule
  • Active

  • Name

  • SobjectType

AssociatedLocation
  • ActiveFrom

  • ActiveTo

  • AssociatedLocationNumber

  • LastReferencedDate

  • LastViewedDate

  • LocationId

  • ParentRecordId

  • Type

AsyncApexJob
  • ApexClassId

  • CompletedDate

  • CronTriggerId

  • ExtendedStatus

  • JobItemsProcessed

  • JobType

  • LastProcessed

  • LastProcessedOffset

  • MethodName

  • NumberOfErrors

  • ParentJobId

  • Status

  • TotalJobItems

AsyncOperationLog
  • AsyncOperationNumber

  • Description

  • Error

  • ExternalReference

  • FinishedAt

  • LastStatusUpdateAt

  • Request

  • Response

  • StartedAt

  • Status

  • Type

AttachedContentDocument
  • ContentDocumentId

  • ContentSize

  • ConentUrl

  • ExternalDataSourceName

  • ExternalDataSourceType

  • FileExtension

  • FileType

  • LinkedEntityId

  • SharingOption

  • Title

Attachment
  • Body

  • BodyLength

  • ConnectionReceivedId

  • ConnectionSentId

  • ContentType

  • Description

  • IsEncryted

  • IsPartnerShared

  • IsPrivate

  • Name

  • OwnerId

  • ParentId

AuthProvider
  • AppleTeam

  • AuthorizeUrl

  • ConsumerKey

  • ConsumerSecret

  • CustomMetadataTypeRecord

  • DefaultScopes

  • DeveloperName

  • EcKey

  • ErrorUrl

  • ExecutionUserId

  • FriendlyName

  • IconUrl

  • IdTokenIssuer

  • LinkKickoffUrl

  • LogoutUrl

  • OauthKickoffUrl

  • OptionsIncludeOrgIdInId

  • OptionsSendAccessTokenInHeader

  • OptionsSendClientCredentialsInHeader

  • OptionsSendSecretInApis

  • PluginId

  • ProviderType

  • RegistrationHandlerId

  • SsoKickoffUrl

  • TokenUrl

  • UserInfoUrl

AuthSession
  • CreatedDate

  • Id

  • IsCurrent

  • LoginGeoId

  • LoginHistoryId

  • LoginType

  • LogoutUrl

  • NumSecondsValid

  • ParentId

  • SessionSecurityLevel

  • SessionType

  • SourceIp

  • UserType

  • UsersId

AuthorizationForm
  • DefaultAuthFormTextId

  • EffectiveFromDate

  • EffectiveToDate

  • IsSignatureRequired

  • LastReferencedDate

  • LastViewedDate

  • Name

  • OwnerId

  • RevisionNumber

AuthorizationFormConsent
  • AuthorizationFormTextId

  • ConsentCapturedDateTime

  • ConsentCapturedSource

  • ConsentCapturedSourceType

  • ConsentGiverId

  • DocumentVersionId

  • LastReferencedDate

  • LastViewedDate

  • Name

  • OwnerId

  • RelatedRecordId

  • Status

  • PartyId

AuthorizationFormDataUse
  • AuthorizationFormId

  • DataUsePurposeId

  • LastReferencedDate

  • LastViewedDate

  • Name

  • OwnerId

AuthorizationFormText
  • AuthorizationFormId

  • ContentDocumentId

  • FullAuthorizationFormUrl

  • LastReferencedDate

  • LastViewedDate

  • Locale

  • LocaleSelection

  • Name

  • SummaryAuthFormText

Background Operation
  • Error

  • ExecutionGroup

  • ExpiresAt

  • FinishedAt

  • GroupLeaderId

  • Name

  • NumFollowers

  • ParentKey

  • ProcessAfter

  • RetryBackoff

  • RetryCount

  • RetryLimit

  • SequenceGroup

  • SequenceNumber

  • StartedAt

  • Status

  • SubmittedAt

  • Timeout

  • Type

  • WorkerUri

BatchApexErrorEvent
  • AsyncApexJobId

  • DoesExceedJobScopeMaxLength

  • EventUuid

  • ExecutionType

  • JobScope

  • Message

  • Phase

  • ReplayId

  • RequestId

  • StackTrace

BrandTemplate
  • Description

  • DeveloperName

  • IsActive

  • Name

  • NamespacePrefix

  • Value

BriefcaseAssignment
  • BriefcaseId

  • UserOrGroupId

BriefcaseDefinition
  • Description

  • DeveloperName

  • IsActive

  • Language

  • MasterLabel

  • NamespacePrefix

BriefcaseRule
  • BriefcaseId

  • FilterLogic

  • IsAscendingOrder

  • OrderBy

  • QueryScope

  • RecordLimit

  • TargetEntity

BriefcaseRuleFilter
  • BriefcaseRuleId

  • FilterOperator

  • FilterSeqNumber

  • FilterValue

  • TargetEntityField

BusinessHours
  • BusinessHoursId

  • IsActive

  • Name

  • IsDefault

  • LastViewedDate

  • FridayEndTime

  • FridayStartTime

  • MondayEndTime

  • MondayStartTime

  • SaturdayEndTime

  • SaturdayStartTime

  • SundayEndTime

  • SundayStartTime

  • ThursdayEndTime

  • ThursdayStartTime

  • TimeZoneSidKey

  • TuesdayEndTime

  • TuesdayStartTime

  • WednesdayEndTime

  • WednesdayStartTime

BusinessProcess
  • Description

  • IsActive

  • Name

  • NamespacePrefix

  • TableEnumOrId

Calendar
  • attributes_type

  • attributes_url

  • id

  • userid

  • type

  • isactive

  • createddate

  • createdbyid

  • lastmodifieddate

  • lastmodifiedbyid

  • systemmodstamp

CalendarView
  • Color

  • CurrencyIsoCode

  • DateHandlingType

  • DisplayField

  • EndField

  • FillPattern

  • IsDisplayed

  • ListViewFilterId

  • Name

  • OwnerId

  • PublisherId

  • SobjectType

  • StartField

CallCenter
  • AdapterUrl

  • CustomSettings

  • Id

  • InternalName

  • Name

  • Version

CallCoachingMediaProvider
  • IsActive

  • ProviderDescription

  • ProviderName

Campaign
  • attributes_type

  • attributes_url

  • id

  • isdeleted

  • ActualCost

  • AmountAllOpportunities

  • AmountWonOpportunities

  • BudgetedCost

  • CampaignImageId

  • CampaignMemberRecordTypeId

  • CurrencyIsoCode

  • Description

  • EndDate

  • ExpectedResponse

  • ExpectedRevenue

  • HierarchyActualCost

  • HierarchyBudgetedCost

  • HierarchyExpectedRevenue

  • HierarchyNumberSent

  • IsActive

  • LastActivityDate

  • LastReferencedDate

  • LastViewedDate

  • Name

  • NumberOfContacts

  • NumberOfConvertedLeads

  • NumberOfLeads

  • NumberOfOpportunities

  • NumberOfResponses

  • NumberOfWonOpportunities

  • NumberSent

  • OwnerId

  • ParentCampaign

  • ParentId

  • RecordTypeId

  • StartDate

  • Status

  • TenantId

  • TotalAmountAllOpportunities

  • TotalAmountAllWonOpportunities

  • TotalNumberOfContacts

  • TotalNumberofConvertedLeads

  • TotalNumberOfLeads

  • TotalNumberofOpportunities

  • TotalNumberofResponses

  • TotalNumberofWonOpportunities

  • Type

CampaignMember
  • attributes_type

  • attributes_url

  • id

  • isdeleted

  • CampaignId

  • City

  • CompanyOrAccount

  • ContactId

  • CurrencyIsoCode

  • Country

  • Description

  • DoNotCall

  • Email

  • Fax

  • FirstName

  • FirstRespondedDate

  • HasOptedOutOfEmail

  • HasOptedOutOfFax

  • HasResponded

  • LastName

  • LeadId

  • LeadOrContactId

  • LeadOrContactOwnerId

  • LeadSource

  • MobilePhone

  • Name

  • Phone

  • PostalCode

  • RecordTypeId

  • Salutation

  • State

  • Status

  • Street

  • Title

  • Type

CampaignMemberStatus
  • attributes_type

  • attributes_url

  • id

  • isdeleted

  • CampaignId

  • HasResponded

  • IsDefault

  • IsDeleted

  • Label

  • SortOrder

CampaignShare
  • CampaignId

  • CampaignAccessLevel

  • RowCause

  • UserOrGroupId

CardPaymentMethod
  • AccountId

  • AuditEmail

  • AutoCardType

  • CardBin

  • CardCategory

  • CardHolderFirstName

  • CardHolderLastName

  • CardHolderName

  • CardLastFour

  • CardType

  • CardTypeCategory

  • Comments

  • CompanyName

  • DisplayCardNumber

  • Email

  • ExpiryMonth

  • ExpiryYear

  • GatewayDate

  • GatewayResultCode

  • GatewayResultCodeDescription

  • GatewayToken

  • GatewayTokenDetails

  • GatewayTokenEncrypted

  • InputCardNumber

  • IpAddress

  • LastReferencedDate

  • LastViewedDate

  • MacAddress

  • Nickname

  • PaymentGatewayId

  • PaymentMethodAddress

  • PaymentMethodCity

  • PaymentMethodCountry

  • PaymentMethodGeocodeAccuracy

  • PaymentMethodLatitude

  • PaymentMethodLongitude

  • PaymentMethodPostalCode

  • PaymentMethodState

  • PaymentMethodStreet

  • Phone

  • ProcessingMode

  • SfResultCode

  • StartMonth

  • StartYear

  • Status

Case
  • attributes_type

  • attributes_url

  • id

  • isdeleted

  • casenumber

  • contactid

  • accountid

  • type

  • status

  • reason

  • origin

  • subject

  • priority

  • isclosed

  • closeddate

  • isescalated

  • ownerid

  • createddate

  • createdbyid

  • lastmodifieddate

  • lastmodifiedbyid

  • systemmodstamp

  • contactphone

  • contactmobile

  • contactemail

  • contactfax

  • engineeringreqnumber_c

  • slaviolation_c

  • product_c

  • potenialliability_c

CaseComment
  • CommentBody

  • ConnectionReceivedId

  • ConnectionSentId

  • CreatorFullPhotoUrl

  • CreatorName

  • CreatorSmallPhotoUrl

  • IsDeleted

  • IsNotificationSelected

  • IsPublished

  • ParentId

CaseContactRole
  • CasesId

  • ContactId

  • IsDeleted

  • Role

CaseHistory
  • CaseId

  • DataType

  • Field

  • IsDeleted

  • NewValue

  • OldValue

CaseShare
  • CaseAccessLevel

  • CaseId

  • IsDeleted

  • RowCause

  • UserOrGroupId

CaseSolution
  • CaseId

  • IsDeleted

  • SolutionId

CaseStatus
  • attributes_type

  • attributes_url

  • id

  • masterlabel

  • apiname

  • sortorder

  • isdefault

  • isclosed

  • createdbyid

  • createddate

  • lastmodifiedbyid

  • lastmodifieddate

  • systemmodstamp

CaseTeamMember
  • MemberId

  • ParentId

  • TeamRoleId

  • TeamTemplateId

  • TeamTemplateMemberId

CaseTeamRole
  • AccessLevel

  • Name

  • PreferencesVisibleInCSP

CaseTeamTemplate
  • Description

  • Name

CaseTeamTemplateMember
  • MemberId

  • TeamRoleId

  • TeamTemplateId

CaseTeamTemplateRecord
  • ParentId

  • TeamTemplateId

CategoryData
  • CategoryNodeId

  • IsDeleted

  • RelatedSobjectId

CategoryNode
  • MasterLabel

  • ParentId

  • SortOrder

  • SortStyle

ChatterActivity
  • CommentCount

  • CommentReceivedCount

  • InfluenceRawRank

  • LikeReceivedCount

  • NetworkId

  • ParentId

  • PostCount

ChatterExtension
  • CompositionComponentEnumOrId

  • Description

  • DeveloperName

  • ExtensionName

  • HeaderText

  • HoverText

  • IconId

  • IsProtected

  • Language

  • MasterLabel

  • NameSpacePrefix

  • RenderComponentEnumOrId

  • Type

ChatterExtensionConfig
  • CanCreate

  • CanRead

  • ChatterExtensionId

  • NetworkId

  • Position

ClientBrowser
  • attributes_type

  • attributes_url

  • id

  • usersid

  • fulluseragent

  • lastupdate

  • createddate

CollaborationGroup
  • AnnouncementId

  • BannerPhotoUrl

  • CanHaveGuests

  • CollaborationType

  • FullPhotoUrl

  • GroupEmail

  • HasPrivateFieldsAccess

  • InformationBody

  • InformationTitle

  • IsArchived

  • IsAutoArchiveDisabled

  • IsBroadcast

  • LastFeedModifiedDate

  • LastReferencedDate

  • LastViewedDate

  • MediumPhotoUrl

  • MemberCount

  • Name

  • NetworkId

  • OwnerId

  • SmallPhotoUrl

CollaborationGroupMember
  • CollaborationGroupId

  • CollaborationRole

  • LastFeedAccessDate

  • MemberId

  • NotificationFrequency

CollaborationGroupMemberRequest
  • CollaborationGroupId

  • RequesterId

  • ResponseMessage

  • Status

CollaborationGroupRecord
  • CollaborationGroupId

  • NetworkId

  • RecordId

CollaborationInvitation
  • InvitedUserEmail

  • InvitedUserEmailNormalized

  • InviterId

  • OptionalMessage

  • ParentId

  • SharedEntityId

  • Status

CommSubscription
  • DataUsePurposeId

  • IsDefault

  • LastReferencedDate

  • LastViewedDate

  • Name

  • OwnerId

CommSubscriptionChannelType
  • CommunicationSubscriptionId

  • EngagementChannelTypeId

  • LastReferencedDate

  • LastViewedDate

  • Name

  • OwnerId

CommSubscriptionConsent
  • BusinessBrandId

  • CommSubscriptionChannelTypeId

  • ConsentCapturedDateTime

  • ConsentCapturedSource

  • ConsentGiverId

  • ContactPointId

  • EffectiveFromDate

  • EffectiveToDate

  • LastReferencedDate

  • LastViewedDate

  • Name

  • OwnerId

  • PartyRoleId

CommSubscriptionTiming
  • CommSubscriptionConsentId

  • LastReferencedDate

  • LastViewedDate

  • Namset

  • Offset

  • PreferredTimeEnd

  • PreferredTimeStart

  • PreferredTimeZone

  • Unit

Community
  • attributes_type

  • attributes_url

  • id

  • systemmodstamp

  • createddate

  • createdbyid

  • lastmodifieddate

  • lastmodifiedbyid

  • name

  • isactive

  • ispublished

ConnectedApplication
  • attributes_type

  • attribures_url

  • createddate

  • createdbyid

  • lastmodifieddate

  • lastmodifiedbyid

  • systemmodstamp

  • id

  • Name

  • OptionsAllowAdminApprovedUsersOnly

  • OptionsFullContentPushNotifications

  • OptionsHasSessionLevelPolicy

  • OptionsIsInternal

  • OptionsRefreshTokenValidityMetric

ConsumptionRate
  • ConsumptionScheduleId

  • CurrencyIsoCode

  • Description

  • LowerBound

  • Name

  • Price

  • PricingMethod

  • ProcessingOrder

  • UpperBound

Consumption Schedule
  • BillingTerm

  • BillingTermUnit

  • CurrencyIsoCode

  • Description

  • IsActive

  • LastReferencedDate

  • LastViewedDate

  • MatchingAttribute

  • Name

  • NumberOfRates

  • OwnerId

  • RatingMethod

  • SBQQ__Category__c

  • Type

  • UnitOfMeasure

  • blng__BillingRule__c

  • blng__RevenueRecognitionRule__c

  • blng__TaxRule__c

Contact
  • attributes_type

  • attributes_url

  • id

  • isdeleted

  • accountid

  • lastname

  • firstname

  • salutation

  • name

  • mailingstreet

  • mailingaddress_street

  • phone

  • fax

  • mobilephone

  • email

  • title

  • department

  • leadsource

  • birthdate

  • ownerid

  • createddate

  • createdbyid

  • lastmodifieddate

  • lastmodifiedbyid

  • systemmodstamp

  • isemailbounced

  • photourl

  • cleanstatus

  • level_c

  • languages_c

  • assistantphone

  • assistantname

  • otherstreet

  • othercity

  • otherstate

  • otherpostalcode

  • othercountry

  • otheraddress_city

  • otheraddress_country

  • otheraddress_postalcode

  • otheraddress_state

  • otheraddress_street

  • mailingcity

  • mailingstate

  • mailingpostalcode

  • mailingcountry

  • mailingaddress_city

  • mailingaddress_country

  • mailingaddress_postalcode

  • mailingaddress_state

  • lastactivitydate

  • otherphone

ContactCleanInfo
  • Address

  • City

  • CleanedByJob

  • CleanedByUser

  • ContactId

  • ContactStatusDataDotCom

  • Country

  • DataDotComID

  • Email

  • FirstName

  • IsDifferentCity

  • IsDifferentCountry

  • IsDifferentCountryCode

  • IsDifferentEmail

  • IsDifferentFirstName

  • IsDifferentLastName

  • IsDifferentPhone

  • IsDifferentPostalCode

  • IsDifferentState

  • IsDifferentStateCode

  • IsDifferentStreet

  • IsDifferentTitle

  • IsFlaggedWrongAddress

  • IsFlaggedWrongEmail

  • IsFlaggedWrongName

  • IsFlaggedWrongPhone

  • IsFlaggedWrongTitle

  • IsInactive

  • IsReviewedAddress

  • IsReviewedEmail

  • IsReviewedName

  • IsReviewedPhone

  • IsReviewedTitle

  • LastMatchedDate

  • LastName

  • LastStatusChangedById

  • LastStatusChangedDate

  • Latitude

  • Longitude

  • Name

  • Phone

  • PostalCode

  • State

  • Street

  • Title

ContactPointAddress
  • ActiveFromDate

  • ActiveToDate

  • Address

  • AddressType

  • BestTimeToContactEndTime

  • BestTimeToContactStartTime

  • BestTimeToContactTimezone

  • City

  • ContactPointPhoneId

  • Country

  • GeocodeAccuracy

  • IsDefault

  • IsPrimary

  • LastReferencedDate

  • LastViewedDate

  • Latitude

  • Longitude

  • Name

  • OwnerId

  • ParentId

  • PostalCode

  • State

  • Street

  • UsageType

ContactPointConsent
  • BusinessBrandId

  • CaptureContactPointType

  • CaptureDate

  • CaptureSource

  • ContactPointId

  • DataUsePurposeId

  • DoubleConsentCaptureDate

  • EffectiveFrom

  • EffectiveTo

  • EngagementChannelTypeId

  • LastReferencedDate

  • LastViewedDate

  • Name

  • OwnerId

  • PartyRoleId

  • PrivacyConsentStatus

ContactPointEmail
  • ActiveFromDate

  • ActiveToDate

  • BestTimeToContactEndTime

  • BestTimeToContactStartTime

  • BestTimeToContactTimezone

  • EmailAddress

  • EmailDomain

  • EmailLatestBounceDateTime

  • EmailLatestBounceReasonText

  • EmailMailBox

  • IsPrimary

  • LastReferencedDate

  • LastViewedDate

  • Name

  • OwnerId

  • ParentId

  • UsageId

ContactPointPhone
  • ActiveFromDate

  • ActiveToDate

  • AreaCode

  • BestTimeToContactEndTime

  • BestTimeToContactStartTime

  • BestTimeToContactTimezone

  • ExtensionNumber

  • FormattedInternationalPhoneNumber

  • FormattedNationalPhoneNumber

  • IsBusinessPhone

  • IsFaxCapable

  • IsPersonalPhone

  • IsPrimary

  • IsSmsCapable

  • LastReferencedDate

  • LastViewedDate

  • Name

  • OwnerId

  • ParentId

  • PhoneType

  • PreferenceRank

  • TelephoneNumber

  • UsageType

ContactPointTypeConsent
  • BusinessBrandId

  • CaptureContactPointType

  • CaptureDate

  • CaptureSource

  • ContactPointType

  • DataUsePurposeId

  • DoubleConsentCaptureDate

  • EffectiveFrom

  • EffectiveTo

  • EngagementChannelType

  • LastReferencedDate

  • Name

  • OwnerId

  • PartyId

  • PartyRoleId

  • PrivacyConsentStatus

ContactRequest
  • LastReferencedDate

  • LastViewedDate

  • Name

  • OwnerId

  • PreferredChannel

  • PreferredPhone

  • RequestDescription

  • RequestReason

  • Status

  • WhatId

  • WhoId

ContactRequestShare
  • AccessLevel

  • ParentId

  • RowCause

  • UserOrGroupId

ContactShare
  • ContactId

  • ContactAccessLevel

  • IsDeleted

  • RowCause

  • UserOrGroupId

ContentAsset
  • ContentDocumentId

  • DeveloperName

  • IsVisibleByExternalUsers

  • Language

  • MasterLabel

  • NamespacePrefix

ContentDistribution
  • ContentDocumentId

  • ContentDownloadUrl

  • ContentVersionId

  • DistributionPublicUrl

  • ExpiryDate

  • FirstViewDate

  • LastViewDate

  • Name

  • OwnerId

  • PdfDownloadUrl

  • Password

  • PreferencesAllowOriginalDownload

  • PreferencesAllowPDFDownload

  • PreferencesAllowViewInBrowser

  • PreferencesExpires

  • PreferencesLinkLatestVersion

  • PreferencesNotifyOnVisit

  • PreferencesNotifyRndtnComplete

  • PreferencesPasswordRequired

  • RelatedRecordId

  • ViewCount

ContentDistributionView
  • DistributionId

  • IsDownload

  • IsInternal

  • ParentViewId

ContentDocument
  • ArchivedById

  • ArchivedDate

  • ContentAssetId

  • ContentModifiedDate

  • ContentSize

  • Description

  • Division

  • FileExtension

  • FileType

  • IsArchived

  • LastReferencedDate

  • LastViewedDate

  • LatestPublishedVersionId

  • OwnerId

  • ParentId

  • PublishStatus

  • SharingOption

  • SharingPrivacy

  • Title

ContentDocumentHistory
  • ContentDocumentId

  • DataType

  • Division

  • Field

  • NewValue

  • OldValue

ContentDocumentSubscription
  • ContentDocumentId

  • IsCommentSub

  • IsDocumentSub

  • UserId

ContentFolder
  • Name

  • ParentContentFolderId

ContentNotification
  • EntityIdentifierId

  • EntityType

  • Nature

  • Subject

  • Text

  • UsersId

ContentTagSubscription

ContentTagSubscription
  • UserId

ContentUserSubscription
  • SubscribedToUserId

  • SubscriberUserId

ContentVersion
  • CheckSum

  • ContentBodyId

  • ContentDocumentId

  • ContentLocation

  • ContentModifiedById

  • ContentModifiedDate

  • ContentSize

  • ContentUrl

  • Description

  • Division

  • ExternalDataSourceId

  • ExternalDocumentInfo1

  • ExternalDocumentInfo2

  • FeaturedContentBoost

  • FeaturedContentDate

  • FileExtension

  • FileType

  • FirstPublishLocationId

  • IsAssetEnabled

  • IsEncrypted

  • IsLatest

  • IsMajorVersion

  • Language

  • NegativeRatingCount

  • NetworkId

  • Origin

  • OwnerId

  • PathOnClient

  • PositiveRatingCount

  • PublishStatus

  • RatingCount

  • ReasonForChange

  • RecordTypeId

  • SharingOption

  • SharingPrivacy

  • TagCsv

  • TextPreview

  • Title

  • VersionData

  • VersionNumber

ContentVersionComment
  • ContentDocumentId

  • ContentVersionId

  • UserComment

ContentVersionHistory
  • ContentVersionId

  • DataType

  • Division

  • Field

  • NewValue

  • OldValue

ContentVersionRating
  • ContentVersionId

  • Rating

  • UserComment

  • UserId

ContentWorkspace
  • DefaultRecordTypeId

  • Description

  • DeveloperName

  • IsRestrictContentTypes

  • IsRestrictLinkedContentTypes

  • Name

  • NamespacePrefix

  • RootContentFolderId

  • ShouldAddCreatorMembership

  • TagModel

  • WorkspaceImageId

  • WorkspaceType

ContentWorkspaceDoc
  • ContentDocumentId

  • ContentWorkspaceId

  • IsOwner

ContentWorkspaceMember
  • ContentWorkspaceId

  • ContentWorkspacePermissionId

  • MemberId

  • MemberType

ContentWorkspacePermission
  • attributes_type

  • attributes_url

  • id

  • name

  • type

  • permissionsmanageworkshop

  • permissionsaddcontent

  • permissionsaddcontentobo

  • permissionsarchivecontent

  • permissionsdeletecontent

  • permissionsfeaturecontent

  • permissionsviewcomments

  • permissionsaddcomment

  • permissionsmodifycomments

  • permissionstagcontent

  • permissionsdelivercontent

  • permissionschattersharing

  • permissionsorganisefileandfolder

  • createbyid

  • createddate

  • lastmodifieddate

  • systemmodstamp

  • lastmodifiedbyid

ContentWorkspaceSubscription
  • ContentWorkspaceId

  • UserId

Contract
  • AccountId

  • ActivatedById

  • ActivatedDate

  • BillingAddress

  • BillingCity

  • BillingCountry

  • BillingCountryCode

  • BillingGeocodeAccuracy

  • BillingLatitude

  • BillingLongitude

  • BillingPostalCode

  • BillingState

  • BillingStateCode

  • BillingStreet

  • CompanySignedDate

  • CompanySignedId

  • ContractNumber

  • ContractTerm

  • CustomerSignedDate

  • CustomerSignedId

  • CustomerSignedTitle

  • Description

  • EndDate

  • IsDeleted

  • LastActivityDate

  • LastApprovedDate

  • LastReferencedDate

  • LastViewedDate

  • OwnerExpirationNotice

  • OwnerId

  • Pricebook2Id

  • RecordTypeId

  • ShippingAddress

  • ShippingCity

  • ShippingCountry

  • ShippingCountryCode

  • ShippingLatitude

  • ShippingLongitude

  • ShippingPostalCode

  • ShippingState

  • ShippingStateCode

  • ShippingStreet

  • SpecialTerms

  • StartDate

  • Status

  • StatusCode

ContractContactRole
  • ContactId

  • ContractId

  • IsDeleted

  • IsPrimary

  • Role

ContractStatus
  • attributes_type

  • attributes_url

  • id

  • masterlabel

  • apiname

  • sortorder

  • isdefault

  • statuscode

  • createdbyid

  • createddate

  • lastmodifiedbyid

  • lastmodifieddate

  • systemmodstamp

ConversationEntry
  • ActorId

  • ActorName

  • ActorType

  • ClientDuration

  • ClientTimestamp

  • ConversationId

  • EntryEndTime

  • EntryTime

  • EntryTimeMilliSecs

  • EntryType

  • HasAttachments

  • Message

  • MessageDeliveryTime

  • MessageIdentifier

  • MessageReadTime

  • MessageSendTime

  • MessageStatus

  • MessageStatusCode

  • Seq

  • ServerReceivedTimestamp

CorsWhitelistEntry
  • attributes_type

  • attributes_url

  • id

  • isdeleted

  • developername

  • language

  • masterlabel

  • createddate

  • createdbyid

  • lastmodifieddate

  • lastmodifedbyid

  • systemmodstamp

  • urlpattern

CreditMemo
  • AppType

  • Balance

  • BillToContactId

  • BillingAccountId

  • CreationMode

  • CreditDate

  • CreditMemoNumber

  • CurrencyIsoCode

  • Description

  • DocumentNumber

  • EffectiveDate

  • ExternalReference

  • ExternalReferenceDataSource

  • LastReferencedDate

  • LastViewedDate

  • NetCreditsApplied

  • OwnerId

  • ReferenceEntityId

  • SourceAction

  • Status

  • TotalAdjustmentAmount

  • TotalAdjustmentAmountWithTax

  • TotalAdjustmentTaxAmount

  • TotalAmount

  • TotalAmountWithTax

  • TotalChargeAmount

  • TotalChargeAmountWithTax

  • TotalChargeTaxAmount

  • TotalCreditAmountApplied

  • TotalCreditAmountUnapplied

  • TotalTaxAmount

CreditMemoLine
  • AdjustmentAmount

  • AdjustmentAmountWithTax

  • AdjustmentTaxAmount

  • BillingAddressId

  • ChargeAmount

  • ChargeAmountWithTax

  • ChargeTaxAmount

  • CreditMemoId

  • CurrencyIsoCode

  • Description

  • EndDate

  • LineAmount

  • Name

  • Product2Id

  • ReferenceEntityItemId

  • ReferenceEntityItemType

  • ReferenceEntityItemTypeCode

  • RelatedLineId

  • ShippingAddressId

  • StartDate

  • Status

  • TaxAmount

  • TaxCode

  • TaxDocumentNumber

  • TaxEffectiveDate

  • TaxName

  • TaxRate

  • TotalAmount