Invoices API

import requests
import os
import json

# --- Configuration ---
BASE_URL = "https://app.billgauge.com/api/v1"
# Store your API key in an environment variable for security
API_KEY = os.environ.get("BILLGAUGE_API_KEY", "your_api_key_here")
PROPERTY_ID = "prop_example_123456"  # Replace with your property ID

HEADERS = {
    "Authorization": f"Bearer {'{'}API_KEY{'}'}",
    "Content-Type": "application/json",
}

def get_unpaid_invoices(property_id):
    """Fetches all invoices for a property that are not paid."""
    print(f"Searching for unpaid invoices for property: {'{'}property_id{'}'}")
    
    # Note: status parameter takes a single value, not comma-separated
    # To get multiple statuses, make separate calls or don't filter by status
    params = {
        "propertyId": property_id,
        "status": "OVERDUE",  # or "DRAFT", "SENT", etc.
        "details": "true"  # Include charges breakdown
    }
    
    response = requests.get(f"{'{'}BASE_URL{'}'}/invoices", headers=HEADERS, params=params)
    
    if response.ok:
        data = response.json()
        return data.get("data", []), data.get("pagination", {'{'}{'}'})
    else:
        print(f"Error: {'{'}response.status_code{'}'}")
        print(response.text)
        return None, None

def get_all_unpaid_invoices(property_id):
    """Get all non-paid invoices by fetching different statuses."""
    all_unpaid = []
    statuses = ["DRAFT", "SENT", "OVERDUE"]
    
    for status in statuses:
        params = {
            "propertyId": property_id,
            "status": status,
            "details": "true"
        }
        
        response = requests.get(f"{'{'}BASE_URL{'}'}/invoices", headers=HEADERS, params=params)
        
        if response.ok:
            data = response.json()
            all_unpaid.extend(data.get("data", []))
        else:
            print(f"Error fetching {'{'}status{'}'} invoices: {'{'}response.status_code{'}'}")
    
    return all_unpaid

if __name__ == "__main__":
    unpaid_invoices = get_all_unpaid_invoices(PROPERTY_ID)
    if unpaid_invoices:
        print(f"Found {'{'}len(unpaid_invoices){'}'} unpaid invoices.")
        # Show the first invoice with its charges
        if unpaid_invoices:
            invoice = unpaid_invoices[0]
            print(f"Invoice {'{'}invoice['invoiceNumber']{'}'} - Status: {'{'}invoice['status']{'}'}")
            print(f"Total Amount: {invoice['totalAmount']{'}'}")
            print(f"Charges: {'{'}len(invoice.get('charges', [])){'}'}")
            print(json.dumps(invoice, indent=2, default=str))

import requests
import os
import json
from datetime import datetime

# --- Configuration ---
BASE_URL = "https://app.billgauge.com/api/v1"
API_KEY = os.environ.get("BILLGAUGE_API_KEY", "your_api_key_here")
# Current month in YYYY-MM format
QUERY_MONTH = datetime.now().strftime("%Y-%m") 

HEADERS = {
    "Authorization": f"Bearer {'{'}API_KEY{'}'}",
    "Content-Type": "application/json",
}

def get_detailed_invoices_for_month(month):
    """Fetches detailed invoices for a specific month with pagination."""
    print(f"Fetching detailed invoices for {'{'}month{'}'}")
    
    all_invoices = []
    page = 1
    
    while True:
        params = {
            "month": month,
            "details": "true",  # Include charges and custom charges
            "page": page,
            "limit": 50  # Max items per page
        }
        
        response = requests.get(f"{'{'}BASE_URL{'}'}/invoices", headers=HEADERS, params=params)
        
        if not response.ok:
            print(f"Error: {'{'}response.status_code{'}'}")
            print(response.text)
            break
            
        data = response.json()
        invoices = data.get("data", [])
        pagination = data.get("pagination", {'{'}{'}'})
        
        all_invoices.extend(invoices)
        
        # Check if we have more pages
        if page >= pagination.get("totalPages", 1):
            break
        page += 1
    
    return all_invoices

def update_invoice_status(invoice_id, new_status):
    """Update an invoice status."""
    valid_statuses = ["DRAFT", "SENT", "PAID", "OVERDUE", "CANCELLED"]
    
    if new_status not in valid_statuses:
        print(f"Invalid status. Must be one of: {'{'}valid_statuses{'}'}")
        return None
    
    payload = {"status": new_status}
    
    response = requests.patch(
        f"{'{'}BASE_URL{'}'}/invoices/{'{'}invoice_id{'}'}", 
        headers=HEADERS, 
        json=payload
    )
    
    if response.ok:
        return response.json()
    else:
        print(f"Error updating invoice: {'{'}response.status_code{'}'}")
        print(response.text)
        return None

if __name__ == "__main__":
    invoices = get_detailed_invoices_for_month(QUERY_MONTH)
    if invoices:
        print(f"Found {'{'}len(invoices){'}'} invoices for {'{'}QUERY_MONTH{'}'}")
        
        # Show summary
        for invoice in invoices:
            charges_count = len(invoice.get('charges', []))
            custom_charges_count = len(invoice.get('customCharges', []))
            print(f"Invoice {'{'}invoice['invoiceNumber']{'}'}: {'{'}invoice['status']{'}'} - "
                  f"{invoice['totalAmount']{'}'} ({'{'}charges_count{'}'} charges, "
                  f"{'{'}custom_charges_count{'}'} custom charges)")
        
        # Example: Mark the first draft invoice as sent
        draft_invoice = next((inv for inv in invoices if inv['status'] == 'DRAFT'), None)
        if draft_invoice:
            print(f"Updating invoice {'{'}draft_invoice['invoiceNumber']{'}'} to SENT...")
            updated = update_invoice_status(draft_invoice['id'], 'SENT')
            if updated:
                print(f"Successfully updated to {'{'}updated['status']{'}'}")

import requests
import os
import json

# --- Configuration ---
BASE_URL = "https://app.billgauge.com/api/v1"
API_KEY = os.environ.get("BILLGAUGE_API_KEY", "your_api_key_here")

HEADERS = {
    "Authorization": f"Bearer {'{'}API_KEY{'}'}",
    "Content-Type": "application/json",
}

def get_invoice_details(invoice_id):
    """Get detailed information about a specific invoice."""
    response = requests.get(f"{'{'}BASE_URL{'}'}/invoices/{'{'}invoice_id{'}'}", headers=HEADERS)
    
    if response.ok:
        return response.json()
    else:
        print(f"Error: {'{'}response.status_code{'}'}")
        print(response.text)
        return None

def analyze_invoice_charges(invoice):
    """Analyze the charges breakdown of an invoice."""
    if not invoice:
        return
    
    print(f"=== Invoice Analysis: {'{'}invoice['invoiceNumber']{'}'} ===")
    print(f"Status: {'{'}invoice['status']{'}'}")
    print(f"Total Amount: {invoice['totalAmount']{'}'}")
    print(f"Property: {'{'}invoice['property']['name']{'}'}")
    print(f"Unit: {'{'}invoice['unit']['label']{'}'}")
    print(f"Month: {'{'}invoice['month'][:7]{'}'}")  # YYYY-MM format
    
    # Utility charges breakdown
    charges = invoice.get('charges', [])
    if charges:
        print(f"--- Utility Charges ({'{'}len(charges){'}'}) ---")
        total_utility = 0
        for charge in charges:
            amount = float(charge['amount'])
            total_utility += amount
            print(f"  {'{'}charge['utilityType']{'}'}: {amount:.2f{'}'}")
        print(f"  Total Utility: {total_utility:.2f{'}'}")
    
    # Custom charges
    custom_charges = invoice.get('customCharges', [])
    if custom_charges:
        print(f"--- Custom Charges ({'{'}len(custom_charges){'}'}) ---")
        total_custom = 0
        for charge in custom_charges:
            amount = float(charge['amount'])
            total_custom += amount
            print(f"  {'{'}charge['description']{'}'}: {amount:.2f{'}'}")
        print(f"  Total Custom: {total_custom:.2f{'}'}")
    
    # Payment information
    if invoice.get('stripePaymentLinkUrl'):
        print(f"--- Payment Info ---")
        print(f"Payment Link: {'{'}invoice['stripePaymentLinkUrl']{'}'}")
        print(f"Payment Status: {'{'}invoice.get('paymentStatus', 'N/A'){'}'}")
        if invoice.get('paidAt'):
            print(f"Paid At: {'{'}invoice['paidAt']{'}'}")

if __name__ == "__main__":
    # Replace with an actual invoice ID from your system
    INVOICE_ID = "cm1234567890abcdef"
    
    invoice = get_invoice_details(INVOICE_ID)
    if invoice:
        analyze_invoice_charges(invoice)