This is a lab with YQL and open tables, i have used a Open Table at github: http://github.com/jorkas/yql-tables/raw/master/mynewsdesk/mynewsdesk.channel.list.xml that wraps the MyNewsdesk Partner API for Channels with the following query.
use "http://github.com/jorkas/yql-tables/raw/master/mynewsdesk/mynewsdesk.channel.list.xml" as channels;
select pressroom_name, header, summary, body, url, published_at from channels
where type_of_media="pressreleases"
and api_key="API_Key"
and channel_id="Channel_Id"
and limit=3;
The lab was made by Joakim Westerlund during a LabDay at MyNewsdesk
More at my profile at GitHub (Jorkas)
Back to Joakim Westerlund home