HR Integration not pulling in all users?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-03-2022 07:26 PM
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"?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-03-2022 08:12 PM
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-04-2022 09:19 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-01-2025 05:27 AM
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.
--