Access Discourse database with n8n

[illusionandcards]

Hello!

I want to get the monthly active users (Posts) with n8n to store them and keep track of the growth of my forum.

I’ve done it through web scraping in n8n, and it works fine, but I was wondering if is it possible to make it in any other way, like accessing the database with n8n and doing queries?

It would be really helpful, not just for this, but for many other integrations.

Thanks!

[merefield (Robert)]

The supported integrations are, I believe, documented here:

Discourse integrations | Workflow automation with n8n

Discourse offers a Data Explorer API that gives you ultimate flexibility, but may not yet be supported by n8n at present:

Run Data Explorer queries with the Discourse API

This guide explains how to use the Discourse API to create, run, and manage queries with the Data Explorer plugin. Required user level: Administrator Virtually any action that can be performed through the Discourse user interface can also be triggered with the Discourse API. This document provides a comprehensive overview for utilizing the API specifically in conjunction with the Data Explorer plugin. For a general overview of how to find the correct API …

Perhaps there’s a way you can build the integration with that yourself using n8n developer tools?

You might get help with that at: https://community.n8n.io/

[illusionandcards]

Thanks! I’ll check the documentation provided.