Forum Discussion

citizenelah's avatar
citizenelah
Ace
5 months ago

API for newly published articles?

I'd like to automate social copy drafts in our social media platform for newly published articles. I can't seem to find the right combination of attributes / tables in a LiQL call OR the right API me...
  • citizenelah's avatar
    citizenelah
    5 months ago

    I got it! Had to combine post_time AND manual_sort to get the results to match my latest published article:

    query = "SELECT id, view_href, body, last_publish_time FROM messages WHERE board.id = 'TechnicalArticles' ORDER BY manual_sort, post_time desc limit 10"

     

    Thanks karuna179 for the nudge and the help with post_time!

citizenelah's avatar
citizenelah
Ace
5 months ago

I got it! Had to combine post_time AND manual_sort to get the results to match my latest published article:

query = "SELECT id, view_href, body, last_publish_time FROM messages WHERE board.id = 'TechnicalArticles' ORDER BY manual_sort, post_time desc limit 10"

 

Thanks karuna179 for the nudge and the help with post_time!

  • karuna179's avatar
    karuna179
    Expert
    5 months ago

    citizenelah   I'm glad the combination worked out and you were able to get results. ğŸ™‚