Gravity
  • What is Gravity?
    • Jobs
      • Create Jobs
      • Update Jobs
  • Orchestration
    • Job Modes
    • Metadata
    • Logs
    • Allowing Gravity access to data behind a firewall
    • Core Concepts
  • Sources
    • Files Sources
      • Flattened Documents Model
      • Documents Model
      • SFTP
      • S3
    • Amazon Aurora MySQL
    • Adobe
    • Airtable
      • Setup Guide
      • Tables
        • SampleTable
        • SampleTable_Attachments
        • SampleTable_Collaborators
    • Amazon Aurora PostgreSQL
    • Amazon DynamoDB
    • Amazon RDS for MySQL
    • Amazon RDS for PostgresSQL
    • Amazon RDS for SQL Server
    • Amazon S3
      • Tables
        • Buckets
        • BucketsACL
        • BucketsAnalytics
        • BucketsCORS
        • BucketsInventory
        • BucketsLifecycle
        • BucketsReplication
        • Objects
        • ObjectsACL
        • PublicAccessBlock
    • AOL
    • Apache Kafka
    • AWIN
      • Setup Guide
    • Azure Database for MySQL
    • Azure Database for PostgreSQL
    • Amazon DocumentDB
      • Setup Guide
    • Azure for SQL
    • Azure Synapse
    • Big Commerce
      • Tables
        • Categories
        • Currencies
        • Customers
        • OrderItems
        • Orders
        • OrderShipments
        • PriceListRecords
        • PriceLists
        • ProductImages
        • ProductOptions
        • ProductOptionValues
        • ProductReviews
        • Products
        • ProductVariants
        • BlogTags
        • Brands
        • Coupons
        • CustomerAddresses
        • CustomerGroups
        • GiftCertificates
        • OrderCoupons
        • OrderMessages
        • OrderShippingAddresses
        • OrderStatuses
        • OrderTaxes
        • Pages
        • PaymentMethods
        • PriceListAssignments
        • ProductBulkPricingRules
        • ProductCustomFields
        • ProductRules
        • ProductSkus
        • ProductVariantValues
        • ProductVideos
        • Redirects
        • ShipmentItems
        • ShippingMethods
        • ShippingZones
        • Stores
        • TaxClasses
        • Blogposts
        • OrderItemOptionValues
    • BigQuery
      • Tables
        • Datasets
        • PartitionsList
        • PartitionsValues
        • Projects
    • Bing Ads
      • Tables
        • AccountPerformanceReport
        • Accounts
        • AdDynamicTextPerformanceReport
        • AdExtensionByAdReport
        • AdExtensionByKeywordReport
        • AdExtensionDetailReport
        • AdGroupPerformanceReport
        • AdGroups
        • AdPerformanceReport
        • Ads
        • AgeGenderAudienceReport
        • AudiencePerformanceReport
        • Audiences
        • BidOpportunities
        • BudgetOpportunities
        • Budgets
        • BudgetSummaryReport
        • CampaignPerformanceReport
        • Campaigns
        • ConversionPerformanceReport
        • DestinationUrlPerformanceReport
        • DSAAutoTargetPerformanceReport
        • DSACategoryPerformanceReport
        • DSASearchQueryPerformanceReport
        • GeographicPerformanceReport
        • GoalsAndFunnelsReport
        • KeywordDemographics
        • KeywordEstimatedBid
        • KeywordEstimatedPosition
        • KeywordHistoricalSearch
        • KeywordLocations
        • KeywordPerformance
        • KeywordPerformanceReport
        • Keywords
        • NegativeKeywordConflictReport
        • ProductDimensionPerformanceReport
        • ProductNegativeKeywordConflictReport
        • ProductPartitionPerformanceReport
        • ProductPartitionUnitPerformanceReport
        • ProductSearchQueryPerformanceReport
        • PublisherUsagePerformanceReport
        • SearchCampaignChangeHistoryReport
        • SearchQueryPerformanceReport
        • ShareOfVoiceReport
        • Tags
        • UserLocationPerformanceReport
    • Branch
      • Setup Guide
    • Bugsnag
    • Campaign Monitor
    • ClickUp
      • Setup Guide
    • Cloud SQL for MySQL
    • Cloud SQL for PostgreSQL
    • Cloud SQL for SQL Server
    • Convert Kit
    • CSV
    • Derby
    • Doordash
    • Elastic Search
    • Eventbrite
      • Setup Guide
      • Tables
        • AttendeeReport
        • Attendees
        • AttendeeTeams
        • Categories
        • CustomQuestions
        • DefaultQuestions
        • Discounts
        • DisplaySettings
        • Events
        • Formats
        • Orders
        • Organizations
        • Pricing
        • SalesReport
        • Subcategories
        • TicketClasses
        • TicketGroups
        • User
        • Venues
    • Exasol
    • Facebook Ads
      • Setup Guide
    • Facebook Page and Post Insights
    • Firebird
    • FreshDesk
      • Setup Guide
      • Tables
        • Agents
        • BusinessHours
        • CannedResponses
        • CannedResponsesFolder
        • Companies
        • Contacts
        • Conversations
        • Groups
        • Mailboxes
        • Products
        • Roles
        • SLAPolicies
        • TicketFields
        • Tickets
        • TimeEntries
    • FullStory
    • Github
    • Gmail
      • Gmail REST Data Model
        • Tables
          • Labels
          • Messages
          • SENT
          • Attachments
          • Filters
          • History
          • INBOX
          • Threads
          • Users
      • Gmail IMAP Data Model
        • Tables
          • MailMessages
    • Google Ads
      • AdWords Views
        • AccountPerformance
        • AdCustomizersFeedItem
        • AdGroupBidLandscape
        • AdgroupPerformance
        • AdGroups
        • AdPerformance
        • AgeRangePerformance
        • AudiencePerformance
        • AutomaticPlacementsPerformance
        • BidGoalPerformance
        • BudgetPerformance
        • CallMetricsCallDetails
        • CampaignAdScheduleTarget
        • CampaignCriteria
        • CampaignCriterionBidLandscape
        • CampaignGroupPerformance
        • CampaignLocationTarget
        • CampaignNegativeKeywordsPerformance
        • CampaignNegativeLocations
        • CampaignNegativePlacementsPerformance
        • CampaignPerformance
        • Campaigns
        • CampaignSharedSet
        • ClickPerformance
        • ConversionTrackers
        • CreativeConversion
        • CriteriaPerformance
        • CriterionBidLandscape
        • Customers
        • DisplayKeywordPerformance
        • DisplayTopicsPerformance
        • FinalUrl
        • GenderPerformance
        • GeoPerformance
        • KeywordlessCategory
        • KeywordlessQuery
        • KeywordsPerformance
        • Label
        • LandingPage
        • LocationCriterion
        • ManagedCustomers
        • ManagedCustomersLinks
        • MarketplacePerformance
        • PaidOrganicQuery
        • ParentalStatusPerformance
        • Placeholder
        • PlaceholderFeedItem
        • PlacementPerformance
        • ProductPartition
        • SearchQueryPerformance
        • SharedSet
        • SharedSetCriteria
        • ShoppingPerformance
        • TopContentPerformance
        • UrlPerformance
        • UserAdDistance
        • VideoPerformance
      • Google Ads Views
        • AccessibleBiddingStrategy
        • AccountBudget
        • AccountBudgetProposal
        • AccountLink
        • AdGroup
        • AdGroupAd
        • AdGroupAdAssetView
        • AdGroupAdLabel
        • AdGroupAsset
        • AdGroupAudienceView
        • AdGroupBidModifier
        • AdGroupCriterion
        • AdGroupCriterionLabel
        • AdGroupCriterionSimulation
        • AdGroupExtensionSetting
        • AdGroupFeed
        • AdGroupLabel
        • AdGroupSimulation
        • AdParameter
        • AdScheduleView
        • AgeRangeView
        • Asset
        • AssetFieldTypeView
        • BatchJob
        • BiddingDataExclusion
        • BiddingSeasonalityAdjustment
        • BiddingStrategy
        • BiddingStrategySimulation
        • BillingSetup
        • CallView
        • Campaign
        • CampaignAsset
        • CampaignAudienceView
        • CampaignBidModifier
        • CampaignBudget
        • CampaignCriterion
        • CampaignCriterionSimulation
        • CampaignDraft
        • CampaignExperiment
        • CampaignExtensionSetting
        • CampaignFeed
        • CampaignLabel
        • CampaignSharedSet
        • CampaignSimulation
        • CarrierConstant
        • ChangeEvent
        • ChangeStatus
        • ClickView
        • CombinedAudience
        • ConversionAction
        • ConversionCustomVariable
        • ConversionValueRule
        • ConversionValueRuleSet
        • CurrencyConstant
        • CustomAudience
        • Customer
        • CustomerAsset
        • CustomerClient
        • CustomerClientLink
        • CustomerExtensionSetting
        • CustomerFeed
        • CustomerLabel
        • CustomerManagerLink
        • CustomerNegativeCriterion
        • CustomerUserAccess
        • CustomerUserAccessInvitation
        • CustomInterest
        • DetailedDemographic
        • DetailPlacementView
        • DisplayKeywordView
        • DistanceView
        • DomainCategory
        • DynamicSearchAdsSearchTermView
        • ExpandedLandingPageView
        • ExtensionFeedItem
        • Feed
        • FeedItem
        • FeedItemSet
        • FeedItemSetLink
        • FeedItemTarget
        • FeedMapping
        • FeedPlaceholderView
        • GenderView
        • GeographicView
        • GeoTargetConstant
        • GroupPlacementView
        • HotelGroupView
        • HotelPerformanceView
        • IncomeRangeView
        • KeywordPlan
        • KeywordPlanAdGroup
        • KeywordPlanAdGroupKeyword
        • KeywordPlanCampaign
        • KeywordPlanCampaignKeyword
        • KeywordThemeConstant
        • KeywordView
        • Label
        • LandingPageView
        • LanguageConstant
        • LifeEvent
        • LocationView
        • ManagedPlacementView
        • MediaFile
        • MobileAppCategoryConstant
        • MobileDeviceConstant
        • OfflineUserDataJob
        • OperatingSystemVersionConstant
        • PaidOrganicSearchTermView
        • ParentalStatusView
        • ProductBiddingCategoryConstant
        • ProductGroupView
        • Recommendation
        • RemarketingAction
        • Resources
        • SearchTermView
        • SharedCriterion
        • SharedSet
        • ShoppingPerformanceView
        • SmartCampaignSearchTermView
        • SmartCampaignSetting
        • ThirdPartyAppAnalyticsLink
        • TopicConstant
        • TopicView
        • UserInterest
        • UserList
        • UserLocationView
        • Video
        • WebpageView
    • Google Ad Manager
    • Google Analytics
      • UniversalAnalytics Data Model
        • Tables
          • Accounts
          • Goals
          • Profiles
          • Segments
          • UserActivity
          • WebProperties
          • AdSense
          • AdWords
          • Ecommerce
          • Events
          • Global_Access_Object
          • GoalCompletions
          • SiteContent
          • SiteSearch
          • SiteSpeed
          • Traffic
      • GoogleAnalytics4 Data Model
        • Tables
          • Accounts
          • Properties
          • PropertiesAndroidAppDataStreams
          • PropertiesFireBaseLinks
          • PropertiesGoogleAdsLinks
          • PropertiesIosAppDataStreams
          • PropertiesWebDataStreams
          • AccountSummaries
          • Acquisitions
          • ActiveUsers
          • Demographics
          • Engagement
          • Events
          • GamesReporting
          • MetaData
          • Monetization
          • Tech
    • Google Analytics 360
    • Google Analytics 4 (Beta)
    • Google BigQuery
    • Google Campaign Manager
      • Tables
        • CrossDimensionReachReport
        • Files
        • FloodlightReport
        • PathToConversionReport
        • ReachReport
        • Reports
        • StandardReport
        • UserProfiles
    • Google Cloud for MySQL
    • Google Cloud for PostgreSQL
    • Google Cloud for SQL Server
    • Google Cloud Storage
    • Google Display & Video 360
    • Google DoubleClick Bid Manager
    • Google DoubleClick Campaign Manager
    • Google Search Ads 360
    • Google Seach Console
    • Google Sheets
      • Setup Guide
    • HubSpot
      • Setup Guide
    • ICloud
    • Instagram
    • Intercom
      • Setup Guide
    • JIRA
      • Setup Guide
      • Tables
        • Attachments
        • Boards
        • Comments
        • Issues
        • IssueTypes
        • ProjectComponents
        • Projects
        • ProjectVersions
        • Roles
        • Sprints
        • Users
        • Worklogs
        • AdvancedSettings
        • ApplicationRoles
        • Audit
        • BoardConfiguration
        • BoardIssues
        • BoardSprints
        • Configuration
        • Dashboards
        • Epics
        • FavouriteFilters
        • Fields
        • Filters
        • Groups
        • IssueAffectedVersions
        • IssueChangelogs
        • IssueComponents
        • IssueCustomFieldOptions
        • IssueCustomFields
        • IssueFixVersions
        • IssueLinks
        • IssueLinkTypes
        • IssueNavigatorDefaultColumns
        • IssuePriorities
        • IssueResolutions
        • IssueSubtasks
        • IssueTransitions
        • MyPermissions
        • Permissions
        • ProjectCategories
        • ProjectRoles
        • ProjectsIssueTypes
        • ProjectTypes
        • RoleDetails
        • SecurityLevels
        • SecuritySchemes
        • SprintIssues
        • Statuses
        • TimeTrackingProviders
        • Votes
        • Watchers
        • Workflows
        • WorkflowStatusCategories
        • WorkflowStatuses
    • Klaviyo
      • Setup Guide
    • LinkedIn Ads
    • Linkedin Social
      • Tables
        • CompanyStatusUpdates
        • Comments
        • CompanyDetails
        • CompanyFollowerStatistics
        • CompanyList
        • CompanyLocations
        • CompanyPageStatistics
        • CompanyUpdateStatistics
        • Positions
        • Profile
    • Magento
      • Tables
        • BundleProductLinkChildren
        • BundleProductOption
        • CatalogAttributeSet
        • CatalogCategoryAttribute
        • CatalogCategoryAttributeOptionOptions
        • CatalogCategoryLinkProducts
        • CatalogProductAttribute
        • CatalogProductAttributeTypesList
        • CatalogProductLinkTypeList
        • CatalogProductTierPriceTiers
        • CatalogProductTypeList
        • CheckoutAgreementsCheckoutAgreements
        • CmsBlock
        • CmsPage
        • ConfigurableProductLinkChildren
        • ConfigurableProductOption
        • CustomerAccountBillingAddress
        • CustomerAccountShippingAddress
        • CustomerAddress
        • CustomerGroup
        • CustomerGroupDefault
        • Customers
        • DirectoryCountryInformationAcquirer
        • DirectoryCurrencyInformationAcquirer
        • DownloadableLink
        • DownloadableSample
        • EavAttributeSet
        • GiftMessageCart
        • GiftMessageGuestCart
        • GiftMessageGuestItem
        • GiftMessageItem
        • GuestBillingAddresses
        • GuestPaymentInformation
        • GuestPaymentMethods
        • GuestShippingMethods
        • Inventory
        • OrderComments
        • BillingAddresses
        • OrderItems
        • PaymentMethods
        • PaymentSelectedMethods
        • ProductAttributeGroup
        • ProductAttributeOptions
        • ProductAttributes
        • ProductCategories
        • ProductCustomOption
        • ProductMedia
        • Products
        • QuoteCart
        • QuoteCartItem
        • QuoteCartTotal
        • QuoteGuestCart
        • QuoteGuestCartItem
        • QuoteGuestCartTotal
        • SalesCreditmemo
        • SalesCreditmemoComments
        • SalesInvoice
        • SalesInvoiceComments
        • SalesRule
        • SalesRuleCoupon
        • SalesShipment
        • SalesShipmentComments
        • SalesTransaction
        • ShippingMethods
        • StoreGroup
        • Stores
        • StoreWebsite
        • TaxClass
        • TaxRate
        • TaxRule
    • MailChimp
      • Setup Guide
      • Tables
        • AuthorizedApps
        • AutomationEmailQueues
        • AutomationsRemovedSubscribers
        • CampaignFeedback
        • CampaignFolders
        • Campaigns
        • ConversationMessages
        • EcommerceCartLines
        • EcommerceCarts
        • EcommerceCustomers
        • EcommerceOrderLines
        • EcommerceOrders
        • EcommerceProducts
        • EcommerceProductVariants
        • EcommerceStores
        • FileManagerFiles
        • FileManagerFolders
        • ListInterestCategories
        • ListInterests
        • ListMemberEvents
        • ListMemberNotes
        • ListMembers
        • ListMemberTags
        • ListMergeFields
        • ListMemberTags
        • Page 4
        • ListMergeFields
        • ListSegmentMembers
        • Lists
        • ListSegments
        • ListSegmentMembers
        • ListSegments
        • ListsTwitterLeadGenCards
        • ListsWebhooks
        • TemplateFolders
        • Templates
        • AutomationEmails
        • Automations
        • CampaignOpenEmailDetails
        • Conversations
        • ListAbuse
        • ListActivity
        • ListClients
        • ListGrowthHistory
        • ListMemberActivity
        • ListSignupForms
        • ReportAbuse
        • ReportAdvice
        • ReportClickDetails
        • ReportClickDetailsMembers
        • ReportDomainPerformance
        • ReportEmailActivity
        • ReportLocations
        • Reports
        • ReportSentTo
        • ReportUnsubscribes
    • Marin
    • Messagebird
    • Microsoft Dynamics CRM
    • Microsoft SQL
    • Mixpanel
    • Mix Max
    • MongoDB
    • MySQL
    • Navisite - SQL Server
    • Odoo
    • Office 365
      • Tables
        • Calendars
        • Contacts
        • Conversations
        • Events
        • Files
        • Groups
        • Messages
        • Plans
        • Tasks
        • Users
        • CalendarView
        • EventOccurrences
    • Open Exchange Rates
      • Setup Guide
    • Oracle Database
    • Outlook
    • Pinterest
    • PostgreSQL
    • Product Hunt
    • QuickBooks (Online)
      • Tables
        • Accounts
        • AttachableRefs
        • Attachables
        • BillLineItems
        • BillLinkedTransactions
        • BillPaymentLineItems
        • BillPayments
        • Bills
        • BudgetDetails
        • Budgets
        • Class
        • CompanyCurrency
        • CompanyInfo
        • CreditMemoLineItems
        • CreditMemos
        • Customers
        • Departments
        • DepositLineItems
        • Deposits
        • Employees
        • EstimateLineItems
        • EstimateLinkedTransactions
        • Estimates
        • ExchangeRates
        • InvoiceLineItems
        • InvoiceLinkedTransactions
        • Invoices
        • Items
        • JournalCode
        • JournalEntries
        • JournalEntryLineItems
        • PaymentLineItems
        • PaymentMethods
        • Payments
        • Preferences
        • PurchaseLineItems
        • PurchaseOrderLineItems
        • PurchaseOrderLinkedTransactions
        • PurchaseOrders
        • Purchases
        • RecurringInvoiceTransactions
        • RecurringInvoiceTransactionsLineItems
        • RecurringJournalEntryTransactions
        • RecurringJournalEntryTransactionsLineItems
        • RefundReceiptLineItems
        • RefundReceipts
        • SalesReceiptLineItems
        • SalesReceipts
        • TaxAgency
        • Terms
        • TimeActivities
        • Transfers
        • VendorCreditLineItems
        • VendorCredits
        • Vendors
        • BalanceSheetSummaryReport
        • CreditCardPayments
        • CustomerBalanceDetail
        • CustomerTypes
        • Entitlements
        • GetDeletedAsView
        • RecurringBillTransactions
        • TaxCodes
        • TaxRates
        • Thresholds
    • Rakuten
    • Redshift
    • Restaurant365
    • REST API
    • REST OAUTH
    • Service Now
    • Salesforce
      • Tables
        • AcceptedEventRelation
        • Account
        • AccountContactRole
        • AccountFeed
        • AccountHistory
        • AccountPartner
        • AccountShare
        • AdditionalNumber
        • ApexClass
        • ApexComponent
        • ApexLog
        • ApexPage
        • ApexTestQueueItem
        • ApexTestResult
        • ApexTrigger
        • AppMenuItem
        • Approval
        • Asset
        • AssetFeed
        • AssignmentRule
        • AsyncApexJob
        • Attachment
        • AuthProvider
        • AuthSession
        • BrandTemplate
        • BusinessHours
        • BusinessProcess
        • CallCenter
        • Campaign
        • CampaignFeed
        • CampaignMember
        • CampaignMemberStatus
        • CampaignShare
        • Case
        • CaseComment
        • CaseContactRole
        • CaseFeed
        • CaseHistory
        • CaseShare
        • CaseSolution
        • CaseStatus
        • CaseTeamMember
        • CaseTeamRole
        • CaseTeamTemplate
        • CaseTeamTemplateMember
        • CaseTeamTemplateRecord
        • CategoryData
        • CategoryNode
        • ChatterActivity
        • ClientBrowser
        • CollaborationGroup
        • CollaborationGroupFeed
        • CollaborationGroupMember
        • CollaborationGroupMemberRequest
        • CollaborationInvitation
        • Community
        • Contact
        • ContactFeed
        • ContactHistory
        • ContactShare
        • ContentDocument
        • ContentDocumentFeed
        • ContentDocumentHistory
        • ContentDocumentLink
        • ContentVersion
        • ContentVersionHistory
        • Contract
        • ContractContactRole
        • ContractFeed
        • ContractHistory
        • ContractStatus
        • CronJobDetail
        • CronTrigger
        • Dashboard
        • DashboardComponent
        • DashboardComponentFeed
        • DashboardFeed
        • DeclinedEventRelation
        • Document
        • DocumentAttachmentMap
        • Domain
        • DomainSite
        • EmailServicesAddress
        • EmailServicesFunction
        • EmailTemplate
        • EntitySubscription
        • Event
        • EventFeed
        • EventRelation
        • FeedComment
        • FeedItem
        • FeedPollChoice
        • FeedPollVote
        • FieldPermissions
        • FiscalYearSettings
        • Folder
        • ForecastShare
        • Group
        • GroupMember
        • HashtagDefinition
        • Holiday
        • Lead
        • LeadFeed
        • LeadHistory
        • LeadShare
        • LeadStatus
        • LoginHistory
        • LoginIp
        • MailmergeTemplate
        • MobileDeviceRegistrar
        • Note
        • ObjectPermissions
        • Opportunity
        • OpportunityCompetitor
        • OpportunityContactRole
        • OpportunityFeed
        • OpportunityFieldHistory
        • OpportunityHistory
        • OpportunityLineItem
        • OpportunityPartner
        • OpportunityShare
        • OpportunityStage
        • Organization
        • OrgWideEmailAddress
        • Partner
        • PartnerRole
        • Period
        • PermissionSet
        • PermissionSetAssignment
        • PermissionSetLicense
        • PermissionSetLicenseAssign
        • Pricebook2
        • Pricebook2History
        • PricebookEntry
        • ProcessDefinition
        • ProcessInstance
        • ProcessInstanceStep
        • ProcessInstanceWorkitem
        • ProcessNode
        • Product2
        • Product2Feed
        • Profile
        • PushTopic
        • QueueSobject
        • Quote
        • QuoteDocument
        • QuoteFeed
        • QuoteLineItem
        • RecentlyViewed
        • RecordType
        • Report
        • ReportFeed
        • Scontrol
        • SelfServiceUser
        • SetupEntityAccess
        • Site
        • SiteFeed
        • SiteHistory
        • Solution
        • SolutionFeed
        • SolutionHistory
        • SolutionStatus
        • StaticResource
        • Task
        • TaskFeed
        • TaskPriority
        • TaskStatus
        • Topic
        • TopicAssignment
        • TopicFeed
        • UndecidedEventRelation
        • User
        • UserFeed
        • UserLicense
        • UserLogin
        • UserPreference
        • UserProfile
        • UserRecordAccess
        • UserRole
        • Vote
        • WebLink
        • Formulas
        • JobRecordResultsV2
        • PickListValues
        • TableRelationships
    • Salesforce Pardot
    • SAP ERP (Netweaver)
    • Search Ads 360
      • Setup Guide
    • SendGrid
      • Tables
        • Alerts
        • ApiKeys
        • Bounces
        • CancelScheduledSends
        • CustomFields
        • GlobalUnsubscribes
        • InvalidEmails
        • Lists
        • MarketingCampaigns
        • NMCCustomFields
        • NMCLists
        • NMCSegments
        • NMCSenders
        • NMCSingleSends
        • Recipients
        • Schedules
        • Segments
        • SenderIdentities
        • Spam
        • Teammates
        • UnsubscribeGroups
        • AdvancedStats
        • Categories
        • CategoryStats
        • GlobalStats
        • GroupSuppressions
        • IPAccessManagement
        • MessageEvents
        • Messages
        • Recipients
        • NMCReservedFields
        • ReservedFields
        • SubuserStats
        • Users
    • Setting up an E-mail Data Source
    • SFTP
    • SharePoint
      • SOAP Data Model
        • Tables
          • Announcements
          • Attachments
          • Calendar
          • Contacts
          • Documents
          • Groups
          • IssueTracking
          • Links
          • Pictures
          • Roles
          • Tasks
          • Users
          • Views
          • FileVersions
          • GetValidTerms
          • Lists
          • Permissions
          • Subsites
      • REST Data Model
        • Tables
          • Attachments
          • Files
          • Groups
          • Lists
          • RoleAssignmentMember
          • RoleAssignments
          • RoleDefinitionBindings
          • Roles
          • Subsites
          • Users
    • Shopify
      • Setup Guide
      • Tables
        • ApplicationCharges
        • ApplicationCredit
        • Articles
        • Assets
        • Blogs
        • CollectionListings
        • Collects
        • Comments
        • Countries
        • CustomCollections
        • CustomerAddresses
        • Customers
        • DiscountCodes
        • DraftOrders
        • FulfillmentEvents
        • Fulfillments
        • FulfillmentServices
        • InventoryItems
        • InventoryLevels
        • MarketingEvents
        • OrderRisks
        • Orders
        • OrderTransactions
        • Pages
        • PriceRules
        • ProductImages
        • ProductListings
        • Products
        • ProductVariants
        • Provinces
        • RecurringApplicationCharges
        • Redirects
        • Refunds
        • ScriptTags
        • SmartCollections
        • Themes
        • UsageCharges
        • AbandonedCheckouts
        • AbandonedCheckoutsItems
        • AssignedFulfillmentOrders
        • DiscountApplications
        • DraftOrderItemProperties
        • DraftOrderItems
        • DraftOrderItemTaxLines
        • Events
        • FulfillmentOrders
        • Locations
        • NoteAttributes
        • OrderDiscountCodes
        • OrderItemDiscountAllocations
        • OrderItemProperties
        • OrdersItems
        • Payouts
        • PayoutTransactions
        • ProductOptions
        • RefundAdjustments
        • RefundsItems
        • RefundTransactions
        • Reports
        • ShippingItems
        • ShippingZones
        • Shop
        • TaxItems
    • Snapchat
      • Setup Guide
    • Square
    • SQL Server
    • Snowflake
    • Stripe
      • Setup Guide
      • Tables
        • Accounts
        • BankAccounts
        • BankAccountTokens
        • Cards
        • CardTokens
        • Charges
        • Coupons
        • CustomerDiscounts
        • Customers
        • InvoiceLineItems
        • Invoices
        • Payouts
        • Plans
        • Prices
        • Refunds
        • SubscriptionDiscounts
        • SubscriptionItems
        • Subscriptions
        • TransferReversals
        • Transfers
        • AvailableBalance
        • BalanceChangeFromActivitySummaryReport
        • BalanceSummaryReport
        • BalanceTransactions
        • CountrySpecs
        • Disputes
        • EndingBalanceReconciliationSummaryReport
        • Events
        • ItemizedBalanceChangeFromActivityReport
        • ItemizedEndingBalanceReconciliationReport
        • ItemizedPayoutReconciliationReport
        • ItemizedPayoutsReport
        • ItemizedReconciliationForASinglePayoutReport
        • Orders
        • PayoutsReconciliationSummaryForASinglePayoutReport
        • PayoutsReconciliationSummaryReport
        • PayoutsSummaryReport
        • PendingBalance
        • Products
        • Reports
        • Skus
    • The Trade Desk
    • Tiktok
    • TSV
    • Twilio
    • Twitter Ads
      • Tables
        • AdAudiencePermissions
        • AdAudiences
        • AdAccounts
        • AdCampaigns
        • AdFundingInstruments
        • AdLineItems
        • AdPromotedTweets
        • AdStats
        • AdTweets
    • Twitter Social
    • Typeform
    • Uber Eats
    • Vertica
    • Webhooks
    • Xero
      • Data Model
        • Accounting Data Model
          • Tables
            • Accounts
            • BankTransactions
            • BankTransfers
            • BatchPayments
            • ContactGroups
            • Contacts
            • CreditNotes
            • Employees
            • ExpenseClaims
            • HistoryBankTransactions
            • HistoryBatchPayments
            • HistoryContacts
            • HistoryCreditNotes
            • HistoryInvoices
            • HistoryPurchaseOrders
            • Invoices
            • Items
            • LinkedTransactions
            • ManualJournals
            • Payments
            • PurchaseOrders
            • Receipts
            • TaxRates
            • AgedPayablesByContact
            • AgedReceivablesByContact
            • BalanceSheet
            • BankStatement
            • BankSummary
            • BrandingThemes
            • BudgetLines
            • Budgets
            • BudgetSummary
            • ContactCISSettings
            • Currencies
            • ExecutiveSummary
            • ExpenseClaimPayments
            • ExpenseClaimReceipts
            • HistoryBankTransfers
            • HistoryExpenseClaims
            • HistoryItems
            • HistoryOverpayments
            • HistoryPayments
            • HistoryPrepayments
            • HistoryReceipts
            • HistoryRepeatingInvoices
            • Journals
            • Organisation
            • OrganisationActions
            • Overpayments
            • Prepayments
            • ProfitAndLoss
            • Quotes
            • RepeatingInvoices
            • Tenants
            • TrackingCategories
            • TrialBalance
            • Users
        • Australian Payroll Data Model
          • Tables
            • Employees
            • LeaveApplications
            • PayItemsDeductions
            • PayItemsEarnings
            • PayItemsLeave
            • PayItemsReimbursements
            • PayrollCalendars
            • PayRuns
            • SuperFunds
            • Timesheets
            • EmployeeBankAccounts
            • EmployeePayTemplateDeductions
            • EmployeePayTemplateEarnings
            • EmployeePayTemplateLeave
            • EmployeePayTemplateReimbursements
            • EmployeePayTemplateSupers
            • LeaveBalances
            • PaySlipDeductions
            • PaySlipEarnings
            • PaySlipLeaveAccrual
            • PaySlipLeaveEarnings
            • PaySlipReimbursements
            • PaySlips
            • PaySlipSuperannuations
            • PaySlipTaxes
            • PaySlipTimesheetEarnings
            • Tenants
        • Files Data Model
          • Tables
            • Associations
            • Files
            • Folders
            • Tenants
        • Fixed Assets Data Model
          • Tables
            • Assets
            • AssetTypes
            • Settings
            • Tenants
        • Projects Data Model
          • Tables
            • Projects
            • Tasks
            • Time
            • Tenants
            • Users
    • Yahoo
    • YouTube Analytics
      • Tables
        • Activities
        • AdPerformanceReports
        • Captions
        • Channels
        • ChannelSections
        • Comments
        • CommentThreads
        • Demographics
        • Devices
        • EngagementReports
        • Languages
        • PlayListItems
        • PlayLists
        • Regions
        • Subscriptions
        • TimeBasedReports
        • TopVideos
        • TrafficSources
        • VideoAbuseReportReasons
        • VideoCategories
        • Videos
        • Groups
        • GroupItems
    • Zendesk
      • Tables
        • AccountSettings
        • Automations
        • Brands
        • GroupMemberships
        • Groups
        • Holidays
        • JiraLinks
        • Macros
        • OrganizationFields
        • OrganizationMemberships
        • Organizations
        • OrganizationSubscriptions
        • PostComments
        • Posts
        • SatisfactionRatings
        • Schedules
        • Sessions
        • SharingAgreements
        • SupportAddresses
        • SuspendedTickets
        • TicketFields
        • TicketForms
        • Tickets
        • Topics
        • Triggers
        • UserFields
        • UserIdentities
        • Users
        • Views
        • ActivityStream
        • AppLocations
        • Attachments
        • Collaborators
        • CustomAgentRoles
        • JobStatus
        • Locales
        • MonitoredTwitterHandles
        • Requests
        • Requests_Collaborators
        • SlaPolicies
        • TicketAudits
        • TicketComments
        • TicketMetricEvents
        • TicketMetrics
        • Tickets_Collaborators
        • Tickets_Followers
        • Tickets_Followups
        • Tickets_Macros
        • Tickets_SatisfactionRatings
        • Tickets_SharingAgreements
        • Tickets_Tags
        • Tickets_Viasources
        • UserRelatedInformation
    • Zendesk Sell
    • Zoho CRM
      • Tables
        • Accounts
        • Activities
        • Attachments
        • Calls
        • Campaigns
        • Cases
        • Contacts
        • Currencies
        • Deals
        • Events
        • Invoices
        • Leads
        • Notes
        • Pipeline
        • PriceBooks
        • Products
        • PurchaseOrders
        • Quotes
        • SalesOrders
        • Solutions
        • Tasks
        • Vendors
        • ActionsPerformed
        • CustomFieldHistoryTracking
        • Fields
        • InvoiceProductDetails
        • Layouts
        • ModuleAttachedFiles
        • Modules
        • Organizations
        • PriceBookPricingDetails
        • Profiles
        • PurchaseOrderProductDetails
        • QuoteProductDetails
        • RecordCount
        • Roles
        • SalesOrderProductDetails
        • StageHistories
        • Territories
        • Users
        • Visits
    • Zoho Desk
  • Destinations
    • Amazon S3
    • AWS Redshift
    • Azure Storage
    • Azure SQL
    • Azure Synapse Analytics
    • Google BigQuery
    • FTP
    • Microsoft Azure SQL
    • Microsoft SQL Server
    • PostgreSQL
    • SFTP
    • Snowflake Database
    • About Google BigQuery
    • Files
      • Amazon S3
      • SFTP
      • FTP
  • Integrations
    • Slack
    • Microsoft Teams
  • Security
    • Gravity IP Addresses - Whitelisting
    • SSH Tunnel
    • Audit Log
    • Gravity Subprocessors
  • User Management
    • User Management
  • Billing
    • Billing
  • Community
    • Changelog
    • Roadmap
    • HAR file for troubleshooting
Powered by GitBook
On this page
  • Columns
  • Pseudo-Columns

Was this helpful?

  1. Sources
  2. Stripe
  3. Tables

Cards

Columns

Name

Type

ReadOnly

References

Description

Id [KEY]

String

False

The card Id.

CustomerId [KEY]

String

False

The customer Id this card belongs to.

ExpMonth

Integer

False

The card expire month.

ExpYear

Integer

False

The card expire year.

Currency

String

False

Only applicable on accounts (not customers or recipients). The card can be used as a transfer destination for funds in this currency.

Account

String

False

The account Id this card belongs to.

Token

String

False

The token Id.

AddressCity

String

False

The city address.

AddressCountry

String

False

Billing address country, if provided when creating card.

AddressLine1

String

False

The address line 1.

AddressLine1Check

String

False

If AddressLine1 was provided. Possible values: pass, fail, unavailable, or unchecked.

AddressLine2

String

False

The address line 2.

AddressState

String

False

The address state.

AddressZip

String

False

The address ZIP.

AddressZipCheck

String

False

If AddressZip was provided. Possible values: pass, fail, unavailable, or unchecked.

Brand

String

False

Card brand.

Country

String

False

Two-letter ISO code representing the country of the card. You could use this attribute to get a sense of the international breakdown of cards you have collected.

CvcCheck

String

False

If a CVC was provided. Possible values: pass, fail, unavailable, or unchecked.

DefaultForCurrency

Boolean

False

Only applicable on accounts (not customers or recipients). This indicates whether or not this card is the default external account for its currency.

Number

String

False

The card expire year.

Fingerprint

String

False

Uniquely identifies this particular card number.

Funding

String

False

Card funding type.

Last4

String

True

Last 4 digits of the card.

Name

String

False

Cardholder name.

Recipient

String

False

The recipient that this card belongs to.

TokenizationMethod

String

False

If the card number is tokenized, this is the method that was used.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name

Type

Description

AccountId

String

The Id of the connected account to get cards for.

PreviousBankAccountTokensNextCardTokens

Last updated 3 years ago

Was this helpful?