Getting Large Data

[MubeenDev]

I want to get incident table data for 120 days. I want to show the front end into chunks like 1-7 days, 8-20 days, and so on. Also, want to group by created_at and updated_at.
What is the best approach to get data from the service now? Should I query multiple times with a small date range or one query with a large date range like 120 days? Also, should I send the created_at and updated_at in one query or two different queries?

FYI(table has millions of records)

[Community Alums]

Just use pagination https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0727636

[MubeenDev]

Want to show data in graph format so pagination will not work. @joro 

[MubeenDev]

Want to show data in graph format so pagination will not work

[Dipen Wadhwana]

Hi @MubeenDev,

Do you want to transfer data from servicenow to another platform or create visual reports with servicenow? If so, you might want to explore the performance analytics module that can assist you.

The performance analytics module is a feature of ServiceNow that allows you to monitor and optimize your service delivery processes using dashboards, KPIs, and metrics 123. You can also integrate data from other sources, such as Excel or JDBC, to get a comprehensive view of your performance.

Please mark my answer as helpful if it worked.

Thanks,

Dipen