Connect SOAP and PostgreSQL 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 PostgresTargetInsert {
    async init() {
        // TODO: Create your postgres credential
        // More info at https://yepcode.io/docs/integrations/postgres/#credential-configuration
        this.postgresPool = yepcode.integration.postgres(
            "your-postgres-credential-name"
        );
    }

    async consume(item) {
        // TODO: Customize the SQL INSERT statement and map your item to row
        await this.postgresPool.query(
            "INSERT INTO yourTable(id, name) VALUES($1, $2)",
            [item.id, item.name]
        );
    }

    async close() {
        await this.postgresPool.end();
    }
}