Help parsing XML file for data load script

[mikegrattan]

I need some assistance please.  I've tried the REST connector and the Web Page connector but cannot figure out a way to import data from a web site.  There is a header for the entire recordset, which begins with <agrian_reports>  and ends with </agrian_reports> , but I only want the records inside the report and not the header information. 

Each new record starts with <rec_id>  and the last field in each record ends with </view_url> .  There is a sample below that is truncated; actual records have many more fields.  

Any advice on how to set up a data connection that will recognize the following?

<rec_id>7645643</rec_id> <noi_id></noi_id> <invoice_id></invoice_id> <cost></cost> <preplant>False</preplant> <rec_custom_report_id>7645643</rec_custom_report_id> <rec_tank_size></rec_tank_size> <rec_pca>Tom Nagel</rec_pca> <rec_pca_license>72137</rec_pca_license> <rec_applicator_id>37365</rec_applicator_id> <rec_applicator_internal_id>1073938067</rec_applicator_internal_id> <rec_status>closed</rec_status><view_url></view_url>

Ideally, I'd like the data load script to only pull records within the report and recognize that <agrian_reports> is the start of the report and </agrian_reports> is the end of the report.

Thank you.