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?
1 reply
-
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!