How to load data from Toggl to Postgres destination

First, navigate to your Toggl account settings to obtain your API token. This token is necessary for authenticating your requests to the Toggl API. Ensure that you have the necessary permissions to access the data you intend to transfer.

Install the necessary Python libraries to interact with the Toggl API and PostgreSQL. You will need `requests` for HTTP requests, and `psycopg2` or `sqlalchemy` for database interaction. Run the following commands:
```bash
pip install requests psycopg2-binary
```

Use the Toggl API to fetch the required data. Write a Python script that sends a GET request to the Toggl Reports API endpoint. Use your API token for authentication and specify the data range and type of data you need.
```python
import requests
import json

api_token = 'your_api_token'
headers = {'Content-Type': 'application/json'}
response = requests.get(
'https://api.track.toggl.com/reports/api/v2/details',
auth=(api_token, 'api_token'),
headers=headers,
params={'workspace_id': 'your_workspace_id', 'since': 'YYYY-MM-DD', 'until': 'YYYY-MM-DD'}
)
data = response.json()
```

Process and transform the data to match your PostgreSQL table schema. This may involve changing data types, renaming fields, or creating new calculated fields. Iterate over the fetched data and prepare it for insertion.
```python
transformed_data = []
for entry in data['data']:
transformed_data.append({
'id': entry['id'],
'project': entry['project'],
'duration': entry['dur'] / 1000, # Convert milliseconds to seconds
# Add more transformations as needed
})
```

Establish a connection to your PostgreSQL database using `psycopg2`. Ensure you have the correct credentials and access to the database.
```python
import psycopg2

conn = psycopg2.connect(
dbname='your_dbname',
user='your_user',
password='your_password',
host='your_host',
port='your_port'
)
cursor = conn.cursor()
```

Use SQL `INSERT` statements to add the transformed data into your PostgreSQL database. Ensure that your queries are adaptable to handle the data format and any potential exceptions.
```python
for entry in transformed_data:
cursor.execute("""
INSERT INTO your_table (id, project, duration)
VALUES (%s, %s, %s)
ON CONFLICT (id) DO UPDATE
SET project = EXCLUDED.project, duration = EXCLUDED.duration;
""", (entry['id'], entry['project'], entry['duration']))
conn.commit()
```

After data insertion, verify the data by querying the PostgreSQL database to ensure data integrity and completeness. Once verification is complete, close the database connection to free up resources.
```python
cursor.execute("SELECT * FROM your_table LIMIT 5;")
print(cursor.fetchall())

cursor.close()
conn.close()
```

This guide assumes a basic understanding of Python scripting, REST APIs, and PostgreSQL database operations. Adjust parameters such as workspace ID, table name, and database credentials according to your specific setup.