dlt-source-personio 0.0.1

A DLT source for personio

---

description: dlt source for personio.com keywords: [personio API, personio.com]

dlt-source-personio

DLT source for personio.

Currently loads the following data:

Table	Contains	Spec version
persons	Items of the Person model with all properties	V2
employments	Items of the Employment model with all properties	V2

Usage

Create a .dlt/secrets.toml with your API key and email:

personio_client_id = "papi-..."
personio_client_secret = "papi-..."

and then run the default source with optional list references:

from dlt_source_personio import source as personio_source

pipeline = dlt.pipeline(
   pipeline_name="personio_pipeline",
   destination="duckdb",
   dev_mode=True,
)
personio_data = personio_source()
pipeline.run(personio_data)

Development

This project is using devenv.

Commands:

Command	What does it do?
generate-model	generates the personio Pydantic model from the current spec file, applies patches, etc.
update-spec	Pulls in the latest master#HEAD of personio/api-docs
validate-spec	Validates the local (unofficial) Personio V2 spec
refresh-model	Both commands above plus adds it to git and commits the changes.
format	Formats & lints all code
sample-pipeline-run	Runs the sample pipeline. By default dev_mode=True which fetches resources with a limit of 1 (page)
sample-pipeline-show	Starts the streamlit-based dlt hub

Run the sample

PERSONIO_CLIENT_ID=[...] \
   PERSONIO_CLIENT_SECRET=[...] \
      sample-pipeline-run

alternatively you can also create a .dlt/secrets.toml (excluded from git) with the following content:

personio_client_id = "papi-..."
personio_client_secret = "papi-..."