BambooHR Custom Fields Delivered As NULL

Connector Questions & Issues
1

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)

image
image1404×296 91 KB

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

image
image1386×886 42.9 KB

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)

2

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

3

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

image
image1088×304 31.7 KB

And this is how it is returned when delivered to Snowflake

image
image1122×476 28.1 KB

4

@marcosmarxm any updates on this?

5

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.

1 Like