Post CSV or Excel files directly to an import set

ps:Post CSV or Excel files directly to an import set Geneva

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

About this task
The sys_import.do target lets you dynamically upload a CSV or Excel file into the import set table specified by thesysparm_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=trueparameter 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)

Posting a CSV file - Java example
An example using the Java Apache HttpClient class to post a CSV file with basic auth credentials.