So, similar to this one Parsing JSON into separate columns, but a wider scale as there are numerous columns. I copied up to Step 6 but couldn’t figure out all the extra columns. Some have values while others don’t.
<?xml version="1.0"?>
<inventory>
<item UnitID="11299556" Record="23">
<id>11299556</id>
<dealerid>10356</dealerid>
<make>Morris Industries</make>
<model>MAXIM III</model>
<year>2003</year>
<retailprice>0</retailprice>
<clutch>1053659</clutch>
<modifieddate>11/4/2021 1:33:29 AM</modifieddate>
<horsepower>0</horsepower>
<enginehours>0</enginehours>
<airconditioners>0</airconditioners>
<isselfcontained>0</isselfcontained>
<haslevelingjacks>0</haslevelingjacks>
<issalespending>0</issalespending>
<lengthininches>0</lengthininches>
<istoyhauler>0</istoyhauler>
<displayorder>255</displayorder>
<url>http://www.example.com/--xInventoryDetail?id=11299556</url>
<images>
<Image1 image="1" modified="11/4/2021 1:33:29 AM" UnitID="11299556">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/07/A3/07A3137B-65CE-499B-98A5-A593A9D10A21.jpg</Image1>
<Image2 image="2" modified="11/4/2021 1:33:29 AM" UnitID="11299556">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/4B/C3/4BC354E7-B067-4F21-8B34-0EEDE9C93495.jpg</Image2>
</images>
<classid/>
<condition>U</condition>
<price>49500</price>
<msrp/>
<accessories>60', single shoot, 7.5" spacing, steel packers, nice condition, set up as rear tank hitch, shedded until this winter</accessories>
<noteshtml/>
<dealername>Example</dealername>
<address>Hwy #2 & Hwy #34, Box 70</address>
<city>Holland</city>
<state>MB</state>
<zipcode>R0G 0X0</zipcode>
<telephone>999-999-9999</telephone>
<email>getquote@example.com</email>
<iscustom>0</iscustom>
<isclearance>0</isclearance>
<isconsignment>0</isconsignment>
<isfeatured>0</isfeatured>
</item>
<item UnitID="11299558" Record="24">
<id>11299558</id>
<dealerid>10356</dealerid>
<make>Massey Ferguson</make>
<model>2956A</model>
<year>2014</year>
<retailprice>0</retailprice>
<clutch>1028198</clutch>
<modifieddate>11/4/2021 1:33:29 AM</modifieddate>
<horsepower>0</horsepower>
<enginehours>0</enginehours>
<airconditioners>0</airconditioners>
<isselfcontained>0</isselfcontained>
<haslevelingjacks>0</haslevelingjacks>
<issalespending>0</issalespending>
<lengthininches>0</lengthininches>
<istoyhauler>0</istoyhauler>
<displayorder>255</displayorder>
<url>http://www.example.com/--xInventoryDetail?id=11299558</url>
<images>
<Image1 image="1" modified="11/4/2021 1:33:29 AM" UnitID="11299558">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/E4/14/E414D931-838E-467D-8196-F167D4A0F6EA.jpg</Image1>
<Image2 image="2" modified="11/4/2021 1:33:29 AM" UnitID="11299558">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/65/F5/65F51CD1-66C0-4224-BBFD-1DF8C91AFD36.jpg</Image2>
<Image3 image="3" modified="11/4/2021 1:33:29 AM" UnitID="11299558">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/66/68/666843A7-884F-49B3-8432-D3046D60400B.jpg</Image3>
<Image4 image="4" modified="11/4/2021 1:33:29 AM" UnitID="11299558">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/98/2B/982BAF08-7EFC-452E-8865-0DDDC0E715CC.jpg</Image4>
</images>
<classid/>
<condition>U</condition>
<price>42900</price>
<msrp/>
<accessories>Fully Automatic, serviced and ready to go</accessories>
<noteshtml/>
<dealername>Example</dealername>
<address>Hwy #2 & Hwy #34, Box 70</address>
<city>Holland</city>
<state>MB</state>
<zipcode>R0G 0X0</zipcode>
<telephone>999-999-9999</telephone>
<email>getquote@example.com</email>
<iscustom>0</iscustom>
<isclearance>0</isclearance>
<isconsignment>0</isconsignment>
<isfeatured>0</isfeatured>
</item>
<item UnitID="11299560" Record="25">
<id>11299560</id>
<dealerid>10356</dealerid>
<make>Massey Ferguson</make>
<model>1375</model>
<year>2013</year>
<retailprice>0</retailprice>
<clutch>1034524</clutch>
<modifieddate>11/4/2021 1:33:29 AM</modifieddate>
<horsepower>0</horsepower>
<enginehours>0</enginehours>
<airconditioners>0</airconditioners>
<isselfcontained>0</isselfcontained>
<haslevelingjacks>0</haslevelingjacks>
<issalespending>0</issalespending>
<lengthininches>0</lengthininches>
<istoyhauler>0</istoyhauler>
<displayorder>255</displayorder>
<url>http://www.example.com/--xInventoryDetail?id=11299560</url>
<images>
<Image1 image="1" modified="11/4/2021 1:33:29 AM" UnitID="11299560">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/53/FE/53FEADA4-2A08-4C0E-AA89-793E0ECDFCBA.jpg</Image1>
<Image2 image="2" modified="11/4/2021 1:33:29 AM" UnitID="11299560">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/B2/40/B240BB86-D695-4F4B-8125-7CCA2CF2D60E.jpg</Image2>
<Image3 image="3" modified="11/4/2021 1:33:29 AM" UnitID="11299560">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/25/B9/25B90B81-D7BE-4BBC-9DFD-31A33A82F3E9.jpg</Image3>
<Image4 image="4" modified="11/4/2021 1:33:29 AM" UnitID="11299560">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/E0/D3/E0D3F2FC-DB74-460F-899E-DD3B2243A047.jpg</Image4>
<Image5 image="5" modified="11/4/2021 1:33:29 AM" UnitID="11299560">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/F6/BD/F6BDE6E6-E9F5-438C-85C6-2B8C752B3950.jpg</Image5>
<Image6 image="6" modified="11/4/2021 1:33:29 AM" UnitID="11299560">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/51/FB/51FB6C2E-F7A1-4C3A-8A28-40AAB5F465A6.jpg</Image6>
</images>
<classid/>
<condition>U</condition>
<price>34900</price>
<msrp/>
<accessories>15', Mint shape, low acres</accessories>
<noteshtml/>
<dealername>Example</dealername>
<address>Hwy #2 & Hwy #34, Box 70</address>
<city>Holland</city>
<state>MB</state>
<zipcode>R0G 0X0</zipcode>
<telephone>999-999-9999</telephone>
<email>getquote@example.com</email>
<iscustom>0</iscustom>
<isclearance>0</isclearance>
<isconsignment>0</isconsignment>
<isfeatured>0</isfeatured>
</item>
<item UnitID="11299563" Record="26">
<id>11299563</id>
<dealerid>10356</dealerid>
<make>Massey Ferguson</make>
<model>8200-35</model>
<year>2010</year>
<retailprice>0</retailprice>
<clutch>955828</clutch>
<modifieddate>11/4/2021 1:33:29 AM</modifieddate>
<horsepower>0</horsepower>
<enginehours>0</enginehours>
<airconditioners>0</airconditioners>
<isselfcontained>0</isselfcontained>
<haslevelingjacks>0</haslevelingjacks>
<issalespending>0</issalespending>
<lengthininches>0</lengthininches>
<istoyhauler>0</istoyhauler>
<displayorder>255</displayorder>
<url>http://www.example.com/--xInventoryDetail?id=11299563</url>
<images>
<Image1 image="1" modified="11/4/2021 1:33:29 AM" UnitID="11299563">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/4A/2B/4A2B28DC-D024-4B08-934A-FB9D5F40D58B.jpg</Image1>
<Image2 image="2" modified="11/4/2021 1:33:29 AM" UnitID="11299563">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/88/E9/88E9F704-1079-42CE-BE59-B9D19E90DD16.jpg</Image2>
<Image3 image="3" modified="11/4/2021 1:33:29 AM" UnitID="11299563">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/14/47/1447B5E4-04AF-44EF-B538-E8E842699630.jpg</Image3>
<Image4 image="4" modified="11/4/2021 1:33:29 AM" UnitID="11299563">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/42/84/4284C6BF-7D39-4DAF-92B3-318BFBF32CD5.jpg</Image4>
</images>
<classid/>
<condition>U</condition>
<price>25900</price>
<msrp/>
<accessories>W/Crary air system, nice shape, 35', fits MF/A series combine, can be adapted to R/S series Gleaners</accessories>
<noteshtml/>
<dealername>Example</dealername>
<address>Hwy #2 & Hwy #34, Box 70</address>
<city>Holland</city>
<state>MB</state>
<zipcode>R0G 0X0</zipcode>
<telephone>999-999-9999</telephone>
<email>getquote@example.com</email>
<iscustom>0</iscustom>
<isclearance>0</isclearance>
<isconsignment>0</isconsignment>
<isfeatured>0</isfeatured>
</item>
<item UnitID="11299564" Record="27">
<id>11299564</id>
<dealerid>10356</dealerid>
<make>Gleaner</make>
<model>R70</model>
<year>1990</year>
<retailprice>0</retailprice>
<clutch>1012857</clutch>
<modifieddate>11/4/2021 1:33:29 AM</modifieddate>
<horsepower>270</horsepower>
<enginehours>3460</enginehours>
<airconditioners>0</airconditioners>
<isselfcontained>0</isselfcontained>
<haslevelingjacks>0</haslevelingjacks>
<issalespending>0</issalespending>
<lengthininches>0</lengthininches>
<istoyhauler>0</istoyhauler>
<displayorder>255</displayorder>
<url>http://www.example.com/--xInventoryDetail?id=11299564</url>
<images>
<Image1 image="1" modified="11/4/2021 1:33:29 AM" UnitID="11299564">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/0F/F3/0FF3B133-16E1-4D9C-84CC-CDDC171ED594.jpg</Image1>
<Image2 image="2" modified="11/4/2021 1:33:29 AM" UnitID="11299564">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/55/54/55541A12-4689-4745-9279-5BDE1C6F26B2.jpg</Image2>
<Image3 image="3" modified="11/4/2021 1:33:29 AM" UnitID="11299564">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/F8/5A/F85AAD4A-7DAD-4ACE-AA14-DD3A23B4E398.jpg</Image3>
<Image4 image="4" modified="11/4/2021 1:33:29 AM" UnitID="11299564">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/1C/24/1C24E56F-0A31-4048-9ADB-191D3B381742.jpg</Image4>
<Image5 image="5" modified="11/4/2021 1:33:29 AM" UnitID="11299564">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/A4/55/A455EBDF-9DF4-4C65-9E04-582F43886832.jpg</Image5>
<Image6 image="6" modified="11/4/2021 1:33:29 AM" UnitID="11299564">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/E6/B5/E6B56CB5-E854-422E-BF95-BF0054A6445D.jpg</Image6>
<Image7 image="7" modified="11/4/2021 1:33:29 AM" UnitID="11299564">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/14/9F/149F46DB-D2D2-4C97-A408-A9A1B2F2F0E9.jpg</Image7>
<Image8 image="8" modified="11/4/2021 1:33:29 AM" UnitID="11299564">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/06/A7/06A74474-7CE6-4E0C-A14A-C206DBB68CE7.jpg</Image8>
<Image9 image="9" modified="11/4/2021 1:33:29 AM" UnitID="11299564">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/B6/19/B61946CD-D84B-406F-9629-6E371D2A47FD.jpg</Image9>
<Image10 image="10" modified="11/4/2021 1:33:29 AM" UnitID="11299564">https://cdn.example.com/imglib/v1/1024x1024/imglib/Assets/Inventory/99/7A/997ABD2D-283A-42A2-882E-6824D11E9D3B.jpg</Image10>
</images>
<classid/>
<condition>U</condition>
<price>18900</price>
<msrp/>
<accessories>w/960-25' Macdon hdr/adapter, nice unit, well maintained, pickup hdr available</accessories>
<noteshtml/>
<dealername>Example</dealername>
<address>Hwy #2 & Hwy #34, Box 70</address>
<city>Holland</city>
<state>MB</state>
<zipcode>R0G 0X0</zipcode>
<telephone>999-999-9999</telephone>
<email>getquote@example.com</email>
<iscustom>0</iscustom>
<isclearance>0</isclearance>
<isconsignment>0</isconsignment>
<isfeatured>0</isfeatured>
</item>
</inventory>