sysparm_limit does not work for the table api

sky7
Kilo Contributor

I am trying to use sysparm_limit to access the kb_knowledge table through the table rest api.

However, when I specify sysparm_limit, e.g., sysparm_limit=1, in the table get request, ServiceNow returns an empty array result array.

{

    "result": []

}

When I remove sysparm_limit, it works returning all the articles.

I've also tried to use sysparm_offset in combination with sysparm_limit, it always gives an empty result array.

Anyone has any thoughts on this? Might there be any settings I need to toggle on to accept this parameter?

 

I'm using Postman to send the request

https://<my_instance>.service-now.com/api/now/table/kb_knowledge?sysparm_limit=1

 

7 REPLIES 7

This is exactly what I did. Unfortunately, this does not work on the prod instance. using sysparm_limit returns an empty result array.

 

siva_
Giga Guru

Hello , 

Its working on my PDI as well, As you are saying you are able to remove sysparm_limit i can sense that you are not using Rest API Explorer on the instance. However, you can use the link specified on your browser new tab as well and check if you are  getting any results

https://dev67257.service-now.com/api/now/table/kb_knowledge?sysparm_limit=10

It should work.

Mark this response as correct / helpful if that really helps.

 

Thanks,

Siva.

 

Shrinil
Tera Contributor

Hi @sky7 , I am also facing same issue. When I use sysparm_limit=1000, I do not get any records in response. If I remove the paramater, then I get records in the response. 

Did you find any solution to this?