matt-taylor.tech
← Back to projects

Open source

Dell warranty to Freshservice sync

github.com/matt-taylor-tech/DellWarrantytoFreshserviceAssets ↗

Python Dell TechDirect API Freshservice API OAuth 2.0 GitHub Actions

Freshservice can record when a warranty ends, but a technician also needs to know what the machine is covered for before quoting a repair. This Python integration reads Dell TechDirect entitlements and updates the matching Freshservice asset with the coverage detail technicians need where they already work.

Correctness before automation

  • Unknown is not expired. Unrecognized active coverage is left unwritten instead of being converted into a confident but incorrect answer.
  • Dry-run by default. Writing requires an explicit apply flag, and a write cap limits the impact of a bad configuration or upstream API change.
  • Runtime field discovery. Freshservice custom-field keys are resolved by label so the tool is portable across tenants rather than hardcoded to one asset type.
  • Idempotent updates. Unchanged data generates no write, keeping API usage and run logs focused on real changes.
  • Collision and scope guards. The integration refuses duplicate service tags, ignores non-Dell assets, and never creates or deletes an asset.

Deployability

The implementation uses Python's standard library, reads credentials only from environment variables, and includes offline business-rule tests wired into GitHub Actions. The repository documents Azure Automation, private workflow, and cron deployment paths, with failure alerting treated as part of the design rather than an optional afterthought.

Current status

Built and tested, with deployment still pending. The public repository demonstrates the integration and its failure-safe behavior without claiming production use that has not happened.