JDBC Driver for Stripe

Build 22.0.8462

Reports

To Create and Query the Report Run object, which represents an instance of a report type generated with specific run parameters.

Table Specific Information

Reports can be used to query all the reports or a specific report.

Note: It requires a live-mode API key which you can set using the LiveAPIKey connection property. The view will not be visible without mentioning the LiveAPIKey.

Select

Server-Side Query Support

The driver 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 driver.

  • Id supports the following operators: =,IN.

SELECT * FROM Reports WHERE Id = 'frr_1I480mATXQzBWNrlYQRaLQ9x'
SELECT * FROM Reports WHERE Id IN ('frr_1I14hXATXQzBWNrlGP5pSxd9', 'frr_1I14h9ATXQzBWNrlEG32QcPH')

Columns

Name Type References Description
Id [KEY] String Unique identifier for the object.
Created Datetime Time at which the object was created. Measured in seconds since the Unix epoch.
Error String If something should go wrong during the run, a message about the failure (populated when status=failed).
Livemode Boolean Always true: reports can only be run on live-mode data
Object String String representing the objects type. Objects of the same type share the same value.
ParametersIntervalEnd Datetime Ending timestamp of data to be included in the report run (exclusive).
ParametersIntervalStart Datetime Starting timestamp of data to be included in the report run.
ParametersColumns String The set of output columns requested for inclusion in the report run.
ParametersConnectedAccount String Connected account ID by which to filter the report run.
ParametersCurrency String Currency of objects to be included in the report run.
ParametersPayout String

Payouts.Id

Payout ID by which to filter the report run.
ParametersReportingCategory String Category of balance transactions to be included in the report run.
ParametersTimezone String Defaults to Etc/UTC. The output timezone for all timestamps in the report.
Report_type String The ID of the report type to run, such as balance.summary.1

The allowed values are balance_change_from_activity.itemized.1, balance_change_from_activity.itemized.2, balance_change_from_activity.itemized.3, balance_change_from_activity.summary.1, payouts.itemized.1, payouts.itemized.2, payouts.itemized.3, payouts.summary.1, balance.summary.1, ending_balance_reconciliation.itemized.1, ending_balance_reconciliation.itemized.2, ending_balance_reconciliation.itemized.3, ending_balance_reconciliation.summary.1, ending_balance_reconciliation.itemized.4, payout_reconciliation.by_id.itemized.1, payout_reconciliation.by_id.itemized.2, payout_reconciliation.by_id.itemized.3, payout_reconciliation.by_id.itemized.4, payout_reconciliation.by_id.summary.1, payout_reconciliation.itemized.1, payout_reconciliation.itemized.2, payout_reconciliation.itemized.3, payout_reconciliation.itemized.4, payout_reconciliation.summary.1, payout_reconciliation.itemized.5.

ResultCreated Datetime Time at which the object was created. Measured in seconds since the Unix epoch.
ResultExpiresAt Datetime The time at which the file expires and is no longer available in epoch seconds.
ResultFilename String A filename for the file, suitable for saving to a filesystem.
ResultId String Unique identifier for the object.
ResultLinksData String Details about each object.
ResultLinksHas_more Boolean True if this list has another page of items after this one that can be fetched.
ResultLinksObject String String representing the objects type. Objects of the same type share the same value. Always has the value list.
ResultLinksUrl String The URL where this list can be accessed.
ResultObject String String representing the objects type. Objects of the same type share the same value.
ResultPurpose String The purpose of the uploaded file.

The allowed values are account_requirement, additional_verification, business_icon, business_logo, customer_signature, dispute_evidence, identity_document, pci_document, tax_document_user_upload.

ResultSize Integer The size in bytes of the file object.
ResultTitle String A user friendly title for the document.
ResultType String The type of the file returned (e.g., csv, pdf, jpg, or png).
ResultUrl String The URL from which the file can be downloaded using your live secret API key.
Status String Status of this report run. This will be pending when the run is initially created. When the run finishes, this will be set to succeeded and the result field will be populated. Rarely, we may encounter an error, at which point this will be set to failed and the error field will be populated.
Succeeded_at Timestamp Timestamp at which this run successfully finished (populated when status=succeeded). Measured in seconds since the Unix epoch.
ResultLinksDataId String Unique identifier for the object.
ResultLinksDataObject String String representing the object's type. Objects of the same type share the same value.
ResultLinksDataCreated Timestamp Time at which the object was created. Measured in seconds since the Unix epoch.
ResultLinksDataExpired Boolean Whether this link is already expired.
ResultLinksDataExpiresAt Timestamp Time at which the link expires.
ResultLinksDataFile String The file object this link points to.
ResultLinksDataLivemode Boolean Has the value true if the object exists in live mode or the value false if the object exists in test mode.
ResultLinksDataMetaDataAggregate String Set of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format.
ResultLinksDataUrl String The URL where this list can be accessed.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462