get
https://secure.fusebill.com/v1/Purchases/GetByProductId
Query, paginate, and sort purchases by product results.
This call supports querying, pagination, and sorting. For syntax and examples, see Pagination, Filtering, Sorting, and Event Suppression.
&query=parameterName:Value
| Parameter Name | Acceptable Values | Parameter Name | Acceptable Values |
|---|---|---|---|
Amount | Decimal Range | Customer.QuickBooksId | Integer |
CancellationTimestamp | Date Range | Customer.Reference | String |
CreatedTimestamp | Date Range | Customer.SalesforceId | String |
CustomerId | Integer | Customer.Status | Draft, Active, Cancelled, Hold, Suspended |
Customer.AccountStatus | Good, PoorStanding, Collection | Description | String |
Customer.Arbalance | Decimal Range | EarningInterval | Monthly, Yearly |
Customer.CompanyName | String | EarningNumberOfInterval | Integer |
Customer.CreatedTimestamp | Date Range | EarningTimingInterval | Daily, EarnImmediately, DoesNotEarn, Monthly, Yearly, Interval |
Customer.CurrencyId | Integer (1-24)* | EarningTimingType | StartOfInterval, EndOfInterval, DoesNotEarn |
Customer.CurrentMrr | Decimal Range | EffectiveTimestamp | Date Range |
Customer.CurrentNetMrr | Decimal Range | IsEarnedImmediately | Boolean |
Customer.CustomerReference.Reference1 | String | IsTrackingItems | Boolean |
Customer.CustomerReference.Reference2 | String | ModifiedTimestamp | Date Range |
Customer.CustomerReference.Reference3 | String | Name | String |
Customer.FirstName | String | PricingModelType | Standard, Tiered, Stairstep, Volume, Formula |
Customer.LastName | String | PurchaseTimestamp | Date Range |
Customer.MiddleName | String | Quantity | Decimal Range |
Customer.ModifiedTimestamp | Date Range | SalesforceId | String |
Customer.MonthlyRecurringRevenue | Decimal Range | Status | Draft, Purchased, Cancelled |
Customer.NetMRR | Decimal Range | targetOrderQuantity | Decimal Range |
Customer.NetSuiteId | String | TaxableAmount | Decimal Range |
Customer.ParentId | Integer |
* See here for Fusebill currency codes
Use &pageSize=10&pageNumber=0 for pagination.
Use &sortOrder=Ascending or &sortOrder=Descending with &sortExpression=expression for sorting.
