XML/JSON File Source

Adding an XML/JSON file source object to a dataflow allows you to read and transfer data from an XML or a JSON file.

Getting XML/JSON Source Object

In this section, we’ll cover how to get XML/JSON File Source object on the dataflow designer from the toolbox.

1. To get an XML/JSON File Source from the Toolbox, go to Toolbox > Sources > XML/JSON File Source. If you’re unable to see the toolbox, go to View > Toolbox or press Ctrl + Alt + X.

../_images/160.png

2. Drag-and-drop the XML/JSON File Source object onto the designer.

../_images/237.png

You can see that the dragged source object is empty right now. This is because we haven’t configured the object yet.

Configuring the XML/JSON File Source Object

1. To configure the XML/JSON File Source object, right-click on the header and select Properties from the context menu.

../_images/320.png

When you select the Properties option from the context menu, a dialog box will open.

../_images/417.png

This is where you configure the properties for the XML/JSON File Source object.

2. The first step is to provide the File Path & Schema Location for the XML/JSON Source. By providing the file path and schema, you are building the connectivity to the source dataset.

../_images/516.png

  • Check on JSON Format if your source file is a JSON.

  • Check on Provide Inner XML to get the XML markup representing only the child nodes of the parent node.

    Note: In this case we are going to be using an XML/JSON file with Orders sample data in the parent node and Order Details sample data in the child node.

    ../_images/613.png

3. Once you’ve specified the data reading options on this screen, click Next.

../_images/714.png

On this screen, you can view the layout of your XML/JSON source file in the left column of the screen.

../_images/814.png

4. After you’re done viewing the layout, click Next. You will be taken to a new screen - Config Parameters. Here, you can define the parameters for the XML/JSON File Source.

Parameters can provide easier deployment of flows by eliminating hardcoded values and provide an easier way of changing multiple configurations with a simple value change.

Note: Parameters left blank will use their default values assigned on the properties page.

../_images/913.png

5. After you’ve configured the source object, click OK.

../_images/1014.png

You have successfully configured your XML/JSON File Source object. The fields from the source object can now be mapped to other objects in a dataflow.

../_images/1115.png