1C Platform1cPlatform
Back to Documentation

Data Integration

Connect your data sources and sync in real-time

Supported Integrations

Salesforce
HubSpot
Slack
AWS S3
PostgreSQL
MongoDB
Snowflake
BigQuery
MySQL

Connect a Data Source

const integration = await client.integrations.create({
  type: 'salesforce',
  credentials: {
    client_id: process.env.SF_CLIENT_ID,
    client_secret: process.env.SF_CLIENT_SECRET,
    refresh_token: process.env.SF_REFRESH_TOKEN
  },
  sync_settings: {
    auto_sync: true,
    sync_interval: '5m',
    objects: ['Account', 'Contact', 'Opportunity']
  }
});

Query Integrated Data

// Query data from any connected source
const results = await client.query({
  source: 'salesforce',
  object: 'Account',
  filter: {
    Industry: 'Technology',
    AnnualRevenue: { $gt: 1000000 }
  },
  fields: ['Name', 'AnnualRevenue', 'Owner.Email']
});