Coveo connector only fetches 100 items

pzzd
Kilo Contributor

‎12-22-2023 08:40 AM

We are testing the Service Now connector in Coveo to create a Coveo source of KB articles. The connection to the SN api is working but the connector only ever fetches 100 items. We are expecting around 2000, according to our SN team.

 

I'm a Coveo user, not a ServiceNow user. It seems like there is something not set correctly in SN. A request to https://my-instance.service-now.com/api/now/stats/sn_km_mr_st_kb_knowledge?sysparm_count=true returns {"result":{"stats":{"count":"100"}}}. 

 

Any ideas what might be missing to get the connector to fetch all the KB articles?

 

Thanks!

0 Helpfuls
  • 322 Views
2 REPLIES 2

BalaG
Kilo Sage

‎12-25-2023 09:03 PM

Hi @pzzd   I got the same result as you, the count returned was 100 even though the sn_km_mr_st_kb_knowledge has only 69 records in my case. Trying the same API on incident table gave me the correct count of 10361 in my case. I recommend opening a ticket with SN support team

 

hope that helped

--

Bala Guthy

 

0 Helpfuls

pzzd
Kilo Contributor

‎01-18-2024 01:23 PM

In our case it turned out that there a script in SN that restricted the number of returned results to 100. Once that script was changed we ran into another error: the max execution time was exceeding resulting in an HTTP error. So the full solution turned out to be 1) changing the number of returned results and 2) adjusting the max execution time.

0 Helpfuls