How to get more than 20000 record in Successfactor in one single run

[naveenarockiaraj]

Dear Experts,

I am having the requirements to get 2 lakh record to process in SAP CPI, so thought of splitting into 10 times as 20000 records,is there odata api will support? I am having where in clause query filter so that it is having some limitations allowing only 450 to 500 records to fetch in a single call. Can you please let me the know the feasible solution? Is Cpi will support 2 lakh record in single run?

[naveenarockiaraj]

Hi Matt,

Thanks for the reply. I am receiving more than 2 lakh records, Can you please confirm single iflow of CPI Will support more 2lakhs records?

Regards,

Naveen

[MaAll]

Hi Naveen,

The SuccessFactors OData API can return up to only 1000 records in a single request. In order to retrieve more, then you must use pagination.

This is documented here. It is also described in a number of blogs too.

Regards,

Matt