[Help] Need script to convert single-quoted JSON to standard double-quoted JSON

[Nakin72]

Hello everyone. I have some problems when my GPRS device cannot send JSON objects with doubled quotas ("). Instead, it can send single quotes ('). Is it possible to create a script when a bad JSON string cannot be parsed and it will run script to change ' to " before JSON parsing?

Thank you in advance

[ysfscream]

Theoretically, it is possible. MQTTX receives binary data, and we convert the received data to "Plaintext" so we can parse whatever you send.

At this point, we can continue the conversion in the script. Here's a reference script you can try, thank you:

/**
 * @description Convert single-quoted JSON to double-quoted JSON for parsing
 * @param {object|string} value - Raw data (attempt to handle single-quoted JSON)
 * @param {'publish'|'received'} msgType - Message type: 'received' or 'publish'
 * @param {number} [index] - Message index (valid only when script used for publishing with scheduled message)
 */
function handlePayload(value, msgType, index) {
    try {
        // If value is already an object, return it as is
        if (typeof value !== 'string') {
            return value;
        }
        
        let parsedValue;
        
        try {
            // First try standard JSON parsing
            parsedValue = JSON.parse(value);
        } catch (initialError) {
            console.log('Standard JSON parsing failed, attempting to convert single quotes...');
            
            // Convert single quotes to double quotes for JSON parsing
            // This regex replaces single quotes with double quotes, but ignores single quotes inside strings
            const processedValue = value
                .replace(/'/g, '"')                 // Replace all single quotes with double quotes
                .replace(/\\"/g, "\\'")             // Handle escaped quotes
                .replace(/"([^"]+)":/g, '"$1":')    // Fix potential issues with property names
            
            try {
                parsedValue = JSON.parse(processedValue);
                console.log('Successfully parsed JSON after converting single quotes to double quotes');
            } catch (secondError) {
                console.error('Failed to parse JSON even after conversion:', secondError);
                return value; // Return the original value if all parsing attempts fail
            }
        }
        
        // Return the parsed and stringified value with proper formatting
        return JSON.stringify(parsedValue, null, 2);
    } catch (e) {
        console.error('Processing error:', e);
        return value; // Keep original data on error
    }
}

execute(handlePayload);

This script first attempts standard JSON parsing, and if it fails, it converts all single quotes to double quotes and tries parsing again. If it still fails, it returns the original data.