Data inconsistency between report tab and v3 API

[Stevy]

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 (https://docs.catsone.nl/api/v3/) 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]

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?

[Stevy]

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?

[Stevy]

Any updates?