Use API to get topics for a period using js

Dev
1

I was wondering if anyone has a simple javascript get example, to get topics from a certain category within a certain timeframe? I’m looking to pull data into Google sheets and I’m a bit rusty (and new to the Discourse reports API).

2

I think your best bet is the data explorer plugin and Run Data Explorer queries with the Discourse API

3

Thanks. I’ll try that when/if we upgrade our plan. In the mean time I did get something to work using the search API.
Only strange thing is I can get topics and posts, but neither dataset is complete, and I really don’t want to start manually joining sets by topic id.
(For example, the posts dataset doesn’t give me the post title. The topics dataset doesn’t show author info)

Is there anyone who knows of an endpoint that will give me, with ONE query, a list of topics with this data? <topic id, topic title, topic body, topic author username, topic author id, post date, category>

FWIW, the basics work:

var url = 'https://community.coherence.io/search.json?q=%23suggestions%20after%3A2023-02-01&page=1';
  var options = {
    'method' : 'get',
    'contentType': 'application/json',  
    'muteHttpExceptions' : true,
      'headers': {
      'Api-Key': '<key>',
      'Api-Username' : '<username>'
    }
  }