Forum Discussion

DylanGeorgeFiel's avatar
DylanGeorgeFiel
Helper
10 years ago
Solved

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 the following:

- 177 and 162

 

What is the difference between these two calls? Thanks,

 

Edit: When I create a new thread or reply, they both increment by one. I'll also add that when using the API Browser and calling the method I get 180. Which is different from the first query I'm making with a URL?

  • VarunGrazitti's avatar
    VarunGrazitti
    10 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.

8 Replies

Sort By
  • DylanGeorgeFiel's avatar
    DylanGeorgeFiel
    Helper
    10 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
    10 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
    10 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?

     

  • VarunGrazitti's avatar
    VarunGrazitti
    Boss
    10 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
    10 years ago

    I couldn't find a reference to /posts/count.

     

    That did the trick to the calls returning the same value.

     

    However, the reason why they're different remains a mystery.

     

    Edit: The values differ depending on whether you're logged in or not as an admin. I'm unsure what the posts are.

  • VarunGrazitti's avatar
    VarunGrazitti
    Boss
    10 years ago
    DylanGeorgeFiel - The results would always vary in logged in and logged out case if you are making the REST call as rest("your_rest_call")

    It is because the REST call would respect all the permissions and not fetch the results which require login.

    If you were making the call as restadmin("your_rest_call"), it will fetch same results irrespective of login or logout.

    I hope this helps and clears the doubt you have.
  • Claudius's avatar
    Claudius
    Boss
    10 years ago
    The additional posts are likely to be in internal areas like abuse report, filter notices or internal moderation boards that are only accessible to moderators or admins.