Sql_text Data Missing When Querying Extended Event File Target Using TSQL
You're parsing the XML wrong. Since sql_text is an action, you need to do this:
value('(action[@name=&quot;sql_text&quot;]/value)[1]', 'NVARCHAR(MAX)')