Forum Discussion

BHall's avatar
BHall
Leader
8 years ago

TKB article data - helpfulness rating and last updated - how to get it?

Has anyone had success using the API to get a couple key pieces of TKB data - helpfulness rating and last updated date, by article?

 

I know the data is somewhere, just curious on how to use the API to get it, since these two metrics do not seem to be part of LSI or advanced metrics.

 

-Brien

 

  • TariqHussain's avatar
    TariqHussain
    Boss
    8 years ago

    BHall-

     

    Here is an API call to get the last updated date of any TKB article.

    SELECT current_revision.last_edit_time from messages where id = 'tkb_id'

    For the helpfulness of any TKB article, let me know if below API helps.

     http://community.lithium.com/community-name/restapi/vc / messages / id / [id]  / reviews / helpfulness

    Here is the documentation.

    https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv1&leaf-id=Message.reviews#Message.reviews.rating

     

    Give kudos if you find my posts helpful or mark solution if it answers your query

    Tariq

    • darrenSP's avatar
      darrenSP
      Mentor
      8 years ago

      Any ideas why helpfulness call gives me permission denied response?

      • irach15's avatar
        irach15
        Maven
        7 years ago

        same here,

        permissions denied and I'm an Admin :-(

    • BHall's avatar
      BHall
      Leader
      8 years ago

      Thanks TariqHussain!

       

      The first API call makes sense.

       

      for the second url, what am I supposed to be replacing? Obviously [id], but should it be "community.lithium.com" or "community.MYCOMMUNITY.com"?  Is "community-name" the actual name or something else?

       

       

      -Brien

       

      • TariqHussain's avatar
        TariqHussain
        Boss
        8 years ago

        BHall- It should be the base URL of your community e.g (community.MYCOMMUNITY.com).

         

        Give kudos if you find my posts helpful or mark solution if it answers your query

        Tariq