User Profile

VikasB

Boss

Joined 10 years ago

746 Posts624 LikesLikes received153 Solutions

View All Badges

User Widgets

Contributions

Re: message id question
One 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.
2 years ago Place Developer Discussion
Views
Sign in to react to this post
Comments
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
2 years ago Place Developer Discussion
Views
Sign in to react to this post
Comments
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
2 years ago Place Developer Discussion
Views
Sign in to react to this post
Comment
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
2 years ago Place Developer Discussion
Views
Sign in to react to this post
Comments
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.
2 years ago Place Developer Discussion
Views
Sign in to react to this post
Comments
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.
2 years ago Place Developer Discussion
Views
Sign in to react to this post
Comment
Re: Community API
Jk07 This document can be helpful for you https://developer.khoros.com/khoroscommunitydevdocs/reference/khoros-communities-platform-apis
2 years ago Place Developer Discussion
Views
Sign in to react to this post
Comment
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 [email protected]. If you find that the documentation doesn't resolve your issue, you should contact your Customer Success Manager (CSM) at Khoros for further assistance.
2 years ago Place Developer Discussion
Views
Sign in to react to this post
Comments
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.
2 years ago Place Developer Discussion
Views
Sign in to react to this post
Comments
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
2 years ago Place Developer Discussion
Views
Sign in to react to this post
Comments