Connect Webflow CMS entries and Supabase CSV file 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 SupabaseTargetUploadCsv {
    async init() {
        // TODO: Create your supabase credential
        // More info at https://yepcode.io/docs/integrations/supabase/#credential-configuration
        this.supabase = yepcode.integration.supabase(
            "your-supabase-credential-name"
        );

        this.items = [];
    }

    async consume(item) {
        // TODO: Customize your csv row
        const csvRow = [item.id, item.name];
        this.items.push(csvRow);
    }

    async close() {
        try {
            // Transform items to CSV entries
            const csvFileContent = csv.stringify(this.items, {
                delimiter: ",",
            });
            // TODO: adapt bucket and files management
            // You may check the full API documentation at:
            // Check docs at https://supabase.com/docs/reference/javascript/storage-from-upload
            const {
                data,
                error
            } = await this.supabase.storage
                .from("your-bucket-name")
                .upload(`your-new-file.csv`, csvFileContent, {
                    contentType: "text/csv",
                });

            if (error) {
                throw error;
            }
        } catch (error) {
            console.error(`Error ending upload`, error);
        }
    }
}