ETL Bitrix24 data to SQL Server

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 access-related reporting.

Provides CRM deal records that represent sales opportunities moving through the pipeline. It typically includes deal amounts, stages, assigned users, related contacts or companies, timestamps, and custom CRM fields used for revenue and funnel analysis.

Contains individual person records stored in the CRM, such as leads, customers, or partners. Data usually includes names, phone numbers, email addresses, assigned managers, source information, and linked CRM entities.

Returns organization-level CRM records for client or partner companies. This data often includes company names, industry details, contact information, assigned owners, and relationships to deals, contacts, and other CRM objects.

Provides incoming prospect records before they are qualified into contacts, companies, or deals. It is useful for tracking acquisition sources, lead status progression, responsible users, and conversion performance.

Contains task and work management data created in Bitrix24 for teams and employees. Typical fields include task titles, descriptions, deadlines, statuses, creators, assignees, and project or group associations, making it valuable for operational reporting.

Returns CRM activity records such as calls, emails, meetings, and follow-ups linked to leads, contacts, companies, or deals. This endpoint is important for analyzing sales engagement history, response times, and communication workflows.

Provides billing and payment-related records associated with CRM transactions. It generally includes invoice amounts, statuses, due dates, linked clients, and related deals, supporting financial and sales performance analysis.