Help identifying XML fields for message attributes in Khoros data export
I'm working on a project where I need to parse and process a Khoros XML data export of my community, and I'm trying to map out the right entities and fields for several message-level attributes. Specifically, I'm trying to figure out which XML files, entities, and fields correspond to the following: Visibility scope of a message i.e how can I tell a message is private, draft or archived (API Reference) Whether the message is a solution and solution is marked by which user / user_id and when (time) (API Reference) Whether the message is read only or has comments blocked (API Reference) Moderation status - whether the message was rejected, approved etc (API Reference) Kudos - How can I find the kudos count and individual kudo for a message e.g user, time and weight info (API Reference) similarly, where is the MeToo data stored for a message? (API Reference) Any help with field names, entity references, look in would be a huge help.24Views
Sign in to react to this post0Comments
Which entity to refer for knowing user to badge mapping in XML data dump
I'm working with XML data dump of my community and I'm able to access users and badge data individually. However, I'm unable to parse user to badge mapping i.e what all badges a specific user has been assigned Which entity or relation I should look for in the XML data dump to get that mapping or help me with any XML data dump related documentation if any86Views
Sign in to react to this post1Comment
How to parse <li-answer> <li-table> custom li tags into raw html
I was playing around with XML data dump of messages, and found custom HTML tags (<li-{type}> in the message content. From Khoros API (LiQL), I'm getting transformed HTML content, without any custom lithium HTML tags Tags example - li-answer, li-code, li-emoji, li-code, li-video, li-image etc How to parse such tags, and get content HTML like it is provided in the API using LiQL ?93Views
Sign in to react to this post1Comment
Dashboard Data Not Matching Reports — Need Help
Hi everyone, I’m trying to pull dashboard data, pageViews, visits, uniqueVisitors, etc. but the numbers I’m getting aren’t matching. I’m really new to this and trying to get the data for reporting, and I’ve been stuck for a few months. I tried the Bulk API, but the numbers came out really low. So I decided to download the report from Analytics instead. Dashboard Report Can anyone explain why the dashboard numbers don’t match the report? Is anyone using a different method to get this data? I’m trying to bring everything into Power BI. Can I get this data using Aurora GraphQL API? Thanks!1.3KViews
Sign in to react to this post2Comments
Subscriptions to a label?
Hi all, I'm attempting to get the list of people who have subscribed to a label, but am struggling. The documentation is a bit confusing: It says both that you have to use a community ID as the node.id constraint but also that you can give the node.id constraint as a board id? Seems conflicting. And, regardless of the documentation, I get an error when I try to use a board ID (such as node.id='board:wireless-lan' where wireless-lan is the id of the board) My user has full admin permissions. Any ideas? I am not really a developer (as is probably evident!), just trying to pull a few bits of data for a stakeholder. Thanks!Solved2.6KViews
Sign in to react to this post9Comments
I have been playing around for half an hour now and also only get subscriptions for the current user :( The target.id param seems to be always causing an error and therefor going against how it's documented even though it is returned in the resultset.
Sign in to react to this post
Contraint conversationlastpostime in Api graphql getmessages does not work
Hi everyone, Has anyone here ever tried using the messages API with the conversationLastPostTime constraint? In my case, the constraint is completely ignored — it doesn’t seem to have any effect at all. What I’d like to do is retrieve only the conversations starting from a certain date limit. But no matter what value I pass to conversationLastPostTime.gte, the results I get are not filtered by date. Has anyone else faced this issue, and did you find a workaround or a proper way to make this constraint work? Here’s the GraphQL body I’m using: Thanks a lot for your help479Views
Sign in to react to this post0Comments
Classic: setting (and uploading) a user avatar through the API
Hey folks, The docs aren't very clear on how to actually upload a user avatar on Classic. I think I have to upload an image to an album and then link to that image from the userprofile endpoint, but the steps are unclear. Which album? How do I tell it which album? The reason: I have a whole bunch of old migrated avatars that are http endpoints. Many of the users with those avatars were very active but are no longer with us. Our SEO team says we should update them to https to eliminate mixed http/https. Seems like an easy one-off script, but I don't see the right set of incantations. Any pointers? I'll be doing this in python with an AI copilot if that helps (I'm a rusty developer). Thanks!440Views
Sign in to react to this post0Comments
Freezing Kudos on a Topic on Classic
Hi all, Is there a way via either rest v1 or v2 (preferably the latter) to freeze the kudos for a given topic? I see that I can make a topic read only, but don't seen an obvious way to disable kudoing. Not sure if this is possible, but given gaps in the docs, I'm hoping that it's doable but that the field to update is not available with a select * query in the API browser. Thanks!1KViews
Sign in to react to this post2Comments
Date Limit in Bulk API v2 and Error with 7-Day Intervals
Hey everyone, I have a quick question about the Date Limit in Bulk API v2. I'm trying to pull data for the last 24 months, but I found that Khoros seems to have a date limitation. Is it true that you can only pull data for either 7 days or 30 days at a time? I think I can only pull data for 7 days—any chance we can change it to 30 days? Another issue I'm running into is when I try to loop through the 7-day intervals for the past 24 months, I get this error: "Error DataSource.Error: Web.Contents failed to get contents from 'https://api.lithium.com/lsi-data/v1/data/export/community/logrhythm.prod?fromDate=20230401&toDate=20230430' (400): Bad Request" Can anyone share how you worked around the date limitation? I was looking at the API documentation, but didn’t find much that helped. Thanks!408Views
Sign in to react to this post0Comments
Tracking Complete Registrations in Google Analytics (via GTM)
Hi, Is there some sort of click listener or event that can be passed in the front end that can be picked up by Google Tag Manager when a user completes their registration (after successfully submitting their username)? Can we apply an event to the complete registration toast? If so, what is the best way to do this? Is there another way that we can track complete registrations in Google Analytics? Thanks!373Views
Sign in to react to this post0Comments