HR Integration not pulling in all users?

astanley
Tera Contributor

I did an integration with the SuccessFactors Spoke to pull in worker profile information. For some reason when the subflow "retrieve worker profiles" runs, it only is pulling in 500 users and we have about 30,000. However, when I test run the subflow and set the test to "retrieve profiles modified from: [a month ago]", it is bringing in a more accurate number of users for that time period. Is there a reason why it is not bringing in all users when set to "retrieve all worker profiles"?

3 REPLIES 3

Community Alums
Not applicable

Hi @astanley ,

When you try to pull many records at a time this issue would show up.

you can refer to this thred  https://www.servicenow.com/community/hrsd-forum/trouble-pulling-workers-and-departments-from-workday...

 

Hi @Community Alums ,

when I use development credentials it is able to pull all 30,000 users however when I use prod credentials it is only pulling exactly 500. I have already limited the amount of information that is being pulled across. I’m thinking there is a limit of 500 set somewhere? I’m not sure how to fix this

Hello @astanley 

 

Please check below link for limit 

 

https://{INSTANCE_NAME}.service-now.com/api/now/stats/{TABLE_NAME}?sysparm_count=true&sysparm_query=...

 

If you are using REST API - then paging the option another option is use different stagging table for department/ work profiles/location/job profiles.

 

If you are using SuccessFactors spoke -please check with ServiceNow Hi team.

 

--

Thanks & Regards ,
Supriya Waghmode |ServiceNow Consultant
+91-9768700534