Connect SOAP and AWS Redshift in our serverless environment

class SoapSourceFetch {
    async init() {
        // TODO: Create your soap credential
        // More info at https://yepcode.io/docs/integrations/soap/#credential-configuration
        this.soapClient = yepcode.integration.soap("your-soap-credential-name");
    }

    async fetch(publish, done) {
        // TODO: Change MyFunctionNameAsync by your function name
        // Example: fetchData --> fetchDataAsync
        // Official docs: https://github.com/vpulim/node-soap#clientmethodasyncargs-options---call-method-on-the-soap-service
        const response = await this.soapClient.MyFunctionNameAsync({
            argumentName: "value",
        });

        // response is a javascript array containing, in the following order, result, rawResponse, soapheader, and rawRequest
        // result can be a simple javascript object, or a javascript object containing an array
        // rawResponse is the raw xml response string
        // soapHeader is the response soap header as a javascript object
        // rawRequest is the raw xml request string

        // In this case, we assume that our function returns an array
        for (const item of response[0]) {
            publish(item);
        }

        done();
    }

    async close() {}
}

class AwsRedshiftTargetInsert {
    async init() {
        // TODO: Create your aws-redshift credential
        // More info at https://yepcode.io/docs/integrations/aws-redshift/#credential-configuration
        this.awsRedshift = yepcode.integration.awsRedshift(
            "your-aws-redshift-credential-name"
        );
    }

    async consume(item) {
        // TODO: Customize your sql query
        const sqlStatement = `INSERT INTO your-table-name VALUES (${item.someProp}, '${item.someStringProp}')`;

        // TODO: Customize the command to be executed
        // More info at https://docs.aws.amazon.com/AWSJavaScriptSDK/v3/latest/clients/client-redshift-data/interfaces/executestatementcommandinput.html
        this.awsRedshift.send(
            new ExecuteStatementCommand({
                ClusterIdentifier: "your-cluster-identifier",
                Database: "your-database",
                DbUser: "your-db-user",
                Sql: sqlStatement,
            })
        );
    }

    async close() {}
}