List Purchases By Product

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 NameAcceptable ValuesParameter NameAcceptable Values
AmountDecimal RangeCustomer.QuickBooksIdInteger
CancellationTimestampDate RangeCustomer.ReferenceString
CreatedTimestampDate RangeCustomer.SalesforceIdString
CustomerIdIntegerCustomer.StatusDraft, Active, Cancelled, Hold, Suspended
Customer.AccountStatusGood, PoorStanding, CollectionDescriptionString
Customer.ArbalanceDecimal RangeEarningIntervalMonthly, Yearly
Customer.CompanyNameStringEarningNumberOfIntervalInteger
Customer.CreatedTimestampDate RangeEarningTimingIntervalDaily, EarnImmediately, DoesNotEarn, Monthly, Yearly, Interval
Customer.CurrencyIdInteger (1-24)*EarningTimingTypeStartOfInterval, EndOfInterval, DoesNotEarn
Customer.CurrentMrrDecimal RangeEffectiveTimestampDate Range
Customer.CurrentNetMrrDecimal RangeIsEarnedImmediatelyBoolean
Customer.CustomerReference.Reference1StringIsTrackingItemsBoolean
Customer.CustomerReference.Reference2StringModifiedTimestampDate Range
Customer.CustomerReference.Reference3StringNameString
Customer.FirstNameStringPricingModelTypeStandard, Tiered, Stairstep, Volume, Formula
Customer.LastNameStringPurchaseTimestampDate Range
Customer.MiddleNameStringQuantityDecimal Range
Customer.ModifiedTimestampDate RangeSalesforceIdString
Customer.MonthlyRecurringRevenueDecimal RangeStatusDraft, Purchased, Cancelled
Customer.NetMRRDecimal RangetargetOrderQuantityDecimal Range
Customer.NetSuiteIdStringTaxableAmountDecimal Range
Customer.ParentIdInteger

* See here for Fusebill currency codes
Use &pageSize=10&pageNumber=0 for pagination.
Use &sortOrder=Ascending or &sortOrder=Descending with &sortExpression=expression for sorting.

Query Params
int32
required

This is the Fusebill generated ID of the product available for purchase.

Responses

Language
Credentials
Header
LoadingLoading…
Response
Choose an example:
application/json