How to Integrate Replit with Joomla

1// check-joomla-secrets.js
2const required = ['JOOMLA_API_TOKEN', 'JOOMLA_BASE_URL'];
3for (const key of required) {
4  if (!process.env[key]) {
5    throw new Error(`Missing secret: ${key}. Set it in Replit Secrets (lock icon 🔒).`);
6  }
7}
8console.log('Joomla config OK. Site:', process.env.JOOMLA_BASE_URL);

1// joomla.js — Joomla Web Services API integration for Node.js on Replit
2const axios = require('axios');
3const express = require('express');
4
5const BASE_URL = process.env.JOOMLA_BASE_URL;
6const TOKEN = process.env.JOOMLA_API_TOKEN;
7const API_URL = `${BASE_URL}/api/index.php/v1`;
8
9const joomlaApi = axios.create({
10  baseURL: API_URL,
11  headers: {
12    'Authorization': `Bearer ${TOKEN}`,
13    'Content-Type': 'application/json'
14  }
15});
16
17const app = express();
18app.use(express.json());
19
20// Get published articles — handles JSON:API response format
21app.get('/api/articles', async (req, res) => {
22  const { catId, limit = 20, offset = 0 } = req.query;
23  const params = {
24    'filter[state]': 1,  // Published only
25    'page[limit]': limit,
26    'page[offset]': offset
27  };
28  if (catId) params['filter[category_id]'] = catId;
29  
30  try {
31    const response = await joomlaApi.get('/content/articles', { params });
32    // JSON:API: data is an array of { id, type, attributes, relationships }
33    const articles = response.data.data.map(item => ({
34      id: item.id,
35      title: item.attributes.title,
36      alias: item.attributes.alias,
37      introtext: item.attributes.introtext,
38      catid: item.attributes.catid,
39      created: item.attributes.created,
40      state: item.attributes.state
41    }));
42    res.json({ articles, total: response.data.meta?.total || articles.length });
43  } catch (err) {
44    res.status(err.response?.status || 500).json({ error: err.response?.data || err.message });
45  }
46});
47
48// Get single article by ID
49app.get('/api/articles/:id', async (req, res) => {
50  try {
51    const response = await joomlaApi.get(`/content/articles/${req.params.id}`);
52    const item = response.data.data;
53    res.json({ id: item.id, ...item.attributes });
54  } catch (err) {
55    res.status(err.response?.status || 500).json({ error: err.response?.data || err.message });
56  }
57});
58
59// Create a new article
60app.post('/api/articles', async (req, res) => {
61  const { title, introtext, fulltext, catid, state = 1, language = '*' } = req.body;
62  
63  // JSON:API format for creating resources
64  const payload = {
65    title,
66    introtext: introtext || '',
67    fulltext: fulltext || '',
68    catid: catid || 1,
69    state,
70    language,
71    access: 1,  // Public
72    featured: 0
73  };
74  
75  try {
76    const response = await joomlaApi.post('/content/articles', payload);
77    const item = response.data.data;
78    res.json({ success: true, id: item.id, title: item.attributes?.title });
79  } catch (err) {
80    res.status(err.response?.status || 500).json({ error: err.response?.data || err.message });
81  }
82});
83
84// Get all content categories
85app.get('/api/categories', async (req, res) => {
86  try {
87    const response = await joomlaApi.get('/categories', {
88      params: { 'filter[component]': 'com_content' }
89    });
90    const cats = response.data.data.map(c => ({ id: c.id, title: c.attributes.title, alias: c.attributes.alias }));
91    res.json({ categories: cats });
92  } catch (err) {
93    res.status(err.response?.status || 500).json({ error: err.response?.data || err.message });
94  }
95});
96
97app.listen(3000, '0.0.0.0', () => console.log('Joomla API server running on port 3000'));

1# joomla_api.py — Joomla Web Services API for Python on Replit
2import os
3import requests
4from flask import Flask, request, jsonify
5
6BASE_URL = os.environ['JOOMLA_BASE_URL']
7TOKEN = os.environ['JOOMLA_API_TOKEN']
8API_URL = f'{BASE_URL}/api/index.php/v1'
9
10# Session with auth header set once
11session = requests.Session()
12session.headers.update({
13    'Authorization': f'Bearer {TOKEN}',
14    'Content-Type': 'application/json'
15})
16
17app = Flask(__name__)
18
19def parse_articles(response_data):
20    """Extract simplified article data from JSON:API format."""
21    return [{
22        'id': item['id'],
23        'title': item['attributes']['title'],
24        'alias': item['attributes']['alias'],
25        'introtext': item['attributes'].get('introtext', ''),
26        'catid': item['attributes'].get('catid'),
27        'state': item['attributes'].get('state'),
28        'created': item['attributes'].get('created')
29    } for item in response_data.get('data', [])]
30
31@app.route('/api/articles')
32def get_articles():
33    params = {
34        'filter[state]': 1,
35        'page[limit]': request.args.get('limit', 20),
36        'page[offset]': request.args.get('offset', 0)
37    }
38    if cat_id := request.args.get('catId'):
39        params['filter[category_id]'] = cat_id
40    
41    resp = session.get(f'{API_URL}/content/articles', params=params)
42    if not resp.ok:
43        return jsonify({'error': resp.json()}), resp.status_code
44    
45    articles = parse_articles(resp.json())
46    return jsonify({'articles': articles, 'total': len(articles)})
47
48@app.route('/api/articles', methods=['POST'])
49def create_article():
50    data = request.get_json()
51    payload = {
52        'title': data.get('title'),
53        'introtext': data.get('introtext', ''),
54        'fulltext': data.get('fulltext', ''),
55        'catid': data.get('catid', 1),
56        'state': data.get('state', 1),
57        'language': data.get('language', '*'),
58        'access': 1
59    }
60    resp = session.post(f'{API_URL}/content/articles', json=payload)
61    if not resp.ok:
62        return jsonify({'error': resp.json()}), resp.status_code
63    
64    item = resp.json().get('data', {})
65    return jsonify({'success': True, 'id': item.get('id'), 'title': item.get('attributes', {}).get('title')})
66
67if __name__ == '__main__':
68    app.run(host='0.0.0.0', port=3000)