Skip to main content

Basically, I’m putting together an ‘end of year’ review for each user, and I’d like to include a statistic like “You had x replies marked as the best answer in this year”.

If I query the questions with the API, I can see when a question has a best answer ("bestAnswer": true) but I’m struggling to find a way to determine which answer that is or which user’s reply earned that best answer. The List/Fetch Replies endpoints don’t seem to return that info.

Is there perhaps another method?

Can the Unified Content query search for that? Or can the User API return a count of the best answers (“solved”: x) for a particular time period?

Any suggestions appreciated.

 

In case it’s of interest, here’s what I created so far. I can count best answers given, but not received:

 

Use the API for GET user instead. However, if you need it to be within a date range, that won’t work. It gives you current total. 
 

the best solution for your use case is to use the export for marked answers. You can filter the initial export to answers marked within the time period. From there you can get the data you need via a pivot table. 


the best solution for your use case is to use the export for marked answers. You can filter the initial export to answers marked within the time period. From there you can get the data you need via a pivot table. 

 

Awesome! I didn’t think of that. Since I’m prepping the data and not doing a live analysis, export works perfectly. 


Reply