Connect HubSpot contacts and Databricks in our serverless environment

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

    async fetch(publish, done) {
        // TODO: Customize your filter
        // More info at: https://developers.hubspot.com/docs/api/crm/search#filter-search-results
        const filter = {
            propertyName: "createdate",
            operator: "GTE",
            value: Date.now() - 90 * 24 * 60 * 60 * 1000, // last 90 days
        };
        const filterGroup = {
            filters: [filter]
        };
        // TODO: Customize your sort
        // More info at: https://developers.hubspot.com/docs/api/crm/search#sort-search-results
        const sort = JSON.stringify({
            propertyName: "createdate",
            direction: "DESCENDING",
        });
        // TODO: Customize your query and properties
        const query = "your query filter";
        const properties = ["email", "firstname", "lastname", "company", "phone"];
        const limit = 10;
        const after = 0;

        // You can check the endpoint doc here, selecting the 'ENDPOINTS' tab at the top of the page
        // https://developers.hubspot.com/docs/api/crm/contacts
        await this.hubspot.crm.contacts.searchApi
            .doSearch({
                filterGroups: [filterGroup],
                sorts: [sort],
                query,
                properties,
                limit,
                after,
            })
            .then(async ({
                total,
                results
            }) => {
                console.log(`${total} contacts where found`);
                for (const contact of results) {
                    await publish(contact.properties);
                }
            });
        done();
    }

    async close() {}
}

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

    async consume(item) {
        // TODO: Customize your sql query
        // More info at: https://github.com/databricks/databricks-sql-nodejs/blob/main/tests/e2e/data_types.test.js#L151
        const operation = await this.session.executeStatement(
            `INSERT INTO yourTable VALUES(${item.id}, ${item.name})`
        );
        const result = await operation.fetchAll();
        await operation.close();
        return result;
    }

    async close() {
        await this.session.close();
        await this.databricks.close();
    }
}