Looks like I am almost there 😄 can someone tell me how to proceed here? i get the values from the api and it contains a id property. What do I have to do for for target-postgres to actually use it as the "primary_key" field? Basically it adds a null value in the front:

(null, Project 2022, 53, 000053, 01d95718-e653-4ab9-96a5-49fc4b82671f)

I am not sure if I configured something wrong:

class ProjectsStream(bexioStream):
    """Projectsstream."""
    name = "projects"
    path = "pr_project"
    primary_keys = ["id"]
    replication_key = None
    # Optionally, you may also use `schema_filepath` in place of `schema`:
    schema_filepath = SCHEMAS_DIR / "projects.json"

Where does

(null, Project 2022, 53, 000053, 01d95718-e653-4ab9-96a5-49fc4b82671f)

come from?

It shows up in my log when I start the following command

meltano --log-level=debug elt tap-bexio target-postgres

Could you paste the log?

It looks like my issue was that in the database there was still a weird ID column from earlier when I was tinkering around.. After dropping the table and restarting it worked... Not sure how and why, but thanks @visch 😄

😄 no problem good luck, happy coding

One additional problem popped up 😄 how do I enable .env variables? When I configure everything locally and run the

executor: tap-bexio.sh

I got it to work with the

--config=ENV

parameter. But now that I want to directly install it from my github I always get the following message:

2021-12-28T18:14:04.388201Z [info     ] time=2021-12-28 19:14:04 name=tap-bexio level=INFO message=Skipping parse of env var settings... cmd_type=extractor job_id=2021-12-28T181402--tap-bexio--target-postgres name=tap-bexio run_id=063e253e-e529-40e8-a990-a5330752dd8c stdio=stderr

https://github.com/substringgmbh/tap-bexio

Not sure what you mean, time for a new thread please!