Persons
Usage information for the operation Persons.rsd.
Table Specific Information
Select
The 本製品 uses the Stripe API to filter the results by the following columns and operators:
- Id supports the following operator: =.
- Account supports the following operator: =.
- RelationshipDirector supports the following operator: =.
- RelationshipExecutive supports the following operator: =.
- RelationshipOwner supports the following operator: =.
- RelationshipLegalGuardian supports the following operator: =.
- RelationshipRepresentative supports the following operator: =.
The rest of the filter is executed client-side within the 本製品.
You can select from the Persons table with the following queries:
SELECT * FROM Persons WHERE Id = '123124' AND Account = 'acc_wr3r23r' SELECT * FROM Persons WHERE Account = 'acc_wr3r23r' SELECT * FROM Persons WHERE Account = 'acc_wr3r23r' AND RelationshipDirector = 'true' SELECT * FROM Persons WHERE Account = 'acc_wr3r23r' AND RelationshipExecutive = 'true' SELECT * FROM Persons WHERE Account = 'acc_wr3r23r' AND RelationshipOwner = 'true' SELECT * FROM Persons WHERE Account = 'acc_wr3r23r' AND RelationshipPercentOwnership = '35.5' SELECT * FROM Persons WHERE Account = 'acc_wr3r23r' AND RelationshipRepresentative = '35' SELECT * FROM Persons WHERE Account = 'acc_wr3r23r' AND RelationshipTitle = 'Owner'
Note:The Persons table does not return data for Standard connected accounts because these accounts are managed directly by the account holders through the Stripe Dashboard. Detailed personal information for these accounts is not accessible through the API. For access to personal data, consider using Express or Custom connected accounts, which allow more control for the platform managing the account.
Insert
To add new details to the Stripe account an Account value is required:
INSERT INTO Persons(Account, RegisteredAddressCity, RegisteredAddressCountry, RegisteredAddressLine1, RegisteredAddressLine2, RegisteredAddressPostalCode, RegisteredAddressState) values('acct_1OOtmyGdCIl7jorZ','jaipur','US','TestLine1','TestLine2','321001','Rajasthan')
Update
To modify details, specify the Person Id and associated Account Id:
UPDATE Persons SET RelationshipDirector='false' WHERE Id='123124' AND Account = 'acc_wr3r23r'
Delete
To delete details, specify the person Id:
DELETE FROM Persons WHERE Id='123124' and AccountId='123445'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
The Id of the person. | |
Account [KEY] | String | True |
The mode of the Checkout Session. | |
Created | Datetime | True |
The time at which the object was created. Measured in seconds since the Unix epoch. | |
DobDay | Integer | False |
The day of birth, between 1 and 31. | |
DobMonth | Integer | False |
The month of birth, between 1 and 12. | |
DobYear | Integer | False |
The four-digit year of birth. | |
String | False |
The person's email address. | ||
FirstName | String | False |
The person's first name. | |
LastName | String | False |
The person's last name. | |
MaidenName | String | False |
The person’s maiden name. | |
FutureRequirementsAlternatives | String | True |
Fields that are due and can be satisfied by providing the corresponding alternative fields instead. | |
FutureRequirementsCurrentlyDue | String | True |
Fields that need to be collected to keep the person's account enabled. | |
FutureRequirementsErrors | String | True |
Fields that are currently_due and need to be collected again because validation or verification failed. | |
FutureRequirementsEventuallyDue | String | True |
Fields that need to be collected, assuming all volume thresholds are reached. | |
FutureRequirementsPastDue | String | True |
Fields that were not collected by the account's requirements.current_deadline. | |
FutureRequirementsPendingVerification | String | True |
Fields that may become required, depending on the results of verification or review. | |
IdNumber | String | False |
The Id number. | |
IdNumberProvided | Boolean | True |
Whether the person's id_number was provided. | |
IdNumberSecondaryProvided | Boolean | True |
Whether the person’s id_number_secondary was provided. | |
Metadata | String | False |
The set of key/value pairs that you can attach to a value list object. | |
RelationshipDirector | Boolean | False |
Whether the person is a director of the account's legal entity. | |
RelationshipExecutive | Boolean | False |
Whether the person has significant responsibility to control, manage, or direct the organization. | |
RelationshipLegalGuardian | Boolean | False |
Whether the person is the legal guardian of the account’s representative. | |
RelationshipOwner | Boolean | False |
Whether the person is an owner of the account's legal entity. | |
RelationshipPercentOwnership | Double | False |
The percent owned by the person of the account's legal entity. | |
RelationshipRepresentative | Boolean | False |
Whether the person is authorized as the primary representative of the account. | |
RelationshipTitle | String | False |
The person's title | |
RequirementsAlternatives | String | True |
Fields that are due and can be satisfied by providing the corresponding alternative fields instead. | |
RequirementsCurrentlyDue | String | True |
Fields that need to be collected to keep the person's account enabled. | |
RequirementsErrors | String | True |
Fields that are currently_due and need to be collected again because validation or verification failed. | |
RequirementsEventuallyDue | String | True |
Fields that need to be collected assuming all volume thresholds are reached. | |
RequirementsPastDue | String | True |
Fields that were not collected by the account's requirements.current_deadline. | |
RequirementsPendingVerification | String | True |
Fields that may become required depending on the results of verification or review. If verification fails, these fields move to eventually_due or currently_due. | |
SsnLas4 | String | False |
The last 4 digits of the person's Social Security Number. | |
SsnLas4Provided | Boolean | True |
Whether the last four digits of the person's Social Security Number have been provided (U.S. only). | |
VerificationAdditionalDocumentBack | String | False |
The back of an Id returned by a file upload with a purpose value of identity_document. | |
VerificationAdditionalDocumentDetails | String | True |
A user-displayable string describing the verification state of this document. | |
VerificationAdditionalDocumentDetailsCode | String | True |
A machine-readable code specifying the verification state for this document. | |
VerificationAdditionalDocumentFront | String | False |
The front of an Id returned by a file upload with a purpose value of identity_document. | |
VerificationDetails | String | True |
A user-displayable string describing the verification state for the person. | |
VerificationDetailsCode | String | True |
A machine-readable code specifying the verification state for the person. | |
VerificationDocumentBack | String | False |
The back of an Id returned by a file upload with a purpose value of identity_document. | |
VerificationDocumentDetails | String | True |
A user-displayable string describing the verification state of this document. | |
VerificationDocumentDetailsCode | String | True |
A machine-readable code specifying the verification state for this document. | |
VerificationDocumentFront | String | False |
The front of an Id returned by a file upload with a purpose value of identity_document. | |
VerificationStatus | String | True |
The state of verification for the person. Possible values are unverified, pending, or verified. | |
AddressCity | String | False |
The City of the person. | |
AddressCountry | String | False |
The Country of the person. | |
AddressLine1 | String | False |
The Address line 1. | |
AddressLine2 | String | False |
The Address line 2. | |
AddressPostalCode | String | False |
The Postal code of the person. | |
AddressState | String | False |
The State of the person. | |
Phone | String | False |
The person’s phone number. | |
AdditionalTosAcceptancesAccountDate | Datetime | False |
Details on the legal guardian’s acceptance of the required Stripe agreements. The Unix timestamp marking when the account representative accepted the service agreement. | |
AdditionalTosAcceptancesAccountIp | String | False |
Details on the legal guardian’s acceptance of the required Stripe agreements. The IP address from which the account representative accepted the service agreement. | |
AdditionalTosAcceptancesAccountUserAgent | String | False |
Details on the legal guardian’s acceptance of the required Stripe agreements. The user agent of the browser from which the account representative accepted the service agreement. | |
Gender | String | False |
The person’s gender (International regulations require either “male” or “female”). | |
Nationality | String | False |
The country where the person is a national. | |
PoliticalExposure | String | False |
Indicates if the person or any of their representatives, family members, or other closely related persons, declares that they hold or have held an important public job or function, in any jurisdiction. 使用できる値は次のとおりです。existing, none | |
RegisteredAddressCity | String | False |
The person’s registered address. The City of the person. | |
RegisteredAddressCountry | String | False |
The person’s registered address. The Country of the person. | |
RegisteredAddressLine1 | String | False |
The person’s registered address. The Address line 1. | |
RegisteredAddressLine2 | String | False |
The person’s registered address. The Address line 2. | |
RegisteredAddressPostalCode | String | False |
The person’s registered address. The Postal code of the person. | |
RegisteredAddressState | String | False |
The person’s registered address. The State of the person. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
DocumentsCompanyAuthorizationFiles | String |
Documents that may be submitted to satisfy various informational requests. One or more documents that demonstrate proof that this person is authorized to represent the company. |
DocumentsPassportFiles | String |
Documents that may be submitted to satisfy various informational requests. One or more documents showing the person’s passport page with photo and personal data. |
DocumentsVisaFiles | String |
Documents that may be submitted to satisfy various informational requests. One or more documents showing the person’s visa required for living in the country where they are residing. |
FullNameAliases | String |
A list of alternate names or aliases that the person is known by. |
IdNumberSecondary | String |
The person’s secondary ID number, as appropriate for their country, will be used for enhanced verification checks. |
PersonToken | String |
A person token, used to securely provide details to the person. |