Hello Rick & Alfredo,
@ It uses a script in Powershell to assist in obtaining the data. Instead of using a CSV file, we would like to use an XML file, but don't understand how to write the script to obtain the data. I believe that this is what Alfredo is talking about.
------
This video tell about using an existing .CSV file to create a new Data source type to acquire in a new scheme table in WFA. But you DON'T have to have an existing .CSV file. You can create a .CSV file by your PoSH script which will read data from the XML file. I'll take the below example:
1. A new Dictionary item "users" in a new scheme "people" with following attributes, first_name, last_name
2. My XML file is Users.xml with the below content:
<Users>
<User>
<id>1</id>
<FirstName>Abhishek</FirstName>
<LastName>Sinha</LastName>
</User>
<User>
<id>2</id>
<FirstName>Rick</FirstName>
<LastName>Ehrhart</LastName>
</User>
</Users>
2. Add a new data source type (e.g. name XML Datat source), method=Script and in Script, you can write a powershell code that will read your XML file and create a new .CSV file when you acquire a DataSource of Type 'XML Data source" and populate your table users.
I'm attaching a Datasource type that will do it. Its script is comments at all steps to help you understand what is it doing. Its very simple.
3. Execution => Data Sources => Add a new Data source of type XML Datasource. Provide Some filler Host Name and save it. It should succeed and will acquire the XML data into you new schema.

4. For every table, you'll need one .CSV file. So accordingly modify your PoSH script.
If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.