We had a few scripts running without problems that listed sheet objects using SheetID and Title, that are now returning 0 rows after upgrading to the May 2022 R1 release. I'm assuming there was a metadata change somewhere that we missed the documentation on, but that's just an assumption.
Basic Script, without the extra code:
Load
SheetId,
Title
FROM [myDoc.qvw] (XmlSimple, Table is [DocumentSummary/Sheet]);
Is there an equivalent that we're missing in the latest release? Or is there a place I can dig to possibly find where these fields are now located?