Forum Discussion

DylanGeorgeFiel's avatar
DylanGeorgeFiel
Helper
9 years ago

API returing different results from API V1/V2 and Studio

Hello,   I'm new to lithium,   I'm running the following queries from V1, V2 - SELECT count(*) FROM messages   restadmin('/metrics/name/net_overall_posts?js_string') These are returning t...
  • VarunGrazitti's avatar
    VarunGrazitti
    9 years ago
    Could be a reason, why don't you compare a normal V1 /posts/count call with this V2 instead of metrics call and see how it works.
  • DylanGeorgeFiel's avatar
    DylanGeorgeFiel
    Helper
    9 years ago

     I do not have sufficient privileges for this resource or its parent to perform this action.

     

    I've verified my account.

     

    Edit: I tried /metrics/name/overall_posts and it's giving me 304 posts?

    • VarunGrazitti's avatar
      VarunGrazitti
      Boss
      9 years ago

      DylanGeorgeFiel - ok, here is what document says:

       

      overall_posts: The overall number of posts, across all types of discussions (forums, blogs,etc.)
      net_overall_posts: The overall number of posts minus deleted posts, across all types ofdiscussions (forums, blogs, etc.)

       

      • DylanGeorgeFiel's avatar
        DylanGeorgeFiel
        Helper
        9 years ago

        That explains the increase in numbers from net_overall_posts and overall_posts is the deletions.

         

        It doesn't explain why the LiQL statement "SELECT count(*) FROM messages" differs by 10 or so posts from net_overall_posts.

         

        I noticed that the query originates from 'metrics', does this have something to do with it? Is the difference from hidden posts or something?