REST api not pulling back all records

[JJ20]

running an api call to pull all hardware records

$uri = "https://cscglobaldev.service-now.com/api/now/table/cmdb_ci_hardware

There are 14K records in the table.

Only 5K are getting returned (so the 10000 limit isn't even applied yet).

Any thoughts on what would minimize the retrieval?

Thanks in advance.

[Ankur Bawiskar]

Hi,

Can you try to give sysparm_limit parameter as well in the endpoint

Please check if that user has access to all those records

Regards
Ankur

[JJ20]

Tried with sysparm_limit=10000 and only 3000 records of the 14000 came back.

Not sure if there is any type of logging that could indicate why we are not receiving all of the records.

[Ankur Bawiskar]

Hi,

try checking in system logs.

Try with admin user

Regards
Ankur

[Harsh Vardhan]

Can you please have a look on below Hi article. 

https://hi.service-now.com/kb_view.do?sysparm_article=KB0727636