Export directly from a URL
-
- UpdatedAug 3, 2023
- 2 minutes to read
- Vancouver
- Data Management
You may want to export data from the URL if you need to dynamically export data from a script or web service.
Before you begin
Role required: None
About this task
You must be familiar with the ServiceNow table and column names to export data directly from the URL. See Navigate to a record or a module using a URL for more information about navigating to forms and lists.
| URL Parameter | URL Syntax | Description |
|---|---|---|
| sysparm_query | sysparm_query=[column name][operator][value] | Displays a list of records that match the query. For example: https://<instance name>.service-now.com/incident_list.do?XML&sysparm_query=priority=1 |
| sysparm_orderby | sysparm_orderby=[column name] | Sorts a list of records by the column name provided. For example: https://<instance name>.service-now.com/incident_list.do?XML&sysparm_query=priority=1&sysparm_orderby=assigned_to You can sort by only one column using sysparm_orderby. To sort by multiple columns, use sysparm_query=ORDERBY[column name]^ORDERBY[column name]. For example: sysparm_query=ORDERBYassigned_to^ORDERBYpriority. |
To export data directly from the URL, create a URL containing the following parts:
Procedure
Related Content
- Export limits
The platform provides a default upper limit for data exports.
- Form export
Any user role can export form data in a variety of formats.
- List export
You can export a list of records in a variety of formats.
- Export controls
Control the column value and header value in export files using query parameters, export set properties, and system properties.
- Exporting currency fields to Excel
Exporting currency fields to Excel applies Account formatting and can be configured to convert all values to US dollars or to export values in the user's session currency.
- Break up a large export
If the number of records to be exported exceeds the actual export limit, you may want to break the export into smaller increments that do not place a significant performance load on the platform.
- Enable export debug logging
When the property glide.export.debug is true, the instance logs export processing including database query time and the time taken to write data to the file.