# Search Cardholder

## Search Cardholder

The Search Cardholder API produces a list of cardholder matching the search criteria, including card details.

The FirstName and LastName parameters are converted based on the following rules: i. All \* characters are replaced with % ii. All ? characters are replaced with \_ iii. All characters that are NOT a-zA-Z0-9\_% are removed

## Input Parameters:

| Name            | Required | Definition                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | Comments                                                                               |
| --------------- | -------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | -------------------------------------------------------------------------------------- |
| CardNumber      | C        | Format: Numeric, 4                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | relevant only if Indicator Type=CardPT or CardDOB or NameCard or CardDocID or CardDist |
| DateOfBirth     | C        | <p>Format: yyyy-mm-dd<br>Description: Cardholder must be above 17 years old</p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | relevant only if Indicator Type=CardDOB or DocIdDOB or NameDOB                         |
| DistributorName | C        | Format: Alphanumeric, 1-30                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | relevant only if Indicator Type=NameDist or CardDocID or CardDist                      |
| DocId           | C        | Format: Alphanumeric, 4                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | relevant only if Indicator Type=DocIdDOB                                               |
| FirstName       | C        | Format: Alphanumeric and \* , 2-20                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | relevant only if Indicator Type=NameDOB or NameCard or NameDist                        |
| IndicatorType   | Y        | <p>Format:<br>DocIdDOB – allow to search cardholder by DocId & Date of Birth fields<br>NameDOB – allow to search cardholder by First Name or Last Name & Date of Birth fields<br>CardDOB – allow to search cardholder by CardNumber & Date of Birth fields<br>CardPT – allow to search cardholder by CardNumber & PT fields<br>NameCard - allow to search cardholder by First Name or Last Name & card (4 last) fields<br>NameDist - allow to search cardholder by First Name or Last Name & Dist fields<br>CardDocID - - allow to search cardholder by card (last 4) & DocID (last 4) fields<br>CardDist - allow to search cardholder by card (last 4) & Dist fields<br><br>Description: Provide indication on which of the multiple options to execute</p> |                                                                                        |
| LastName        | C        | Format: Alphanumeric and \* , 2-20                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | relevant only if Indicator Type=NameDOB or NameCard or NameDist                        |
| PT              | C        | Format: Alphanumeric, 30                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | relevant only if Indicator Type=CardPT                                                 |

## Output Parameters:

| Name               | Definition                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | Failure Case | Success Case | Comments                                         |
| ------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------ | ------------ | ------------------------------------------------ |
| AddressLine1       | Format: Alphanumeric, 30                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| AddressLine2       | Format: Alphanumeric, 30                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| CardBalance        | Format: Numeric, 11                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| CardExpirationDate | Format: MMDD                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| CardNumber         | Format: Numeric, 16                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| CHState            | <p>Format options:<br>NRNV<br>RNV<br>V-PNS<br>V</p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| City               | Format: Alphanumeric, 20                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| Country            | <p>Format: ISO Country code. Two characters.<br>Description: Based on ISO 3166-1 alpha-2 list.<br><http://en.wikipedia.org/wiki/ISO_3166-1_alpha-2></p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| CurrentStatus      | <p>Format options:<br>CII<br>LOCKED\_CII<br>LOCK<br>ACT<br>SPND<br>LST<br>STLN<br>CC</p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| DateOfBirth        | <p>Format: yyyy-mm-dd<br>Description: Cardholder must be above 17 years old</p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| DocId              | Format: Alphanumeric, 4                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| DocType            | <p>Format options:<br>SSN<br>PASS<br>UDL<br>MCN<br>INMATE<br>Description: Closed list of values.Type of government identification document used: SSN- Social Security Number, PASS - Passport number, 'UDL' – US Drivers license number,'MCN' - Matricula consular ,INMATE.</p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| Email              | <p>Format: a-z (upper or lower), numbers, dash and underscore, 5-40<br>Description: Possible pattern: <x@x.x></p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| Fax                | <p>Format: Numeric, 6-10<br>Description: the fax number.</p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| FirstName          | Format: Alphanumeric, 10                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| MiddleInitial      | <p>Format: Alpha,1<br>Description: Middle name char of the cardholder.</p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| LastName           | Format: Alphanumeric, 15                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| Phone              | <p>Format: Numeric, 6-15<br>Description: Phone number</p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| PT                 | Format: Alphanumeric, 30                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| PTFriendlyName     | <p>Format: Alphanumeric, 1-120<br>Description: Product Type known name.</p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| State              | Format: Alphanumeric, 2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| Status             | <p>Format:<br>ACTIVE (default)<br>ALL</p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| StatusReasonCode   | <p>Format options:<br>CardExpired<br>CardReplaced<br>CIPException<br>CloseCardForDispute<br>Closed<br>ClosedByPM<br>Deceased<br>Excess-Chargeback<br>InsufficientKYC<br>InvalidArrowEyefiles<br>NegativeWriteOff<br>POBox<br>PrePurge<br>PurgedCard<br>PurgedFailedAtProcessor<br>ReadyToPrint<br><br>Arbitration<br>ByPM<br>CIPExceptionSus<br>Confirmed Fraud<br>Dispute<br>Lost<br>Lost-Stolen<br>Other<br>Poss Fraud<br>Poss Fraud Warm Address<br>Poss Fraud Warm Source IP<br>PrimaryCardSuspension<br>ProcSuspectedFraudWithNotes<br>ReDisputed<br>ReplaceFailure<br>ReplacementCardRequired<br>Represented<br>Stolen<br>StoreError<br>SuspectedFraud<br>TransactionCompletenessException<br>UnactivatedCard<br>UnactivatedReplacementCard<br>Violation</p>                                                                    | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| StatusReasonDesc   | <p>Format options:<br>Card Expired<br>Card Replaced<br>CIP Exception<br>Close Card Submited for Dispute<br>Closed<br>Closed By PM<br>Deceased<br>Excess-Chargeback<br>Insufficient KYC<br>Invalid Arrow Eye files<br>Negative Write-off<br>POBox<br>Pre Purge<br>Purged<br>Purged Failed At Processor<br>Ready To Print<br><br>Arbitration<br>By PM<br>CIP Exception<br>Confirmed Fraud<br>Dispute<br>Lost<br>Lost - Stolen<br>Other<br>Poss Fraud<br>Poss Fraud Warm Address<br>Poss Fraud Warm Source IP<br>Primary Card Suspension<br>Processor Suspected Fraud With Notes<br>Re-disputed<br>Replace Failure<br>Replacement Card Required<br>Represented<br>Stolen<br>Store error<br>Suspected Fraud<br>Suspected Fraud<br>Transaction Completeness Exception<br>Unactivated Card<br>Unactivated Replacement Card<br>Violation</p> | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |
| TotalRows          | Format: Alphanumeric, 5                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Not returned | Returned     |                                                  |
| Zip                | Format: Numeric, 5                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Not returned | Returned     | Returned as part of SearchResults/Cardholder tag |

## XML Samples

### Input XML

```json
<?xml version="1.0" ?>
<PraxellXMLRequest>
  <AuthenticationDetails>
    <UserName></UserName>
    <UserPassword></UserPassword>
    <ClientSourceIP></ClientSourceIP> 
 </AuthenticationDetails>;
  <ServiceDetails>
    <UniqueRequestId>920994</UniqueRequestId>
    <ServiceName>SearchCardholder</ServiceName>
  </ServiceDetails>
  <Origin>
    <OriginType>ExtAPI</OriginType>
  </Origin>
  <ServiceParams>
    <CardNumber></CardNumber>
    <IndicatorType>NameDOB</IndicatorType>
    <DateOfBirth>1980-01-01</DateOfBirth>
    <FirstName>Dan</FirstName>
    <LastName>Kraut</LastName>
  </ServiceParams>
</PraxellXMLRequest>
```

```json
<?xml version="1.0"?>
<PraxellXMLResponse>
     <ResponseDetails>
        <ServiceName>SearchCardholder</ServiceName>
        <SessionId>40433713200954111</SessionId>
        <StatusCode>0</StatusCode>
        <StatusName>StatusOK</StatusName>
        <StatusDescription>NA</StatusDescription>
        <ServiceDate>2009-11-19 13:54:16</ServiceDate>
        <ServiceId>40433713200954111</ServiceId>
    </ResponseDetails>
    <ResponseParams>
       <TotalRows>6</TotalRows>
       <SearchResults>
       <Cardholder>
          <FirstName>testSearch</FirstName>
          <MiddleInitial>a</MiddleInitial>
          <LastName>cardholders</LastName>
          <AddressLine1>gdxfxvx</AddressLine1>
          <AddressLine2>vcxvcx</AddressLine2>
          <City>vxvcx</City>
          <State>CO</State>
          <Zip>353544534</Zip>
          <Country>US</Country>
          <Phone>235432543253</Phone>
          <Fax></Fax>
          <DateOfBirth>1980-01-01 00:00:00.0</DateOfBirth>
          <Email>gfdgd@gffgfdg.fgd</Email>
          <DocId>100000000000</DocId>
          <DocType>DL</DocType>
          <CardNumber></CardNumber>
          <Status>ACT</Status>
          <StatusReasonCode></StatusReasonCode>
          <StatusReasonDesc>NA</StatusReasonDesc>
          <PT>1020</PT>
          <PTFriendlyName>Progreso Prepaid MasterCard (408) Flag - Sp</PTFriendlyName>
          <CHState>V-PNS</CHState>
       </Cardholder>
       <Cardholder>
          <FirstName>testSearch</FirstName>
          <MiddleInitial>a</MiddleInitial>
          <LastName>cardholders</LastName>
          <AddressLine1>vvvpppeee</AddressLine1>
          <AddressLine2>mnmnkd</AddressLine2>
          <City>nmnmdk</City>
          <State>CO</State>
          <Zip>353544534</Zip>
          <Country>US</Country>
          <Phone>235432543253</Phone>
          <Fax></Fax>
          <DateOfBirth>1980-01-01 00:00:00.0</DateOfBirth>
          <Email>gfdgd@gffgfdg.fgd</Email>
          <DocId>100000000000</DocId>
          <DocType>DL</DocType>
          <CardNumber></CardNumber>
          <Status>ACT</Status>
          <StatusReasonCode></StatusReasonCode>
          <StatusReasonDesc>NA</StatusReasonDesc>
          <PT>1020</PT>
          <PTFriendlyName>Progreso Prepaid MasterCard (408) Flag - Sp</PTFriendlyName>
          <CHState>V-PNS</CHState>
       </Cardholder>
       </SearchResults>
    </ResponseParams>
</PraxellXMLResponse>
```

```json
<?xml version="1.0"?>
<PraxellXMLResponse>
  <ResponseDetails>
    <ServiceName>SearchCardholder</ServiceName>
    <SessionId>07071612200737105</SessionId>
    <StatusCode>70029</StatusCode>
    <StatusName>Data not found (cardholder not found)</StatusName>
    <StatusDescription>Data not found (cardholder not found)</StatusDescription>
    <ServiceDate>2021-10-01 12:37:50</ServiceDate>
    <ServiceId>07071612200737105</ServiceId>
  </ResponseDetails>
  <ResponseParams>
  </ResponseParams>
</PraxellXMLResponse>
```


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://apidocs.juicefin.com/apis/card-status-and-management/search-cardholder.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
