Post CSV or Excel files directly to an import set

An administrator can post CSV or Excel files directly to instance.

Before you begin

Roles required: import_set_loader

About this task

The sys_import.do target lets you dynamically upload a CSV or Excel file into the import set table specified by the sysparm_import_set_tablename parameter. You must specify a name that matches an existing import set table name, if it does not exist, pre-create it by doing a manual import. The sysparm_transform_after_load=true parameter makes the CSV transform execute immediately, if a transform map exists.

Procedure

Use the following post syntax: https://instance.service-now.com/sys_import.do?sysparm_import_set_tablename=table_name&sysparm_transform_after_load=true&uploadfile=path/to/file.csv