SSIS Components for Stripe

Build 24.0.9062

Files

Retrieves a file hosted on Stripe's servers.

Table Specific Information

Select

The 本製品 uses the Stripe API to filter the results by the following columns and operators:

  • Id supports the following operator: =.
  • Purpose supports the following operator: =.
  • Created supports the following operators: >, >=, <, <=, =.
  • AccountId supports the following operator: =.

The rest of the filter is executed client-side within the 本製品.

You can select from Files with the following queries:

    SELECT * FROM Files WHERE Id = '123321'
    SELECT * FROM Files WHERE Purpose = 'dispute_evidence'
    SELECT * FROM Files WHERE Created >= '2023-07-14T05:36:46.000-04:00'

Columns

Name Type References Description
Id [KEY] String The id of files.
Created Datetime Time at which the object was created. Measured in seconds since the Unix epoch.
ExpiresAt Datetime The time at which the file expires and is no longer available in epoch seconds.
Filename String A filename for the file, suitable for saving to a filesystem.
Links String A list of file links that point at this file.
Purpose String The purpose of the uploaded file.
Size Integer The size in bytes of the file object.
Title String A user friendly title for the document.
Type String The type of the file returned (e.g., csv, pdf, jpg, or png).
Url String The URL from which the file can be downloaded using your live secret API key.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
AccountId String The Id of the connected account to get files for.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062