PakEnergy Integration
Seamlessly sync with PakEnergy's Welltrax system to automatically import ticket data from schedule entries (loads and tickets) into your crude oil management platform using the official Welltrax API.
Welltrax Ticket Import
Coyote Measurement integrates with PakEnergy's Welltrax system using the official Welltrax API to automatically import ticket data. The integration uses OAuth2 client credentials authentication to securely access your Welltrax company data, retrieves schedule entries (loads and tickets) via the ticket search endpoint, and creates ExternalTicket records in your system. This enables seamless data flow from Welltrax into your terminal measurement and reconciliation workflows.
Key Benefits
- ✓Automatic ticket import from Welltrax using the official API, eliminating manual data entry and reducing errors.
- ✓Secure credential management with OAuth2 client credentials and encrypted secret storage for your Welltrax API credentials.
- ✓Flexible sync options with configurable frequency (every 10 minutes to daily) and manual sync with custom date ranges.
- ✓Handles large datasets with automatic date range chunking (15-day API limit) and pagination support.
- ✓Smart data normalization that extracts ticket information from nested schedule entry structures (load + ticket objects).
How It Works
The integration uses the Welltrax API to retrieve ticket data:
- • OAuth2 Authentication: Uses client credentials grant type to obtain access tokens from Welltrax
- • Ticket Search API: Queries the POST /ticketAPI/v1/tickets/{company} endpoint with date ranges and filters
- • Schedule Entry Processing: Extracts ticket data from nested schedule entry structures (load, ticket, account, operator, etc.)
- • Data Normalization: Transforms Welltrax data into standardized ExternalTicket records with ticket numbers, dates, volumes, producers, destinations, and more
- • Automatic Matching: Links imported tickets to counterparties and movements in your system
- • Pricing Recalculation: Automatically triggers pricing recomputation for matched movements
The integration handles API limitations (15-day date range per request) by automatically chunking large date ranges and supports pagination for large result sets. All credentials are encrypted at rest, and the integration includes comprehensive error handling for expired tokens, access denied scenarios, and service unavailability.
Ready to Connect PakEnergy?
Schedule a demo to see how the PakEnergy integration can enhance your operations.
Schedule a Demo