Required Fields for Incremental Replication
Replication with Incremental Updates selected requires entity keys and fields storing the information about record creation/last modification times selected in all its tasks. All fields are selected by default, but you can manually exclude fields from selection. Here is the list of these required additional fields for all the data sources:
- for ActiveCampaign: CreatedDate, UpdatedDate
- for Asana: CreatedDate, UpdatedDate
- for BigCommerce: DateCreated, DateModified
- for Dynamics 365: modifiedon, createdon;
- for FreshBooks: DateCreated, DateModified
- for Freshdesk: Created, Updated
- for G Suite (Google Apps): Updated
- for HubSpot: CreatedAt, UpdatedAt
- for Jira: CreatedDate, UpdatedDate
- for Magento: created_at, updated_at
- for Mailchimp: CreatedDate, LastUpdate
- for Marketo: Created At, Updated At
- for NetSuite: dateCreated, lastModifiedDate
- for Pipedrive: CreatedDate, UpdatedDate
- for QuickBooks: MetaData_CreateTime, MetaData_LastUpdatedTime
- for Salesforce: LastModifiedDate, CreatedDate
- for Salesforce Marketing Cloud: CreatedDate, ModifiedDate
- for ShipStation: CreatedDate, UpdatedDate
- for Shopify: CreatedAt, UpdatedAt
- for Streak: CreatedDate, LastModifiedDate
- for Stripe: CreatedDate, UpdatedDate
- for SugarCRM: date_modified, date_entered
- for WordPress: CreatedDate, UpdatedDate
- for Zendesk: Created, Updated
- for Zoho Books: CreatedDate, UpdatedDate
- for Zoho CRM: Modified Time, Created Time
- for Zoho Inventory: CreatedDate, UpdatedDate
- for Zoho Invoice: CreatedDate, UpdatedDate
- for Zoho People: CreatedDate, UpdatedDate
Note that it is enough to have just one of the fields, storing record creation and modification timestamps, selected or even present in the object.