Fetch and Store External API Data as Local JSON File - n8n Workflow
Use this robust n8n workflow to fetch data from any external API (like TheCocktailDB) and efficiently store the JSON output as a local file using the Write Binary File n8n node. Perfect for local caching and development.
Workflow Preview
Ready to automate?
Download this n8n workflow template and start using it instantly.
Who is this best for?
- Users new to n8n looking to understand file handling.
- Developers needing to test API integrations and locally cache results.
- DevOps professionals running self-hosted n8n instances who require local disk operations.
- Anyone building n8n templates that involve data persistence.
Overview
This versatile n8n workflow addresses the common requirement of fetching dynamic data from a third-party API and saving that information directly to the local disk where the n8n instance is running. While many n8n templates rely on cloud storage, saving files locally is crucial for development, quick testing, and accessing data within environments that restrict external connections.
The core value of this specific n8n workflow is showcasing the transition from a standard JSON data object (received from the HTTP Request n8n node) into a binary file format (using the Move Binary Data n8n node), which is necessary before the data can be written to disk. This process is fundamental for anyone looking to build complex file-processing n8n templates. The starting point is always the efficient n8n trigger, allowing for immediate execution and testing of the sequence.
How it Works
This powerful n8n workflow operates in four sequential stages:
- Initialization: The workflow starts with a Manual n8n Trigger, allowing the user to initiate the process immediately by clicking 'Execute Workflow'. This is ideal for testing and single runs.
- Data Retrieval: The 'HTTP Request' n8n node calls the external API (
https://www.thecocktaildb.com/api/json/v1/1/random.php) to retrieve a JSON object containing information about a random cocktail. This results in standard JSON data ready for processing. - Format Conversion: The 'Move Binary Data' n8n node receives the JSON data. Crucially, it is configured to operate in
jsonToBinarymode. This step transforms the standard JSON item into a binary data stream, preparing it for file system writing. This transformation is necessary because the file writing n8n node requires binary input. - Local Storage: The final 'Write Binary File' n8n node takes the newly created binary stream and saves it to the local file system, creating a file named
cocktail.json. This completes the n8n workflow by persisting the fetched API data.
Installation Guide
To install this n8n workflow template:
- Copy the entire workflow JSON provided.
- Log into your n8n instance.
- In the Workflows section, click 'New' and then 'Import from JSON'. Paste the copied JSON data.
- No external credentials are required for the public API call used in this specific n8n template.
- Ensure your n8n instance has permissions to write files to the default directory (usually the working directory of the n8n server).
- Execute the workflow by clicking 'Execute Workflow' or testing the manual n8n trigger.
Node Details
- On clicking 'execute' (Manual Trigger n8n Trigger):
- Key Configuration: A simple manual n8n trigger, requiring no external setup.
- HTTP Request (n8n Node):
- Key Configuration: URL set to
https://www.thecocktaildb.com/api/json/v1/1/random.php.- Move Binary Data (n8n Node):
- Key Configuration: Mode set to
JSON to Binary.- Write Binary File (n8n Node):
- Key Configuration: File Name set to
cocktail.json.Related n8n Workflows
Retell AI Call Transcript and Analysis Logger
Use this robust n8n workflow to automatically log Retell AI call transcripts, sentiment analysis, and metrics into Google Sheets, Airtable, or Notion using a seamless webhook n8n trigger.
Automated Notion Page Sync to Supabase Vector Store using OpenAI
This robust n8n workflow automatically syncs new Notion pages to a Supabase vector database, leveraging the OpenAI n8n node to create text embeddings for powerful Retrieval Augmented Generation (RAG) applications.
Gmail Email Detail Capture and MySQL Storage
Automate saving Gmail email metadata (sender, recipient, subject, snippet) directly to a MySQL database using a reliable n8n workflow. Use this powerful n8n template today.
Typeform Submissions to Airtable and Slack Notification
Use this powerful n8n workflow to capture Typeform submissions, map the data, store it in Airtable, and send instant team alerts via the Slack n8n node.
Strategic Social Media Goal Tracker and Client Reporting System
Use this powerful n8n workflow to automate client onboarding, track daily social media performance across four platforms (Instagram, Facebook, X, LinkedIn), and generate scheduled reports and alerts. Perfect for agencies.
Automated Client Onboarding and Tier Assignment with Reporting
Use this comprehensive n8n workflow to automate client onboarding, validate emails, assign service tiers, create Trello tasks, generate personalized PDFs, and send weekly reports. A powerful n8n template for scaling businesses.
Featured*
