leeclemmer
Guide
Joined 5 years ago
User Profile
User Widgets
Contributions
How to retrieve "Internal reason for ban" field
Hi all, We are looking to extract some data from the "User bans" report in the (Classic) Community Admin interface, under "Mod Tools" > "User bans". When we go click on "Edit" on a particular user, we see the field "Internal Reason for ban;" how can we get a full list of banned users including the reason for ban? Is that field available via API somehow? I wasn't able to find anything. Thanks for any help, LeeSolvedHow can I get subscription counts of Products?
Hi all, When a user is on a Product page, they have the option to subscribe to that Product. I'm simply trying to get a count of how many users have subscribed to a given Product. Is this possible? If so, how? I've found the subscription API, but it only ever returns subscriptions for me, not for all users. In the Community API v1 I've also found how to get subscription stats for Boards, but it appears that that endpoint is missing for Products. Subscriptions to Products events are also not part of the Bulk Data API. Am I missing something? Thanks for any info, Lee169Views0likes3CommentsHow to get a list of deleted messages?
Hi there, I've looked through the documentation and forums and think I have my answer, but I want to double-check. I'm trying to keep a list of messages on Khoros by periodically pulling the latest via LiQL queries. However, I'm starting to have messages that were subsequently deleted, and I haven't been able to find a way to get a list of deleted messages - is this possible? A flag to put into the LIQL statement contraint like "deleted=True" or something would be great. Thanks for any help, LeeSolved201Views0likes3CommentsDoes moving content update any date field?
Hi there, I'm looking to use the API to get a list of root messages from the platform (depth=0). However there are a lot of messages (nearly 3m) so getting a full inventory every time is impractical; what I'm looking to do is get an initial full list and then update that list with a delta of messages that have been either created since the last pull or edited somehow. The field that I've been using to pull the delta is conversation.last_posting_activity_time. However, it now appears that I've got a bunch of content showing the wrong board, because when moving a message from one board to the next that particular date field is not updated. Question: is there any date field that gets updated when a message is moved? Or put differently: how could I get a list of messages that have been moved from one board to another since a given timestamp? Thanks for any help! Edit: PS: it would be helpful to spell out on this page what exactly updates the last_publish_time field: does updating a product assocation/user tag/label attached to the message update this field? How about moving the message to a different board? The reason I went with conversation.last_posting_activity_time is that it is the more recent of: the last post time (equivalent to the conversation.last_post_time constraint) the last time the topic message was published (the last time a non-draft edit was made) Which means I can also use it to update some summary metrics attached to a message (e.g. reply count). So, does moving a message not count as a "non-draft edit"? It should, shouldn't it?Solved195Views0likes2Comments