Data inconsistency between report tab and v3 API

Skip to first unread message


Feb 4, 2022, 8:43:41 AM2/4/22
to CATS API v3
I am trying to recreate the "analytics" tab of the CATSONE tab to validate if the data shown in the analytics tab (the correct data) is the same as the data I get from the CATSONE API.

In this example case I used, the corresponding consultant shows 1x "hired" in the time range 2022-01-01 till 2022-01-10.

I created an API token for the v3 API ( and was able to get data. When I try to validate the data in the case above, I do not get 1x "hired" from the API in any way.

These are the steps I do to try and replicate the data from the "analytics" tab in CATSONE:

1. Using the owner_id of the consultant in the case above, I get all candidates from 2021-07-01 till 2022-01-10.

2. I use the candidate_ids of all the retrieved candidates to get all the corresponding pipelines. I use the pipelines/search endpoint with a filter on candidate_id for this.

3. Using all the pipeline_ids I retrieve all the historical statuses for each pipeline. For this I use the pipelines/<id>/statuses endpoint.

I print all the historical statuses along with the date of the status change, so I can manually check the status data.

When I go through this big list with statuses, there is 1x a status "hired". However, this status was set in oktober 2021 and therefore can not be counted as "hired" in the date range 2022-01-01 till 2022-01-10.

My question is: am I missing something here, should I use different endpoint to achieve my goal? Or does the "analytics" tab in CATSONE gets it data from a different source?

If anymore info is needed, please let me know.

Best regards,

Stèphan Hilberts

Anthony Allan

Feb 7, 2022, 11:58:41 AM2/7/22
to CATS API v3
What are the user, candidate, and job IDs for this 1 "hired" placement between Jan 1 and Jan 10 that you're expecting to see?


Feb 8, 2022, 9:48:16 AM2/8/22
to CATS API v3
In the tab "reports" there is 1x "hired" as shown in the picture below. Following the steps I described above, I only get 1x status "hired" from the API, historical statuses but with status_date 2021-10-05. I tried to manually check if there is a candidate for this user that has been hired in the given period but I was not able to find one in the CATSONE interface, "candidates"-tab.

Data of the only "placed" status I got from the API:

user/consultant = 22581
candidate = 8994403
job = 764557

Does the report below gets its data from the CATS API v3 or from somewhere else?



Mar 2, 2022, 9:49:16 AM3/2/22
to CATS API v3
Any updates?
Reply all
Reply to author
0 new messages