BambooHR Custom Fields Access Denied Despite Working In Postman

  • Is this your first time deploying Airbyte: No
  • OS Version / Instance: EC2 t2.xlarge
  • Memory / Disk: 32Gb
  • Deployment: Docker
  • Airbyte Version: 0.40.30-alpha
  • Source name/version: BambooHR 0.2.2
  • Destination name/version: Snowflake 0.4.46
  • Step: Connector setup
  • Description:

I’m using the BambooHR connector with my API Key I’m able to pull in a custom field called hireDate via Postman, however, using the same API key and inputting the same field hireDate I’m getting the following access denied error. If I don’t put anything into the custom fields input then the connector works

The connection tests failed. 
CustomFieldsAccessDeniedError('Access to fields: hireDate - denied. 
Please check your access level.')

The custom field input is extremely particular. You need to first query the all fields end point to determine the actual name of the field, spaces included.

For example, my hireDate field returned by the API is as follows:

<field id="3" type="date" alias="hireDate">Hire Date</field>

But when entering this into the Airbyte text box you need to input it as Hire Date

Now the new problem is that this is no longer returning access denied, but the entire columns are pulled in as NULL