There are multiple topics already on this, but I couldn’t find one that was specific to my rather confusing XML format. I’m ideally looking for a stored procedure to take this XML block and format it into a SQL-friendly table.

Here is what my XML looks like:

I’m getting this from an Archer API and running it through Azure Data Factory into a SQL Server. The SQL output is in a single column:

I have attempted to use Data Flows in Azure, but that doesn’t allow an API data source. I have attempted to use Azure Functions, but my company doesn’t have a subscription for that. I’m open to options, but I think a SQL transformation via stored procedure may be the best bet. Thank you!