question HR Integration not pulling in all users? in HRSD forum

HR Integration not pulling in all users?

astanley — Sun, 04 Dec 2022 03:26:22 GMT

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"?

Re: HR Integration not pulling in all users?

Community Alums — Sun, 04 Dec 2022 04:12:07 GMT

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/m-p/1303041

Re: HR Integration not pulling in all users?

astanley — Sun, 04 Dec 2022 17:19:52 GMT

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

Re: HR Integration not pulling in all users?

SupriyaWaghmode — Tue, 01 Apr 2025 12:27:18 GMT

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