HelpSpot Help Desk Software | HelpSpot Blog | HelpSpot Support

Include top-rated articles on a non-helpspot page?


#1

In our current help system (an in-house solution), we include the top 10 rated help articles on the front page of our site. I was wondering if Helpspot has an option to display the top-rated articles on pages that aren’t part of the Helpspot install. I saw that the API will let you up or downvote an article, but I didn’t see a method to list articles by rating.

Is anyone doing something like this now? I’d appreciate any advice you can provide!


#2

Hi Helen,

You can’t directly get that via the API currently, but you could use this SQL to get the pages ordered by highest voted:

SELECT * FROM HS_KB_Pages ORDER BY iHelpful DESC