Custom functions: how to batch

[wanquantong]

    const BREAKER_ELEC_MONTH_NAME = 'Breaker_Elec_Month'; 
    const BREAKER_ELEC_MONTH_API = URL + '/TDQS/public/index.php/getMonthElectricity';
    class BREAKER_ELEC_MONTH_Plugin extends HyperFormula.FunctionPlugin {
        BREAKER_ELEC_MONTH_Function(ast, state) {
            return this.runFunction(
                ast.args,
                state,
                this.metadata('BREAKER_ELEC_MONTH'),
                (a, b, c, d) => {
                    let result = 'Loading...'
                    $.ajax({
                        url: BREAKER_ELEC_MONTH_API,
                        type: 'GET',
                        async: false,
                        dataType: 'json',
                        data: { a: a, b: b, c: c, d: d },
                        success: function (res) {
                            if (res.code == 1) {
                                result = res.data.value;
                            } else {
                                result = 'error'
                            }
                        },
                        error: function (jqXHR, textStatus, errorThrown) {
                            console.error('Error:', textStatus, errorThrown);
                        }
                    });
                    return result
                }
            );
        }
    }
    BREAKER_ELEC_MONTH_Plugin.implementedFunctions = {
        BREAKER_ELEC_MONTH: {
            method: 'BREAKER_ELEC_MONTH_Function',
            isVolatile: false,
            vectorizationForbidden: true,
            parameters: [
                { argumentType: HyperFormula.FunctionArgumentType.STRING }, 
                { argumentType: HyperFormula.FunctionArgumentType.STRING }, 
                { argumentType: HyperFormula.FunctionArgumentType.STRING }, 
                { argumentType: HyperFormula.FunctionArgumentType.STRING }
            ]
        }
    };
    const BREAKER_ELEC_MONTH_Translations = {
        enGB: {
            BREAKER_ELEC_MONTH: BREAKER_ELEC_MONTH_NAME
        },
        enUS: {
            BREAKER_ELEC_MONTH: BREAKER_ELEC_MONTH_NAME
        }
    };
    HyperFormula.registerFunctionPlugin(BREAKER_ELEC_MONTH_Plugin, BREAKER_ELEC_MONTH_Translations);
    // END BREAKER_ELEC_MONTH

[sequba]

@wanquantong What is your question?

[wanquantong]

For example, if there are 60 cells to fill in with this custom function, and each cell takes 1 second to fill in, it will take a total of 1 minute. Is it possible to batch-fetch data from the API

[sequba]

@wanquantong have a look at the discussion in this issue: #1119 (comment)