Hi,
I'm trying to read XML documents from the UK Public Procurement Notices using the Utility - XML object from the Blue Prism website
example link to the XML docs https://data.gov.uk/dataset/63917d4...97ce7a/uk-public-procurement-notices-may-2021
I can get it to read file into a data object but from there I'm struggling to use any of the pages to get the headers and data I need.
What I would like is for each document within that notices folder to be written to a collection or something I can create a spreadsheet with. Has anyone got any experience doing this or guidance they can give me?
I'm trying to read XML documents from the UK Public Procurement Notices using the Utility - XML object from the Blue Prism website
example link to the XML docs https://data.gov.uk/dataset/63917d4...97ce7a/uk-public-procurement-notices-may-2021
I can get it to read file into a data object but from there I'm struggling to use any of the pages to get the headers and data I need.
What I would like is for each document within that notices folder to be written to a collection or something I can create a spreadsheet with. Has anyone got any experience doing this or guidance they can give me?