bob-mccormick
Mentor
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: How can I list and count ALL bookmarks in the system?
Thank you saikumarn. This will work, but it is a very inefficient solution. I have over 300,000 users, and many of them do not have bookmarks (I assume). There should be a way to just list all bookmarks (using cursors). Or, list bookmarks in blocks of users (where subscriber.id >= 1 and subscriber.id <= 10000). If that is not the case, then the documentation should be updated to make it clear that the default is bookmarks for current user. More actual examples would help. At my company, we do our API work with 2 shared credential, one for read-only work and one with full admin rights. These accounts would not have bookmarks, so it comes up empty.285Views1like0CommentsHow can I list and count ALL bookmarks in the system?
I have been asked to analyze bookmarks, to determine such things as How many users make use of the bookmark feature in Khoros? What is the maximum number of bookmarks for a user? What is the average number of bookmarks for users with bookmarks? To do this, I would normally use LiQL v2 API to do {{prod}}/api/2.0/search?q=select count(*) from bookmarks however this always returns 0! If I add a where clause for a user such as {{prod}}/api/2.0/search?q=select * from bookmarks where subscriber.id = '5375' it works fine. But I have 500k users so I am don't want to do it that way. The filter by target.type does not work either. I am logged in as Admin user. Any help would be appreciated.Solved350Views1like3CommentsRe: Which Bulk Data API fields go with each event type?
Thank you Sudhakara! I actually think it would not be too difficult to document. Make a spreadsheet/table with one row per field. Make a column for each event type. Put an X in the intersection of event type and field if that field is in that event. But I will enter a support case to get a better sample. The existing sample is from V1 I think, and only includes 4 event types.133Views0likes0CommentsHow to use queries with Bulk Data API?
In https://community.khoros.com/t5/Community-Analytics/Requesting-essential-community-metrics-via-the-Bulk-Data-API/ta-p/615803, it shows using SELECT statements with Bulk Data API. How do you specify these queries in an API call? Or are these supposed to be theoretical queries against the data received from Bulk Data API, after they are stored in a database?Solved230Views0likes1CommentNeed better example of Bulk Data API
I see the example CSV file for Bulk Data API, but it only has a few event types (rss.feed-request, view, visits.member-entrance, visits.visit-summary). Can Khoros supply a more complete example, ideally with one of each event type represented, and the new V2 fields.Solved315Views0likes3CommentsWhich Bulk Data API fields go with each event type?
I am designing a data extract from Khoros Community into our company data warehouse. In looking at the Bulk Data API V2, I see a lot of great events that I want to capture. Is there a mapping that shows which field are supplied for each event type? For example, when a message (new thread) is created in a discussion board, I need to know which fields are in the Bulk Data API event. Most likely, I will need additional fields, so I would invoke a Community API request to get those additional fields. However, a simple event like badges.award may contain all the info that I need in the bulk data event (timestamp, user, badge). Our Community site is not up yet, so I cannot check this on a live site.152Views0likes2Comments