Successfactors CompoundEmployee API - pay_group filter does not work

[tomvanrooijen]

Hi,

We are using the successfactors CompoundEmployee api to retrieve data for integration with a legacy payroll system (using CPI).

We have a problem using the Pay_Group selection field in the api where clause, no matter what I do I always get zero results when selecting the pay_group external code.

If I select on person_id_external I can see the pay_group external code in de SF reply as part of the compensation_information xml response.

Why doesn't the select work? It looks like this in simplified form: where pay_group in ('<external code>')

The codes are valid and match with the list in successfactors itself.

I can filter later on in CPI but preferably I would like the SF Api to apply the filter of course.

Regards

Tom

[former_member26700 · Accepted solution]

From documentation, Pay_group should be part of Job and NOT comp for filter to work.

Refer CE API documentation.

PAY_GROUP Returns all employees having a job with the provided pay group. The select is based on the external code of the pay group. EMP_JOB_INFO_T. PAY_GROUP =, IN

-Bhargav