bulk data api

43 Topics

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!
Danzidpp
2 months ago Place Developer Discussion
1.1KViews
0likes
2Comments
The total number of views in bulk data table doesn't match the views display in community,
Hello all, I have a question, I search all the action keys of an article from the bulk data API table, Gives this result: ACTION_KEY COUNT(KHO.ACTION_KEY) moderation.mark-unread 1 visits.member-entrance 15 moderation.mark-read 1 messages.edit 1 view 57 visits.visit-summary 24 total counts is: 99 for all actions, and the view is 57, but the views display 181 in community. why the number of views in database doesn't match the views display in community, the difference between these two numbers is so significant. any idea?
shong88
5 months ago Place Developer Discussion
900Views
0likes
4Comments
As far as anyone knows is there a way to transfer posts, etc., from PROD to STAGE
Has anyone come up with a script to do this? Querying Production and Posting to stage with either curl or the API? It would just be nice to be able to populate more and more realistic content on the Stage instance. Or even just to post articles programmatically? There's the REST API https://developer.khoros.com/khoroscommunitydevdocs/reference/rest But I don't see where the body of the messagePostBody goes. Example: POST (Create): <#assign subject = http.request.parameters.name.get("subject", "") /> <#if subject?length gt 0> <#-- Build the requestBody parameter and assign it to a variable--> <#assign messagePostBody = { "type": "message", "subject": subject, "board": { "type": "board", "id": "Otis" } } /> <#-- Make your REST call --> <#assign resp = rest("2.0", "/messages", "POST", messagePostBody) /> ${apiv2.toJson(resp)} <#else> { "status": "error", "message": "no subject parameter passed." } </#if> Do I just add a "body" member property to that messagePostBody with whatever the body of the message is? Or is there some esoteric way of doing it? For the example given, PUT: <#assign messagePostBody = { "type": "message", "id": "34", "subject": "How do I post a REST API message?" } /> There's a subject, a type, an id, but no body. How do I add body content? Or do I have to use cURL as noted here in "recipes"? Does one need to authenticate using cURL? Can it be done within components? A lot of this seems vague. There's not a lot of context I can find. Most recipes have instructions for what to do with the ingredients ... https://developer.khoros.com/khoroscommunitydevdocs/recipes/create-a-new-message-with-products Do we run this in Freemarker? How? Do we create a component? Do we use authentication? How? In a terminal? With a fox? In a box? With green eggs and ham? 😉 This would be very helpful information. These "recipes" assume a lot of knowledge about how to use cURL within the Khoros Community that isn't provided. I would love to run this in a component. But there's no information nearby that explains that. Please clarify? A lot? Complete examples in the context of the Community product would make all the difference. curl --request POST \ --url https://community-domain/api/2.0/messages \ --header 'Accept: application/json' \ --header 'Content-Type: application/json' { "data": { "type": "message", "board": { "id": "runningShoes" }, "subject": "Alternative to Nike Revolution Running Shoes", "body": "I have the Nike Revolution Shoes and got the Reebok Protonium shoes, but it feels very stiff while running - not much comfort/cushion while running and uncomfortable. I originally switched to Saucony because it was very comfortable and lightweight. suggestions for Saucony running shoes for women? I run only about 10mi/wk. <li-image id=\"336i254DB2339\"/>", "tags": { "items": [ { "text": "trail running" }, { "text": "running shoes" } ] }, "labels": { "items": [ { "id": "RunningShoes", "text": "Running Shoes" }, { "id": "Suggestions", "text": "Suggestions" } ] }, "products": { "items": [ { "id": "54" }, { "id": "56" } ], "list_item_type": "product" } } } Thanks, just rather unclear on the documentation around this.
Solved
isxtn
2 years ago Place Developer Discussion
826Views
0likes
13Comments
Need Help Finding Khoros API for Usage Data
Hi there, I’m new to Khoros and trying to set up a simple dashboard to track usage data like Unique Visitors per Month, Total Visitors, Net Topics per Month, Accepted Solution Views, Page Views, and so on. I’ve been looking around but can’t seem to find the right API endpoint or documentation for this kind of data. Any help to get this data is really appreciated! Thanks a lot for your help! Best, Danzi
Solved
Danzidpp
10 months ago Place Developer Discussion
799Views
0likes
3Comments
Particular action key in Bulk Data API (v 3.0)
I want to bring only "users.registration" type of action key events using Bulk Data API (v 3.0). Can we achieve this in any way by modifying the api url. Any help is appreciated. Thanks in advance. Thanks, Aishwarya
AishwaryaEA
1 year ago Place Developer Discussion
799Views
0likes
6Comments
Can somebody help me with session keys?
Hello, We'd like to connect one of our group hub with our Power BI report. We'd like to see the list of users synched automatically (it's a hidden group hub, and whoever joins the group grabs a license automatically to our beta software too). So far it seems that Bulk API was not really helpful with that, but Search API would be a great fit. However, this is where we have our problem - it requires a session key, that we don't know how to get. We use SSO on our site (SAML), and I can't seem to find anything useful in the documentation (https://developer.khoros.com/khoroscommunitydevdocs/docs/search-api-overview)... Can somebody help me how to make this work? We're running on Classic currently. Thanks, Noémi
nbalogh
7 months ago Place Developer Discussion
700Views
0likes
1Comment
LithiumVisitor decryption & bulk API visit id access
Hi all, I would greatly appreciate any insight into a few questions I have surrounding both visitor cookies and a property exposed via the bulk data API: How can I decrypt the LithiumVisitor cookie in order to access the underlying “visitor.id” value? I'm looking to gather some metrics on un-authenticated users. My understanding with visit.id (available via bulk data API) is getting generated internally, do I have access to it anywhere on the client side? Is it only generated for authenticated users? Thanks
chadwhyte
4 years ago Place Developer Discussion
700Views
2likes
9Comments
Non Spam Posts for a given time frame
I'm trying to retrieve the number of non-spam posts within a specific timeframe from my database. What should the query be in this case?
CarlaA
11 months ago Place Developer Discussion
699Views
0likes
2Comments
list of all users subscribed to all board
I am using the below api to find the users permitted to a particular board: https://[COMMUNITY DOMAIN]/restapi/vc/boards/id/<board ID>/subscribers/email/board But the problem with above api and my use case is that I want to view the list of all the boards and its permitted users in one request. Whereas, the above api is only allowing to look for only a single board at a time. Is there a way in which I can get the list of all the boards in a community and it's subscribed users in a single hit?
Anonymous0909
3 years ago Place Developer Discussion
699Views
0likes
2Comments
Bulk Data API - new user questions
Hi, we have just started using the Bulk Data API to get data from production and our team have a couple of questions that hopefully are simple to answer. We can't find the answers in the docs or here so sorry if these are covered somewhere else. 1. fromDate and toDate is what we’re using to fetch the data. Just not entirely sure if it maps to the timestamp of event.time.ms or if it’s another timestamp (i.e. when event was processed, when event was made available for export, etc). 2. Does this endpoint paginate results in any way or is it always one giant dump? Thanks!
Solved
elbranscomb
3 years ago Place Developer Discussion
569Views
0likes
7Comments