YQL - Messages and Folder Join Issue when folder name has non alphanumerics
I am using the mail table set in YQL and noticing a strange issue that seems to be the result of how the fid is URL encoded.
Here is the select that I am performing.
select messageInfo.receivedDate, messageInfo.mid, folder.folderInfo.fid from ymail.messages where fid in (select folder.folderInfo.fid from ymail.folders where folder.total > 0)
Normally, this works just fine. But if I have created a folder in Yahoo that is anything but alphanumeric - for instance I make a folder named "Test 1" (no quotes) - then the messages in that folder are excluded from the result set. My guess is that this is a result of how the actual fid on the folder gets url encoded to "Test%201" when selected.
Is there some way to ensure that this join works even if the folder fid is some form of url encoded name?