Set up process #

brew install cloudquery/tap/cloudquery

1. Download CLI and login

See installation options

2. Create source and destination configs

Plugin configuration

cloudquery sync bamboo-hr.yml postgresql.yml

3. Run the sync

CloudQuery sync

Overview #

The CloudQuery BambooHR plugin reads information from your BambooHR account and loads it into any supported CloudQuery destination (e.g. PostgreSQL, Snowflake, BigQuery, and more).

Authentication #

BambooHR uses basic authentication for their API request authentication, based on an API key. Here are the BambooHR instructions to get your API Key.

You'll also need your company's subdomain. If you access BambooHR via: https://mycompany.bamboohr.com, your subdomain is "mycompany".

Configuration #

This example connects the BambooHR source to a Postgres database destination. The (top level) source spec section is described in the Source Spec Reference.

kind: source
spec:
  name: "bamboo-hr"
  path: "cloudquery/bamboo-hr"
  version: "v1.4.3"
  destinations:
    - "postgresql"
  tables: ["*"]
  spec:
    # Optional parameters
    # concurrency: 100
    # table_options:
    #   employees:
    #     fields: 
    #       - firstName
    #       - lastName
    #       - customField1
    #       - customField2
    api_key: "<YOU_API_KEY>"
    subdomain: "<YOUR_COMPANY_SUBDOMAIN>"

BambooHR Spec #

This is the (nested) spec used by the BambooHR source plugin.

api_key (string) (required):
Your user's API Key to authenticate to BambooHR.
subdomain (string) (required):
Your company's subdomain. If you access BambooHR via: https://mycompany.bamboohr.com, your subdomain is "mycompany".
table_options (object) (optional):
Options to apply to specific tables. Use it to select a custom list of fields for the employees table:
```
table_options:
    employees:
      fields: 
        - firstName
        - lastName
        - customField1
        - customField2
```
By default, the field list is the default list defined in BambooHR's API docs. The id field is always returned, regardless of it being included in the list.