I'm working on getting data from the SharePoint list using the RenderListDataAsStream endpoint.
I first get all the views defined for the list and display them in a drop-down menu on the user interface. The user then selects the view
- I get the ListViewXML for this view
- Create a custom filter query like
and then pass this ListViewXML as ViewXML and custom filter as OverrideViewXml in body parameters for the remainder call of RenderListDataAsStream.
From here it says that OverrideViewXml is for
Specifies the overriding XML to be combined with the View CAML. Only applies to the query / where part of the view CAML.
I want to know exactly how OverrideViewXml works in conjunction with ViewXml. If I specify ViewXML, the OverrideViewXml query is ignored or does not work. If I only specify OverrideViewXml and not ViewXml, the OverrideViewXml query works. At the moment there are no results (whether "ANDing" or "ORing") from OverrideViewXml with ViewXML.
For remaining calls I use the PNP JS library (2.0.3) and the solution is in SPFX