ContributionsMost RecentMost LikesSolutionsRe: message id questionOne should be a topic/thread(root message) id. And second one should be the message/reply(child messages) id. Both ids are stored in message table. Re: query with date field softech API does not support "solution_data.time" as a constraint(for Where clouse as well as for Order By). If you only want to get the first and last message id for the month, you can use below queries - select id from messages where post_time>=2024-04-01T00:00:00.000-00:00 and post_time <= 2024-05-01T23:59:59.999-00:00 Order by post_time ASC limit 1 select id from messages where post_time>=2024-04-01T00:00:00.000-00:00 and post_time <= 2024-05-01T23:59:59.999-00:00 Order by post_time DESC limit 1 Re: query with date field softech Max and min is not allowed. Can you please clarify what do you want to achieve by using max and min. If you want to get the maximum number of messages in single query then you have to use limit. By default it returns 25 results. select id from messages where post_time>=2024-04-01T00:00:00.000-00:00 and post_time <= 2024-05-01T23:59:59.999-00:00 limit 999 For next batch, you have to pass the offset as below select id from messages where post_time>=2024-04-01T00:00:00.000-00:00 and post_time <= 2024-05-01T23:59:59.999-00:00 limit 999 offset 1 Re: query with date field softech Here you go - community.YourCommunity.com/api/2.0/search?q=select * from messages where post_time > 2019-07-01T00:00:00.000-00:00 and post_time < 2019-07-31T23:59:59.999-00:00 Re: Block New Replies - API? ccanada To achieve this, you have to create a dedicated component for the topic page. Within this component, you have to implement the logic to determine if the thread meets certain criteria. If it does, dynamically apply the necessary CSS to hide the Add Comment section. Re: Block New Replies - API? ccanada On load of topic page, you can remove the Add Comment section using CSS if that perticular thread have reached upto the defined parameter/threshold. Re: Community API Jk07 This document can be helpful for you https://developer.khoros.com/khoroscommunitydevdocs/reference/khoros-communities-platform-apis Re: API Quota usage calculation enrouteto You can access your billing details by navigating to Community Analytics > Billing. If you require access to documentation or need to enable the Billing feature, please submit a support ticket to our support team at support@khoros.com. If you find that the documentation doesn't resolve your issue, you should contact your Customer Success Manager (CSM) at Khoros for further assistance. Re: API Quota usage calculation enrouteto You can go through the below docs for more understanding about billing https://community.khoros.com/t5/Khoros-Communities-Blog/Billing-Metrics-in-Community-Analytics/ba-p/632520 https://community.khoros.com/t5/Community-Analytics/Community-Billing-metrics/ta-p/614514 Note:You can contact the Support team to request for the feature activation in case you are not able to see the Billing tab under Community Analytics. Re: Where to find Community Alpanumeric ID in Admin? or...? isxtn I am not sure why you need this id for V1 API. You just need to append "/restapi/vc/whatever" to the community base URL. You can try this query - https://community.khoros.com/restapi/vc/categories