Frequent Rest API call slow down snow performance

[Tapas Mondal]

Hi Everyone,

I have a job which calling SNOW Rest API to get modified data from Service now. I used sys_updated_on as a filter query and set page limit to 1000. The job is running at 5 mins interval. when the job is running the snow users are getting slowness issue in snow itselt. 

Can you please help me how to optimize my query and get real time modification items.

Thanks in advance

[Ankur Bawiskar]

@Tapas Mondal 

Ideally such API calls should happen during non-business hours so that they don't impact the instance.

Seems you need to check with your business team on this requirement.

5mins for getting real-time in business hours will lead to issue

please check this

TechNow Ep 49 | Faster Integrations with the REST API Explorer

Making REST call pagination wise to retrieve records

Regards
Ankur

[Tapas Mondal]

Thank you Ankur for your response. Is there any alternate solution?

[Ankur Bawiskar]

Hi,

I don't think so.

But you can check with your business team to check with ServiceNow on this

1) if the nodes for the instance are increased the performance might increase

Regards
Ankur