MuleSoft Connector for Stripe

Build 21.0.7930

InvoiceLineItems

Create, update, delete, and query the available invoices lines in Stripe.

Table Specific Information

Select

Server-Side Query Support

The connector will use the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client side within the connector.

  • Id, InvoiceId, Customer support the following operators: =.

The provider supports all columns to be used as criteria in the Where clause of Select statement, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retreive:

-an All InvoiceLineItems:

SELECT * FROM InvoiceLineItems 

-an InvoiceLineItems by specifying its Id:

SELECT * FROM InvoiceLineItems WHERE Id='or_12345678'

-InvoiceLineItems for a given Customer:

SELECT * FROM InvoiceLineItems WHERE Customer='cus_12345678'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The Id of the invoice item.

InvoiceId String False

Invoices.Id

The Id of the invoice.

Amount Int False

The amount, in cents.

Customer String False

Customers.Id

Three-letter ISO currency code, in lowercase. Must be a supported currency.

Currency String False

Three-letter ISO currency code, in lowercase. Must be a supported currency.

Description String False

An arbitrary string attached to the object. Often useful for displaying to users.

Discountable Boolean False

If true, discounts will apply to this line item. Always false for prorations.

PeriodStart Datetime False

The set of key/value pairs that you can attach to a customer object.

PeriodEnd Datetime False

The set of key/value pairs that you can attach to a customer object.

PlanId String False

The set of key/value pairs that you can attach to a customer object.

PlanAggregate String True

The plan of the subscription, if the line item is a subscription or a proration.

Proration Boolean True

Whether this is a proration.

Quantity Int False

The quantity of the subscription, if the line item is a subscription or a proration.

Subscription String False

When type is invoiceitem, the subscription that the invoice item pertains to, if any. Left blank when type is already subscription, as it'd be redundant with id.

MetadataAggregate String False

The metadata object.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
AccountId String

The Id of the connected account to get invoice line items for

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930