sysparam_limit is not honoured for some objects in my Servicenow instance

[skansal]

Servicenow Object returns less no of records in response than the value specified in sysparam_limit.

I am using the below API call to fetch rows of a table. Ideally it should return 2000 rows but I am getting much less no of rows in response.

https://<instance>.service-now.com/api/now/v1/table/<objectname>?sysparm_offset=0&sysparm_suppress_p...

Could you please suggest is there anything I am missing here?

OR

why sysparam_limit property is not working properly?

[Maik Skoddow]

Hi @skansal 

as already explained one reason could be existing ACLs which are restricting the access to the user who is using the table API.

And especially for attachments and emails, there are ACLs in place which make sure that users only will get the data they are allowed to see.

So check first which roles your API user has. Start first with "admin" and then find a role which has fewer rights but still can fetch the data required.

Maik