Post CSV or Excel files directly to an import set

最新推荐文章于 2024-09-14 18:46:05 发布

weixin_34345753

最新推荐文章于 2024-09-14 18:46:05 发布

阅读量102

点赞数

文章标签： java

原文链接：http://blog.51cto.com/13716461/2341356

版权

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.

转载于:https://blog.51cto.com/13716461/2341356