GitLab

GitLab ETL connector for data replication

Snapshot

Tables/APIs supported

Integrate GitLab with Daton

  1. Sign in to Daton

  2. Select GitLab from the list of Integrations

  3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later

  4. Provide your GitLab company name and API Key

  5. Post successful authentication, you will be prompted to choose from the list of available tables

  6. Then select all required fields for each table

  7. Submit the integration

Workflow

  1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

  2. Users would be able to edit/pause/re-activate/delete integration anytime

  3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

GitLab Data

Projects

Purpose: This API is used to fetch all the projects in your GitLab Account

Source API Documentation: https://docs.gitlab.com/ee/api/projects.html

Replication: Key Based Incremental

Replication Key: last_activity_after, last_activity_before

Fields

Groups

Purpose: This API is used to fetch all the groups

Source API Documentation: https://docs.gitlab.com/ee/api/groups.html

Replication: Full Replication

Replication Key: NA

Fields

Epics (GitLab Premium Users Only)

Purpose: This API is used to fetch all the Epics under the groups. This is available only to GitLab Premium Self-managed, GitLab Premium SaaS and higher tiers

Source API Documentation: https://docs.gitlab.com/ee/api/epics.html

Replication: Key Based Incremental

Replication Key: updated_after, updated_before

Fields

Project Milestones

Purpose: This API is used to fetch the milestones of all the projects

Source API Documentation: https://docs.gitlab.com/ee/api/milestones.html

Replication: Key Based Incremental

Replication Key: last_activity_after, last_activity_before

Fields

Group Milestones

Purpose: This API is used to fetch milestones of all the groups

Source API Documentation: https://docs.gitlab.com/ee/api/group_milestones.html

Replication: Full Replication

Replication Key: NA

Fields

Releases

Purpose: This API is used to fetch the releases project wise

Source API Documentation: https://docs.gitlab.com/ee/api/releases/

Replication: Key Based Incremental

Replication Key: last_activity_after, last_activity_before

Fields

Tags

Purpose: This API is used to get a list of repository tags from a project

Source API Documentation: https://docs.gitlab.com/ee/api/tags.html

Replication: Key Based Incremental

Replication Key: last_activity_after, last_activity_before

Fields

Todos

Purpose: This API is used to fetch all to-dos that are done and pending

Source API Documentation: https://docs.gitlab.com/ee/api/todos.html

Replication: Full Replication

Replication Key: NA

Fields

Issues

Purpose: This API is used to fetch all the issues in the account

Source API Documentation: https://docs.gitlab.com/ee/api/issues.html

Replication: Key Based Incremental

Replication Key: updated_after, updated_before

Fields

Comments

Purpose: This API is used to fetch all comments in issues, epics, snippets and merge requests

Source API Documentation: https://docs.gitlab.com/ee/api/notes.html

Replication: Key Based Incremental

Replication Key: updated_after, updated_before

Fields

Commits

Purpose: This API is used to fetch the commits made in all the projects. In commit responses, created_at and commited_date are identical.

Source API Documentation: https://docs.gitlab.com/ee/api/commits.html

Replication: Key Based Incremental

Replication Key: since, until

Fields

Merge Requests

Purpose: This API is used to fetch all the merge requests made by all users

Source API Documentation: https://docs.gitlab.com/ee/api/merge_requests.html

Replication: Key Based Incremental

Replication Key: updated_after, updated_before

Fields

Branches

Purpose: This API is used to fetch branches under all projects

Source API Documentation: https://docs.gitlab.com/ee/api/branches.html

Replication: Full Replication

Replication Key: NA

Fields

Users

Purpose: This API is used to fetch all users

Source API Documentation: https://docs.gitlab.com/ee/api/users.html

Replication: Full Replication

Replication Key: NA

Fields

Last updated