API request

Hello,

 

We want to be able to bring the consolidated data from the three main sections (Traffic, Members and Content) but we could not find a direct API call that could give us this consolidated information that a "user report" direct download would do. Therefore and presently, the only way we found out how to solve this are either bringing each sub-section separately, (Blogs, Ideas Exchange, etc.) or build a single JSON per Board ID but with everything. Nonetheless, while the first potential solution is not practical (there are too many subsections to bring to eventually generate the consolidated view), the second solution assumes that the source data remains "static" and thus can represent a potential thread to data load sustainability if source data changes from a "pivot" point of view. In summary, while the first approach (bringing every subsection through the BulkAPI) conveys creating multiple (a lot!) modules in our internal Data Hubs and it is not efficient at all, the second approach (JSON files and Board ID) involves keeping the source data "static" forever (subsections) to eventually be able to create the consolidated (main section) aggregates from Khoros. Consequently, we want to ask if there is a way to get exposure via an API to the consolidated data in each of the 3 main sections (Traffic, Members and Content).

 

Additionally, while trying to bring all the data from the Users (details such as name, type, login, rank, etc) and other metrics (kudos given / received, articles published, messages/comments given etc.), we encountered the following issue: The users data from Khoros API does not yield all these numbers directly. For example, for every user its metrics column will have a unique query attached to it. So, in order to get number of X or Y or Z metric, we need to execute a query for each user for each of these columns back to Khoros API, making it unpractical. To put some numbers, if we had 100K users in our Community, we would need to call the respective queries 100K times per column. Impossible. Since we have a user report section in the Community Admin section that allows us to get all these users' numbers and metrics, I am assuming that Khoros might have a simpler way of getting all these records without running so many API calls. Is this possible? In a way, the request is very similar to the one from the previous question.

 

Thanks for any help provided!