Connect Webflow CMS entries and AWS Redshift in our serverless environment

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

    async fetch(publish, done) {
        const limit = 100;

        let offset = 0;
        let hasMore = true;
        while (hasMore === true) {
            // TODO: Customize your collection id
            // See how to find your collection id: https://www.briantsdawson.com/blog/webflow-api-how-to-get-site-collection-and-item-ids-for-zapier-and-parabola-use
            // More info about the request at: https://developers.webflow.com/#list-collection-items
            const items = await this.webflow.items({
                collectionId: "your-collection-id",
                limit,
                offset,
            });

            // See item object structure at: https://developers.webflow.com/#collectionitem
            for (const item of items) {
                await publish(item);
            }

            hasMore = items.length === limit;
            offset = offset + limit;
        }
        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() {}
}