I need to consume an XML from a supplier using a ProDataset but have run into a problem due to how the suppliers sends some repeating information. There is section on the XML where data is passed as follows
<fare>
<class>First</class>
<basefare>1000.00</basefare>
<taxes>80.00</taxes>
<class>Business</class>
<basefare>500.00</basefare>
<taxes>80.00</taxes>
<class>Economy</class>
<basefare>250.00</basefare>
<taxes>80.00</taxes>
</fare>
Is it possible to define a ProDataset that can handle this XML? Each time a new <class> tag is read it would create a new row in a fare temp-table so the example above would have 3 rows. Supplier sends XML to many other subscribers so they cannot modify it for us.
<fare>
<class>First</class>
<basefare>1000.00</basefare>
<taxes>80.00</taxes>
<class>Business</class>
<basefare>500.00</basefare>
<taxes>80.00</taxes>
<class>Economy</class>
<basefare>250.00</basefare>
<taxes>80.00</taxes>
</fare>
Is it possible to define a ProDataset that can handle this XML? Each time a new <class> tag is read it would create a new row in a fare temp-table so the example above would have 3 rows. Supplier sends XML to many other subscribers so they cannot modify it for us.