iSyncSFDocumentation

#20. Data Model (Key Objects)

iSyncSF uses a set of custom Salesforce objects to store templates, jobs, audit logs, and org connections. Understanding these objects is valuable for admins building reports, creating list views, or diagnosing issues — and for developers extending iSyncSF through custom integrations.

Purpose: These custom objects store all configuration, execution state, and audit data for the application. Understanding the data model is essential for an AI agent building the application, as every feature reads from and writes to these objects. Where It Fits: The data model underpins the entire application. Configuration objects (Templates, Template Lines, Object Settings) are populated during setup. Execution objects (Jobs, Child Jobs, Audit Logs) are created and updated during sync execution. Comparison and Automation objects track org compare and automation control operations.

#20.1 Core Objects

ObjectPurpose
OrgMaster__cStores target org connection details (credentials, tokens, org info)
DataSyncTemplate__cTemplate configuration (sync settings, behavior flags)
DataSyncTemplateLines__cTemplate line items (objects to sync, filters, child config)
DataSyncObjectSetting__cPer-object sync settings (target object, mapping fields, callbacks)
ObjectFieldMapping__cField-level source-to-target mappings with expressions
PicklistValueMapping__cPicklist value translations (child of ObjectFieldMapping__c)
DataConcealSetting__cData masking rules (JSON configuration)

#20.2 Execution Objects

ObjectPurpose
DataSyncJob__cMaster sync job record (status, progress, current async job ID)
DataSyncChildJob__cChild job per template line (status, object type info)
DataSyncAuditLog__cPer-record audit trail (source ID, destination ID, status, errors)
DataVersion__cVersion data for rollback (original field values before update)
ApplicationLog__cApplication log entries (message, level, timestamp)

#20.3 Comparison & Automation Objects

ObjectPurpose
OrgCompareJob__cOrg comparison job tracking
OrgCompareResult__cIndividual comparison results per object/field
AutomationJob__cAutomation scan/toggle job tracking
AutomationResult__cIndividual automation results per rule/trigger/flow

#20.4 Configuration Objects

ObjectPurpose
DataSyncProperties__mdtCustom metadata for global settings (API version, callbacks, OAuth)
SystemProperties__cList custom setting for runtime properties (debug level, buffers)
DataSyncTransactionalObjects__cList custom setting for objects to skip
TemplateObjectSettings__cPer-object per-template overrides (migration order, update behavior)
OAuthSecrets__cHierarchy custom setting for encryption keys