Connect Tinybird and Personio employees in our serverless environment

class HttpSourceTinybirdGetEndpoint {
    async init() {
        // TODO: Create your http credential with tynibird information:
        // More info at https://yepcode.io/docs/integrations/http/#credential-configuration
        // baseUrl: https://api.tinybird.co/v0
        // HTTP Headers: { "Authorization": "Bearer your-read-token" }
        this.axiosClient = yepcode.integration.http(
            "your-tinybird-credential-name"
        );
    }

    async fetch(publish, done) {
        // TODO: Customize your request checking the API documentation:
        // https://www.tinybird.co/docs/api-reference/query-api.html
        this.axiosClient
            .get("/pipes/your_end_point_name.csv", {
                responseType: "stream",
            })
            .then(({
                data
            }) => {
                data
                    .pipe(
                        csv.parse({
                            trim: true,
                            columns: true,
                            delimiter: ",",
                            skip_empty_lines: true,
                        })
                    )
                    .on("data", publish)
                    .on("end", done);
            });
    }

    async close() {}
}

class HttpTargetPersonioCreateEmployee {
    async init() {
        // initialize an http client with personio url and credentials file, performing the initial auth:
        this.axiosClient = axios.create({
            baseURL: "https://api.personio.de/v1",
        });
        const {
            data: {
                bearerToken
            },
        } = await this.axiosClient.post("/auth", {
            // TODO: Customize your client id and secret
            client_id: "you_client_id",
            client_secret: "you_client_secret",
        });
        this.bearerToken = bearerToken;
    }

    async consume(item) {
        // TODO: Customize your request checking the API documentation:
        // https://developer.personio.de/reference/post_company-employees
        const response = await this.axiosClient.post(
            `/company/employees`, {
                // TODO: map your fields from item
                employee: {
                    email: item.email,
                    first_name: item.first_name,
                    last_name: item.last_name,
                    gender: "male",
                    position: "developer",
                    subcompany: "ACME",
                    department: "IT",
                    office: "Madrid",
                    hire_date: "2020-01-31",
                    weekly_working_hours: 40,
                    custom_attributes: {
                        "dynamic_ {{  field uid  }} ": "German",
                    },
                },
            }, {
                headers: {
                    Authorization: `Bearer ${this.bearerToken}`,
                },
            }
        );

        // A new token is recieved in each request (https://developer.personio.de/reference/auth-1)
        this.bearerToken = response.headers.authorization;
    }

    async close() {}
}