# Csv

## POST /clients/api/v1/csv/investors

> Upload and process CSV file for investor account creation

```json
{"openapi":"3.0.0","info":{"title":"Dalmore Clients API","version":"1"},"servers":[{"url":"https://platform.dalmoregroup.com"}],"security":[{"api_key":[]}],"components":{"securitySchemes":{"api_key":{"type":"apiKey","in":"header","name":"X-API-KEY"}}},"paths":{"/clients/api/v1/csv/investors":{"post":{"summary":"Upload and process CSV file for investor account creation","tags":["csv"],"parameters":[],"operationId":"uploadInvestorCsv","responses":{"200":{"description":"200","content":{"application/json":{"schema":{"type":"object","properties":{"totalRows":{"type":"number"},"successfulRows":{"type":"number"},"createdAccounts":{"type":"array","items":{"oneOf":[{"type":"object","properties":{"row":{"type":"number"},"userId":{"type":"string"},"investorAccountId":{"type":"string"}},"required":["row","userId","investorAccountId"]},{"type":"object","properties":{"row":{"type":"number"},"userId":{"type":"string"},"accountId":{"type":"string"}},"required":["row","userId","accountId"]}]}}},"required":["totalRows","successfulRows","createdAccounts"]}}}},"400":{"description":"400","content":{"application/json":{"schema":{"type":"object","properties":{"status":{"type":"number"},"message":{"type":"string"},"errors":{"type":"array","items":{"type":"string"}}},"required":["status","message","errors"]}}}},"401":{"description":"401","content":{"application/json":{"schema":{"type":"object","properties":{"status":{"type":"number"},"message":{"type":"string"},"errors":{"type":"array","items":{"type":"string"}}},"required":["status","message","errors"]}}}},"422":{"description":"422","content":{"application/json":{"schema":{"type":"object","properties":{"status":{"type":"number"},"message":{"type":"string"},"errors":{"type":"array","items":{"type":"string"}}},"required":["status","message","errors"]}}}},"500":{"description":"500","content":{"application/json":{"schema":{"type":"object","properties":{"status":{"type":"number"},"message":{"type":"string"},"errors":{"type":"array","items":{"type":"string"}}},"required":["status","message","errors"]}}}}}}}}}
```

## POST /clients/api/v1/csv/aic

> Upload and process CSV file for AIC questionnaire data

```json
{"openapi":"3.0.0","info":{"title":"Dalmore Clients API","version":"1"},"servers":[{"url":"https://platform.dalmoregroup.com"}],"security":[{"api_key":[]}],"components":{"securitySchemes":{"api_key":{"type":"apiKey","in":"header","name":"X-API-KEY"}}},"paths":{"/clients/api/v1/csv/aic":{"post":{"summary":"Upload and process CSV file for AIC questionnaire data","tags":["csv"],"parameters":[{"name":"accredited","in":"query","schema":{"type":"boolean","nullable":true}},{"name":"aicAccreditationType","in":"query","required":true,"schema":{"type":"string","enum":["PENDING","INCOME","NET_WORTH","PROFESSIONAL_CERTIFICATION","KNOWLEDGEABLE_EMPLOYEE"]}},{"name":"investorAccountId","in":"query","required":true,"schema":{"type":"string"}}],"operationId":"uploadAicCsv","responses":{"200":{"description":"200","content":{"application/json":{"schema":{"type":"object","properties":{"id":{"type":"string"},"__entity":{"type":"string"},"createdAt":{"oneOf":[{"type":"string","format":"date-time"},{"type":"string","format":"date-time"}]},"updatedAt":{"oneOf":[{"type":"string","format":"date-time"},{"type":"string","format":"date-time"}]},"deletedAt":{"oneOf":[{"type":"string","format":"date-time"},{"type":"string","format":"date-time"}],"nullable":true},"tid":{"type":"string","nullable":true},"accountId":{"type":"string"},"account":{},"investorAccountId":{"type":"string"},"investorAccount":{},"role":{"type":"string","enum":["PRIMARY","JOINT"]},"firstName":{"type":"string"},"lastName":{"type":"string","nullable":true},"dob":{"type":"string","format":"date-time","nullable":true},"isUsCitizenOrGreenCardHolder":{"type":"boolean"},"ssn":{"type":"string","nullable":true},"lastFour":{"type":"string","nullable":true},"address":{"type":"string","nullable":true},"address2":{"type":"string","nullable":true},"email":{"type":"string","format":"email","nullable":true},"phone":{"type":"string","nullable":true},"city":{"type":"string","nullable":true},"country":{"type":"string","nullable":true},"citizenship":{"type":"string","nullable":true},"state":{"type":"string","nullable":true},"zip":{"type":"string","nullable":true},"currencyCode":{"type":"string","minLength":3,"maxLength":3,"nullable":true},"financialAdvisor":{"type":"boolean"},"occupation":{"type":"string","nullable":true},"employmentStatus":{"type":"string","enum":["EMPLOYED","UNEMPLOYED","SELF_EMPLOYED","RETIRED","STUDENT","OTHER"]},"employerName":{"type":"string","nullable":true},"employerAddressLine1":{"type":"string","nullable":true},"employerAddressLine2":{"type":"string","nullable":true},"employerCity":{"type":"string","nullable":true},"employerState":{"type":"string","nullable":true},"employerZip":{"type":"string","nullable":true},"employerCountry":{"type":"string","nullable":true},"kycDocumentType":{"type":"string","enum":["PASSPORT","DRIVER_LICENSE","STATE_ID"],"nullable":true},"kycDocumentIssuer":{"type":"string","nullable":true},"kycExpirationDate":{"type":"string","nullable":true},"kycIssuerDate":{"type":"string","nullable":true},"kycDocumentNumber":{"type":"string","nullable":true},"kycFirstName":{"type":"string","nullable":true},"kycLastName":{"type":"string","nullable":true},"ownership":{"type":"number","nullable":true},"householdNetWorth":{"type":"number","nullable":true},"liquidNetWorth":{"type":"number","multipleOf":0.01,"nullable":true},"currentHouseholdIncome":{"type":"number","nullable":true},"currentAnnualIncome":{"type":"number","nullable":true},"investedInCrowdfunding":{"type":"number","nullable":true},"setupStatus":{"type":"string","enum":["IN_PROGRESS","COMPLETE"]},"setupStep":{"type":"string","enum":["NEW","PERSONAL_INFO","ADDRESS","KYC","INCOME","AIC_QUESTIONS","AIC_FILES"]},"sourceOfIncome":{"type":"string","enum":["EMPLOYED","SELF_EMPLOYED","UNEMPLOYED","RETIREMENT","STUDENT"],"nullable":true},"aicQuestionnaire":{"type":"string","nullable":true},"kycStatus":{"type":"string","enum":["NEEDS_REVIEW","PENDING","APPROVED","REJECTED","CANCELLED","RESUBMIT","ERROR"]},"kycProvider":{"type":"string","nullable":true},"kycTid":{"type":"string","nullable":true},"aicAccreditationType":{"type":"string","enum":["PENDING","INCOME","NET_WORTH","PROFESSIONAL_CERTIFICATION","KNOWLEDGEABLE_EMPLOYEE"]},"accredited":{"type":"boolean"},"retirementAccountType":{"type":"string","enum":["SELF_DIRECTED","CUSTODIAN_MANAGED"],"nullable":true},"custodianName":{"type":"string","nullable":true},"custodianAccountNumber":{"type":"string","nullable":true},"custodianRepresentativeName":{"type":"string","nullable":true},"custodianEmail":{"type":"string","format":"email","nullable":true}},"required":["id","createdAt","updatedAt","deletedAt","tid","accountId","investorAccountId","role","firstName","lastName","dob","isUsCitizenOrGreenCardHolder","ssn","lastFour","address","address2","email","phone","city","country","citizenship","state","zip","currencyCode","financialAdvisor","occupation","employmentStatus","employerName","employerAddressLine1","employerAddressLine2","employerCity","employerState","employerZip","employerCountry","kycDocumentType","kycDocumentIssuer","kycExpirationDate","kycIssuerDate","kycDocumentNumber","kycFirstName","kycLastName","ownership","householdNetWorth","liquidNetWorth","currentHouseholdIncome","currentAnnualIncome","investedInCrowdfunding","setupStatus","setupStep","sourceOfIncome","aicQuestionnaire","kycStatus","kycProvider","kycTid","aicAccreditationType","accredited","retirementAccountType","custodianName","custodianAccountNumber","custodianRepresentativeName","custodianEmail"]}}}},"400":{"description":"400","content":{"application/json":{"schema":{"type":"object","properties":{"status":{"type":"number"},"message":{"type":"string"},"errors":{"type":"array","items":{"type":"string"}}},"required":["status","message","errors"]}}}},"401":{"description":"401","content":{"application/json":{"schema":{"type":"object","properties":{"status":{"type":"number"},"message":{"type":"string"},"errors":{"type":"array","items":{"type":"string"}}},"required":["status","message","errors"]}}}},"404":{"description":"404","content":{"application/json":{"schema":{"type":"object","properties":{"status":{"type":"number"},"message":{"type":"string"},"errors":{"type":"array","items":{"type":"string"}}},"required":["status","message","errors"]}}}},"500":{"description":"500","content":{"application/json":{"schema":{"type":"object","properties":{"status":{"type":"number"},"message":{"type":"string"},"errors":{"type":"array","items":{"type":"string"}}},"required":["status","message","errors"]}}}}}}}}}
```

## POST /clients/api/v1/csv/kyc

> Upload and process CSV file for KYC data

```json
{"openapi":"3.0.0","info":{"title":"Dalmore Clients API","version":"1"},"servers":[{"url":"https://platform.dalmoregroup.com"}],"security":[{"api_key":[]}],"components":{"securitySchemes":{"api_key":{"type":"apiKey","in":"header","name":"X-API-KEY"}}},"paths":{"/clients/api/v1/csv/kyc":{"post":{"summary":"Upload and process CSV file for KYC data","tags":["csv"],"parameters":[{"name":"individualId","in":"query","required":true,"schema":{"type":"string"}},{"name":"frontFileId","in":"query","required":true,"schema":{"type":"string"}},{"name":"backFileId","in":"query","schema":{"type":"string"}},{"name":"selfieFileId","in":"query","schema":{"type":"string"}}],"operationId":"uploadKycCsv","responses":{"200":{"description":"200","content":{"application/json":{"schema":{"type":"object","properties":{"id":{"type":"string"},"__entity":{"type":"string"},"createdAt":{"oneOf":[{"type":"string","format":"date-time"},{"type":"string","format":"date-time"}]},"updatedAt":{"oneOf":[{"type":"string","format":"date-time"},{"type":"string","format":"date-time"}]},"deletedAt":{"oneOf":[{"type":"string","format":"date-time"},{"type":"string","format":"date-time"}],"nullable":true},"tid":{"type":"string","nullable":true},"platform":{"type":"string"},"individualId":{"type":"string"},"documentType":{"type":"string"},"documentImage":{"type":"string"},"kycStatus":{"type":"string","enum":["NEEDS_REVIEW","PENDING","APPROVED","REJECTED","CANCELLED","RESUBMIT","ERROR"]},"reason":{"type":"string","nullable":true},"response":{"type":"string","nullable":true}},"required":["id","createdAt","updatedAt","deletedAt","tid","platform","individualId","documentType","documentImage","kycStatus","reason","response"]}}}},"400":{"description":"400","content":{"application/json":{"schema":{"type":"object","properties":{"status":{"type":"number"},"message":{"type":"string"},"errors":{"type":"array","items":{"type":"string"}}},"required":["status","message","errors"]}}}},"401":{"description":"401","content":{"application/json":{"schema":{"type":"object","properties":{"status":{"type":"number"},"message":{"type":"string"},"errors":{"type":"array","items":{"type":"string"}}},"required":["status","message","errors"]}}}},"404":{"description":"404","content":{"application/json":{"schema":{"type":"object","properties":{"status":{"type":"number"},"message":{"type":"string"},"errors":{"type":"array","items":{"type":"string"}}},"required":["status","message","errors"]}}}},"500":{"description":"500","content":{"application/json":{"schema":{"type":"object","properties":{"status":{"type":"number"},"message":{"type":"string"},"errors":{"type":"array","items":{"type":"string"}}},"required":["status","message","errors"]}}}}}}}}}
```

## POST /clients/api/v1/csv/issuers

> Upload and process CSV file for issuer account creation

```json
{"openapi":"3.0.0","info":{"title":"Dalmore Clients API","version":"1"},"servers":[{"url":"https://platform.dalmoregroup.com"}],"security":[{"api_key":[]}],"components":{"securitySchemes":{"api_key":{"type":"apiKey","in":"header","name":"X-API-KEY"}}},"paths":{"/clients/api/v1/csv/issuers":{"post":{"summary":"Upload and process CSV file for issuer account creation","tags":["csv"],"parameters":[],"operationId":"uploadIssuerCsv","responses":{"200":{"description":"200","content":{"application/json":{"schema":{"type":"object","properties":{"totalRows":{"type":"number"},"successfulRows":{"type":"number"},"createdAccounts":{"type":"array","items":{"oneOf":[{"type":"object","properties":{"row":{"type":"number"},"userId":{"type":"string"},"investorAccountId":{"type":"string"}},"required":["row","userId","investorAccountId"]},{"type":"object","properties":{"row":{"type":"number"},"userId":{"type":"string"},"accountId":{"type":"string"}},"required":["row","userId","accountId"]}]}}},"required":["totalRows","successfulRows","createdAccounts"]}}}},"400":{"description":"400","content":{"application/json":{"schema":{"type":"object","properties":{"status":{"type":"number"},"message":{"type":"string"},"errors":{"type":"array","items":{"type":"string"}}},"required":["status","message","errors"]}}}},"401":{"description":"401","content":{"application/json":{"schema":{"type":"object","properties":{"status":{"type":"number"},"message":{"type":"string"},"errors":{"type":"array","items":{"type":"string"}}},"required":["status","message","errors"]}}}},"422":{"description":"422","content":{"application/json":{"schema":{"type":"object","properties":{"status":{"type":"number"},"message":{"type":"string"},"errors":{"type":"array","items":{"type":"string"}}},"required":["status","message","errors"]}}}},"500":{"description":"500","content":{"application/json":{"schema":{"type":"object","properties":{"status":{"type":"number"},"message":{"type":"string"},"errors":{"type":"array","items":{"type":"string"}}},"required":["status","message","errors"]}}}}}}}}}
```

## POST /clients/api/v1/csv/offering

> Upload and process CSV file for offering creation

```json
{"openapi":"3.0.0","info":{"title":"Dalmore Clients API","version":"1"},"servers":[{"url":"https://platform.dalmoregroup.com"}],"security":[{"api_key":[]}],"components":{"securitySchemes":{"api_key":{"type":"apiKey","in":"header","name":"X-API-KEY"}}},"paths":{"/clients/api/v1/csv/offering":{"post":{"summary":"Upload and process CSV file for offering creation","tags":["csv"],"parameters":[{"name":"issuerId","in":"query","required":true,"schema":{"type":"string"}}],"operationId":"uploadOfferingCsv","responses":{"200":{"description":"200","content":{"application/json":{"schema":{}}}},"400":{"description":"400","content":{"application/json":{"schema":{"type":"object","properties":{"status":{"type":"number"},"message":{"type":"string"},"errors":{"type":"array","items":{"type":"string"}}},"required":["status","message","errors"]}}}},"401":{"description":"401","content":{"application/json":{"schema":{"type":"object","properties":{"status":{"type":"number"},"message":{"type":"string"},"errors":{"type":"array","items":{"type":"string"}}},"required":["status","message","errors"]}}}},"404":{"description":"404","content":{"application/json":{"schema":{"type":"object","properties":{"status":{"type":"number"},"message":{"type":"string"},"errors":{"type":"array","items":{"type":"string"}}},"required":["status","message","errors"]}}}},"500":{"description":"500","content":{"application/json":{"schema":{"type":"object","properties":{"status":{"type":"number"},"message":{"type":"string"},"errors":{"type":"array","items":{"type":"string"}}},"required":["status","message","errors"]}}}}}}}}}
```