URL and GUID values from Feed import

Question

When you import RSS items via Feeds, where are the URL and GUID target values stored in the node? How do you get these out? I am not seeing anything close to these when I dump the $node.

This shows the Mappings screen with the values that I am talking about:

Answer 1

They are stored in the feeds_item table in the database. They are used by the feeds module to control updates of imported items.

Answer 2

Use feeds_item_info_load() to get the feed item object, eg:

$fii = feeds_item_info_load('node', $node->nid);

Answer 3

I had the same problem .. I use a db_query to retrieve the source

if you need to load information from feed_items then use feeds_item_info_load. However I need to load the source URL, and so far I havent found anything to do that. With the dbase query below you can retrieve the source feed.

$key = 'www.somefeed.com';
$result = db_query('SELECT feed_nid from feeds_source where source = :source', array(':source'=>$key ));

foreach ($result as $record) {
    $feed_nid[] = $record;
    }