0

Query Category Activity

Hello, I'd like to import the Category Activity from the Reports section directly into Google Sheets (or for that matter, every report that can be exported via CSV), optimally in a 90 day rolling window.

I can already query individual forum topics, but the reports can't be imported via

IMPORTDATA("https://guitar-community.tonebase.co/api/2/metrics/categories?fields=date,period,sectionName,categoryLink,categoryName,all_views,all_posts,all_likes&period=91d&category=community-challenges&categoryType=category&role=&sort=all_views&limit=750&output=csv") 

It gives the "Could not fetch url" error, is there a way to query that?

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Martin Zimny , the Metrics API requires an admin level role to access. You would need to pass an admin-level bearer token in the Authorization header with the api request. See these steps to generate the token, and the authorization flow. I don't know if there is a way to pass a bearer token Authorization header with the IMPORTDATA function in Google Sheets. If you find a solution for that, please share! Thank you!

    Like
Like Follow
  • Status Answered
  • 3 mths agoLast active
  • 1Replies
  • 18Views
  • 2 Following