ETL Bitrix24 data to ClickHouse

Returns employee and user profile data from Bitrix24, including IDs, names, contact details, departments, roles, and activity status. This endpoint is commonly used to build employee directories, ownership mappings, and user-based reporting.

Provides CRM contact records for individual people stored in Bitrix24. It typically includes personal details, communication fields such as phone and email, assigned users, custom fields, and timestamps for creation or updates.

Returns CRM company records representing organizations linked to sales and customer management processes. Data usually includes company name, industry-related attributes, contact information, responsible user, and custom CRM fields.

Provides sales opportunity data managed in the Bitrix24 CRM pipeline. This endpoint contains deal amounts, stages, pipelines, linked contacts or companies, responsible users, expected close dates, and other fields used for revenue and funnel analysis.

Returns lead records captured before qualification into contacts, companies, or deals. It is useful for analyzing top-of-funnel activity and usually includes source information, status, assigned user, contact details, and qualification metadata.

Provides CRM activity data such as calls, emails, meetings, and tasks associated with leads, contacts, companies, or deals. This endpoint is important for engagement analysis because it captures interaction type, timing, status, and related entity links.

Returns task management data created within Bitrix24 for operational or project workflows. It generally includes task titles, descriptions, creators, assignees, deadlines, statuses, priorities, and group or project associations.

Provides billing and payment-related records generated in Bitrix24 CRM. This data is typically used for financial reporting and includes invoice amounts, statuses, linked CRM entities, payment terms, and issue or due dates.