User Profile

VikasB

Boss

Joined 9 years ago

746 Posts623 Likes153 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.
4 months ago Place Developer Discussion
184Views
1like
3Comments
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
4 months ago Place Developer Discussion
275Views
2likes
0Comments
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
4 months ago Place Developer Discussion
314Views
1like
1Comment
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
4 months ago Place Developer Discussion
326Views
0likes
0Comments
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.
4 months ago Place Developer Discussion
158Views
2likes
0Comments
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.
4 months ago Place Developer Discussion
160Views
2likes
1Comment
Re: Community API
Jk07 This document can be helpful for you https://developer.khoros.com/khoroscommunitydevdocs/reference/khoros-communities-platform-apis
10 months ago Place Developer Discussion
223Views
1like
1Comment
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.
11 months ago Place Developer Discussion
131Views
0likes
0Comments
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.
11 months ago Place Developer Discussion
133Views
0likes
2Comments
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
12 months ago Place Developer Discussion
152Views
2likes
0Comments