I'm using FileMaker Pro v12 and the BaseElements plugin to retrieve XML data which I'm storing in a variable at present. I then need to parse out the XML into individual records and set the field values along the way. I've only worked with simple XML structures before and I'm getting stuck on this one and also not sure what is the best approach.
Here's a sample of the XML:
<?xml version="1.0" encoding="utf-8"?>
<result returned="2" remaining="0">
<reply format="message" uid="96541" receiptId="94211794">
<reply format="message" uid="8745" receiptId="94721243">
In this example there are 2 records that I need to create and for each record I need to get the value of these elments:
I could parse the XML but that doesn't seem like the most efficient approach. Should I export it as an xml file somehow and then import it back in using XSLT?
If anyone has any examples of how to write a XSLT that can get both attributes and elements at the same time that would be great.
What would be the best practice to import the XML?