In this live stream Marc Dechèvre guides us in an introduction to the Joomla API and shows us some examples of how to use it - including how to import content into a Joomla site from a CSV file in Google sheets.
00:00:00 - Intro & Sponsor
00:03:09 - What is an API? with Marc Dechèvre
00:22:26 - Joomla API Basics & Terminologies
00:35:52 - Advanced API Operations
00:57:15 - Creating Custom HTML Modules & Backend Features
01:06:01 - Google Sheets & External Integrations
01:38:58 - Importing/Updating Articles via Airtable
01:40:55 - Closing Remarks & Thanks
Summary
✅ 1. Understanding Joomla API & Use Cases
The video kicks off by explaining what an API is and how Joomla's API allows you to create, update, fetch, and delete articles using scripts—ideal for automating content tasks.
✅ 2. Creating & Importing Articles via API
A major focus is on automating article creation, including bulk importing from Google Sheets or Excel, with examples using the Joomla API and real-site demos.
✅ 3. Creating Joomla Users & Using API Tokens
Covers how to create a Super User, what their capabilities are, and how to generate and manage API tokens securely for authenticated operations.
✅ 4. Scripting Basics for Beginners
Simple one-page script examples are shown using Visual Studio Code or even Notepad, demonstrating how to post articles and interact with Joomla via RESTful API.
✅ 5. Updating Articles & Using Patch Scripts
Learn how to update existing articles with PATCH scripts and adapt them using Joomla's API—especially useful for minor edits and metadata changes.
✅ 6. Fetching & Filtering Articles
Tim explains how to fetch Joomla articles using the API and filter results to get only published articles or select those from specific categories.
✅ 7. Deleting Articles & Automating Scripts
Instructions are given on how to write DELETE scripts, and how to schedule Joomla API scripts to run automatically via Joomla’s Task Scheduler feature.
✅ 8. Joomla’s Task Scheduler & Script Protection
Introduces Joomla’s new Task Scheduler, including how to create custom tasks and guard scripts from flooding or abuse with smart timing and access control.
✅ 9. Advanced Custom Fields & CFI Integration
Highlights the use of Joomla Custom Fields and CFI (Custom Fields Integrator). Examples include embedding rich data into articles and controlling it through API scripts.
✅ 10. Google Sheets & Airtable Integration
Advanced use cases include:
-
Publishing Google Sheets via URL or CSV
-
Preparing scripts via GitHub
-
Importing/updating content from Airtable via API
This segment showcases how to bridge Joomla with external cloud platforms for seamless content automation.
🧩 Key Features & Tools Mentioned:
-
✅ Joomla API (Create/Update/Delete Articles)
-
✅ Task Scheduler (New Joomla Core Feature)
-
✅ Custom Fields / Advanced Custom Fields
-
✅ CFI (Custom Fields Integrator)
-
✅ Google Sheets + Airtable Integration
Please send any feedback or bug reports or queries to;
Contact Tim Davis ►
Joomla Training Cohort ► https://cybersalt.com/jtc
Add comment