Supaglue provides a supagluelastmodifiedat timestamp field on the tables it syncs, or lastmodifiedat when you use the Unified or Data Listing API, representing the last time a record was modified in the upstream provider. Use this field as a high-water mark to sync from Supaglue-managed tables into tables you manage.
📄 Build a common schema
Suppose your application integrates with multiple third-party Providers in one category, like Salesforce, Hubspot, and Pipedrive in CRM. In that case, you likely want to read their data in a unified way. For example, for reading contacts from these CRMs, use one table in your database instead of three tables.
📄 Association bridge table
This tutorial will show how to populate bridge tables between your database tables when syncing records from Supaglue-managed tables. We'll use Hubspot Contacts and Deals as an example.
📄 Object and field mapping