Hi guys,
I am looking for someone who has experience with a generic extractor for BambooHr or can help me with the formatting of an output I am getting.
So far I've come across two issues.
1) When I try to get data from a custom table (customAdditionalJobInformation
) via code below.
"jobs": [
{
"endpoint": "employees/directory",
"dataField": "employees",
"dataType": "employee_output",
"children": [
{
"endpoint": "employees/{id}/tables/jobInfo",
"dataField": ".",
"placeholders": {
"id": "id"
}
},
{
"endpoint": "employees/{id}/tables/employmentStatus",
"dataField": ".",
"placeholders": {
"id": "id"
}
},
{
"endpoint": "employees/{id}/tables/customAdditionalJobInformation",
"dataField": ".",
"placeholders": {
"id": "id"
}
}
]
For each employee, I get a list of dictionaries instead of a table like I am getting for jobInfo
of employementstatus
. Moreover, there is a header with columns data and parent id(can be seen in the screenshot below).

I am attaching also an example of a response in postman. It seems to be the same as a response from jobInfo
. So I am not sure why i am getting results in a different format.
customAdditionalJobInformation

jobInfo

So my question is if I can somehow get the results in a better format and how. Or if I need to run the results through some python transformation.
documentation: tabular date
2) Second issue appears when I try to get a list of users as per documentation here list of users .
"jobs": [
{
"endpoint": "meta/users/",
"dataField": ".",
"dataType": "meta_users"
}
]
The above code returns results in a really weird format as can be seen below.

In postman, it looks like this.

When I remove "dataField":"."
then i get this warning:
logger.WARNING: No data array found in response! (endpoint: meta/users/)

I hope it is clear and I would really appreciate any help or hints on how to solve these issues.
Thank you very much.
Have a nice day.
Tomas