Link between feeds and entries

Support requests, bug reports, etc. go here. Dedicated servers / VDS hosting only
Cyanatide
Bear Rating Trainee
Bear Rating Trainee
Posts: 5
Joined: 30 May 2013, 14:29

Link between feeds and entries

Postby Cyanatide » 30 May 2013, 14:38

Hi!
I try to develop a webservice which returns all rss item of a category. So, I create a SQL request with category name in parameter, I get all feed saved under this category. But I can't find a link between table ttrss_feeds and ttrss_entries, so I can't get items corresponding to a specific feed. How does it works on the GUI?
Thanks!

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Link between feeds and entries

Postby fox » 30 May 2013, 14:51

Image

see ttrss_user_entries

jdelamater99
Bear Rating Master
Bear Rating Master
Posts: 109
Joined: 11 Apr 2013, 17:45

Re: Link between feeds and entries

Postby jdelamater99 » 30 May 2013, 15:25

Cyanatide wrote:Hi!
I try to develop a webservice which returns all rss item of a category. So, I create a SQL request with category name in parameter, I get all feed saved under this category. But I can't find a link between table ttrss_feeds and ttrss_entries, so I can't get items corresponding to a specific feed. How does it works on the GUI?
Thanks!


Maybe I'm misunderstanding what you are trying to do, but it sounds like you are trying to recreate the wheel. Why not just use the "View as RSS feed" button?
Captured at 2013-05-30 at 7.21.34 AM.JPEG
Captured at 2013-05-30 at 7.21.34 AM.JPEG (11.11 KiB) Viewed 945 times


I'm probably missing something. I haven't gotten much sleep this week. I think I'm averaging 4hrs a night, so I'm kind of tired.

Cyanatide
Bear Rating Trainee
Bear Rating Trainee
Posts: 5
Joined: 30 May 2013, 14:29

Re: Link between feeds and entries

Postby Cyanatide » 30 May 2013, 17:45

Thanks fox!
jdelamater99, in fact I want keep a RSS stream parsed to ré-insert him in another database.

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Link between feeds and entries

Postby fox » 30 May 2013, 17:59

You can even output feed in JSON instead of RSS which might be easier to parse depending on your service. See the wiki for details.


Return to “Support”

Who is online

Users browsing this forum: No registered users and 9 guests