How to Process Download Project Report from Rapid URL Indexer
This guide explains how to format the raw response from Rapid URL Indexer's "Download Project Report" action into a clean, structured format.Overview
The Download Project Report action returns data in a compressed format that needs to be processed through multiple steps to get clean, readable results with URL indexing status.Step-by-Step Process
Step 1: Download Project Report
Use the Rapid URL Indexer: Download Project Report action to get your project data.
Expected Response Format:
"URL,Status\nhttps:\/\/encrypted-tbn0.gstatic.com\/images?q=tbn:ANd9GcRGgF2jB8Ni3TCaExbN20__46pSvf1pQhBAXQ&s,\"Not Indexed\"\nhttps:\/\/encrypted-tbn0.gstatic.com\/images?q=tbn:ANd9GcQoFRQjM-wM_nXMA03AGDXgJK3VeX7vtD3ctA&s,\"Not Indexed\"\n"
Step 2: Text Formatting
Use Text Formatter (Pabbly): Replace Text to clean the response.
Configuration:
- Text: Map the response from Step 1
- Find: " (double quotes)
- Replace: ' (single quotes)
Step 3: JavaScript Processing
Use Code (Pabbly): Run JavaScript to format the data into a structured output.
JavaScript Code:
const raw = // Map the result from Step 2 here
output = raw
.split('"').join('"')
.split('&').join('&')
.split('\\n').join('\n')
.split('\\/').join('/')
.replace(/^"|"$/g, '')
.trim()
.split('\n')
.slice(1)
.map(line => {
const [url, status] = line.split(',');
return {
URL: url.trim().replace(/"/g, ''),
Status: status.trim().replace(/"/g, '')
};
});
const csvHeader = 'URL,Status\n';
const csvBody = output.map(row => `"${row.URL}","${row.Status}"`).join('\n');
const csv = csvHeader + csvBody;
console.log(csv);
Important: Map the response from Step 2 (Text Formatter) into the const raw = variable.
Final Output
After processing, you'll receive a clean, structured format with separate URL and Status fields:
Output Fields:
- Output 0 URL: First URL from the report
- Output 0 Status: Indexing status for first URL
- Output 1 URL: Second URL from the report
- Output 1 Status: Indexing status for second URL
- Logs: Complete formatted CSV data
Tips
- Always process the raw response through all three steps for accurate results
- The JavaScript code handles HTML entities and escape characters automatically
- Use the structured output fields for individual URL processing or the Logs field for complete CSV data
