combined-hubspot-stripelisted

# HubSpot pipeline and Stripe payments Answer questions such as “Which companies have open opportunities, and what have their paid invoices totaled in the last 90 days?” using the HubSpot and Stripe sources already available to the user's Combined agent. ## Establish the calculation Respect the user's metric and time range. For “last 90 complete UTC days,” use the interval from UTC midnight 90 days before today to today's UTC midnight, with an exclusive upper bound. Use the invoice payment timestamp for paid-invoice collections; invoice creation time answers a different question. Open pipeline is the unweighted amount of deals whose stage is open. Map closed-won, closed-lost, and custom stages from the actual source data or a user-supplied mapping. Do not infer stage meaning from an unfamiliar identifier. Paid invoice amount is not automatically MRR, ARR, recognized revenue, or revenue net of refunds. If the user requests one of those metrics, identify the necessary subscription, credit, refund, or accounting records instead of relabeling invoice totals. ## Discover and join 1. Use `list_sources`, `list_datasets`, and `describe_dataset` to find the actual logical relations and fields. Obtain company and deal IDs, company associations, stage, amount and currency; for invoices obtain customer ID, status, amount paid, currency and payment timestamp. 2. Check source freshness with `get_freshness`. A missing successful commit limits the available answer. 3. Find the explici