I'd like to know how I can get list of all the documents located in 'My Personal Documents' folder. For other folders I can write something like this:
SELECT Id, Name FROM Document WHERE FolderId =: myFolderId
The problem is that I can't find out id of 'My Personal Documents' folder. Simple queries like the following doesn't help too:
SELECT Id FROM Folder WHERE Name = 'My Personal Documents'