Forum Discussion

Mrooney's avatar
Mrooney
Frequent Visitor
8 years ago

Limit to SNOW query

Hi, using the below query I'm no longer able to query 10,000 rows from SNOW. I used to be able to but now to get this to work I need to limit the sysparm_limit to 6,000 which of course misses loads of data from my results. Any idea how to pull ideally all rows... roughly 20,000? Error I receive is that the maximum timeout has been recieved etc.

 

= Json.Document(Web.Contents("https://mytechsolution.service-now.com/api/now/v1/table/incident?sysparm_limit=10000&sysparm_offset=0&sysparm_display_value=true&sysparm_query=cmdb_ciNOT LIKENagios^location.countryLIKEUK^ORlocation.countryLIKEFR^ORlocation.countryLIKEIR^ORlocation.countryLIKEIT^location.u_statusLIKEOpen^sys_created_onONLast 24 months@javascript:gs.monthsAgoStart(24)@javascript:gs.endOfThisMonth()&sysparm_fields=parent_incident,made_sla,u_root_cause_code,u_assignment_group_value,u_severity,sys_created_on,u_initial_assignment_group,closed_at,u_opened_by_group,u_aging_bucket,u_age_of_ticket_duration,close_code,reopen_count,location,number,cmdb_ci,priority,u_document_number,u_root_cause_notes,u_workaround_loe_hours,short_description,reassignment_count,caller_id,resolved_at,close_notes,contact_type,sys_mod_count,sys_created_by,u_market,location.country"))

2 Replies