0

How can I select unread messages from 'Inbox'?

I'm looking for a way to fetch only unread messages from a users 'Inbox'.

Is this possible to do by using select with YQL?

So far, every query I try returns every single message in the users 'Inbox'.
e.g.
select * from ymail.messages where numMid='3'
select * from ymail.messages limit 10
select * from ymail.messages where messageInfo.flags.isRead='0'

Thanks,
  Johnny

by
1 Reply
  • SELECT * FROM ymail.msgcontent WHERE (fid,mids) IN (SELECT folder.folderInfo.fid,mid FROM ymail.messages where messageInfo.flags.isRead=0 ) AND fid='Inbox'

    0

Recent Posts

in Yahoo! Mail Web Services API