XML/JSON File Source
Last updated
Last updated
Adding an XML/JSON Source object allows you to transfer data from an XML or JSON file. An example of what an XML/JSON file source object looks like is shown below.
To configure the properties of an XML/JSON Source object after it was added to the dataflow, right-click on it and select Properties from the context menu.
The following properties are available:
File Path – specifies the location of the source XML or JSON file. Using UNC paths is recommended if running the dataflow on a server.
Schema File Path – specifies the location of the XSD file controlling the layout of the XML source file.
Optional Record Filter Expression – allows you to enter an expression to selectively filter incoming records according to your criteria. You can use Expression Builder to help you create your filter expression.
Note: To open the source file for editing in a new tab, click icon next to the File Path input, and select Edit File.
To generate the schema, click icon next to the Schema File Path input, and select Generate.
To edit an existing schema, click icon next to the Schema File Path input, and select Edit File. The schema will open for editing in a new tab.