BambooHR Custom Fields Delivered As NULL

This is a repost of (BambooHR Custom Fields Not Pulling)

  • Is this your first time deploying Airbyte: No
  • OS Version / Instance: EC2 t2.large
  • Memory / Disk: 16Gb
  • Deployment: Docker
  • Airbyte Version: 39.16-alpha
  • Source name/version: 0.2.0
  • Destination name/version: Snowflake 0.4.24
  • Step: n/a
  • Description:
    Trying to figure out how to use the BambooHR custom reports stream. I have a custom field in BambooHR called Squad , which I have access to via my API key. I’m able to see this field on the front end. However when I input this field as squad into the Airbyte Web UI. I’ve tried every iteration of squad (see image below)

Below is what the results come through as at the destination schema. All NULL

This is what it looks like on the front end in BambooHR
image

Here are the logs
logs-10162.txt (35.4 KB)

And a sample of the JSON stored in _airbyte_data column

 "acaStatus": "",
  "acaStatusCategory": null,
  "bestEmail": "",
  "city": "Montreal",
  "country": "Canada",
  "createdByUserId": "2485",
  "department": "Engineering",
  "displayName": "",
  "division": "",
  "employeeNumber": "106",
  "employmentHistoryStatus": "Full-Time",
  "ethnicity": null,
  "firstName": "",
  "flsaCode": "1",
  "fullName1": "",
  "fullName2": "",
  "fullName3": "",
  "fullName4": "",
  "fullName5": "",
  "hireDate": "2020-05-25",
  "homeEmail": "",
  "homePhone": "",
  "id": "122",
  "jobTitle": "",

And here is the catalog.json file as requested previously
catalog.txt (18.3 KB)

Kyle can you share the output from the BambooHR showing how the custom field is returned? You can only post the custom field and remove the rest

Hi @marcosmarxm this is how BambooHR shows it on the front end

And this is how it is returned when delivered to Snowflake

@marcosmarxm any updates on this?

Unfortunately no, Airbyte integration test account is not working. I escalated the issue to Github https://github.com/airbytehq/airbyte/issues/15170 any updated I’ll return to you.