Hi, I'm using what is otherwise the standard Sharepoint on Office365, and while I can write a CAML query that pulls the information using the CAML Query helper tool, it doesn't seem to work when the query is put into the CAML query box. The CAML query box has no room for carriage returns either, apparently.
Here is an example I put together that works in the CAML query helper, but when I flatten it (remove CR), it causes a 77777 error.
<OrderBy><FieldRef Name="Modified" Ascending="FALSE"></FieldRef></OrderBy>
<Where>
<BeginsWith>
<FieldRef Name='ContentTypeId' />
<Value Type='ContentTypeId'>0x0120</Value>
</BeginsWith>
</Where>
<ViewFields><FieldRef Name="FileLeafRef" /></ViewFields>
Scope="RecursiveAll"