The Now Platform® Washington DC release is live. Watch now!
12-09-2015 11:59 PM
Hello,
I want create a data source for importing XML files. I have configured all but the file path is not working . I am getting error when I load test data with this source file path: d:\request_xml.xml
Error:- com.glide.db.impex.datasource.DataSourceException: java.net.MalformedURLException: For input string: "\request_xml.xml"
I have tried changing the "\" to "/" but no success test load was possible.
Thanks!
Neha
12-10-2015 12:35 AM
Hi Neha,
Maybe this file d:\request_xml.xml is not accessible.
What is specified for the File retrieval method in the data source definition?
Best Regards
Tony
12-10-2015 12:53 AM
12-10-2015 01:05 AM
Hi Neha,
The file you are try to access is on a Windows host remote from the ServiceNow instance.
You need to specify a
Data Sources - ServiceNow Wiki
..
1 Overview
Data Sources is a module of the Import Sets application. Data sources are used to create an import set so that data can be processed, if necessary, prior to being mapped onto a production table. The data source type describes the origin of data:
Data Sources - ServiceNow Wiki
..
3 File Retrieval Methods
After defining the files that are compatible for importing, the next configuration step for the file data source is to define how the file can be imported. The following file retrieval methods are available to copy the file from where it resides to ServiceNow to be loaded into an import set.
...
Best Regards
Tony
12-10-2015 01:26 AM
Just to mention - if you specify File retrieval method of "File" the restrictions below apply
Data Sources - ServiceNow Wiki
Method | Description |
---|---|
Attachment | Attach a file to the record and import that file in an import set. |
File | Select a file to import from a local drive or, less commonly, a network location. Selecting this method provides a field to specify the network path. Only these file locations are available, for increased security.
If you need to specify an arbitrary network path, consider using a different file retrieval protocol such as FTP or SCP where you can secure the communications channel. |