# Inquiry Status

This API is used for inquiry detail member recurring. Merchants can receive the details of transaction members.

### URL EndPoint

<table><thead><tr><th width="733">URL - Development</th></tr></thead><tbody><tr><td><a href="https://fpg-sandbox.faspay.co.id/recurring/process/inquiry">https://fpg-sandbox.faspay.co.id/recurring/process/inquiry</a></td></tr></tbody></table>

### Request Parameter:&#x20;

{% tabs %}
{% tab title="Parameters" %}

<table><thead><tr><th width="145">Parameter</th><th width="131">Type</th><th width="83" align="center">M/O/C</th><th>Description</th></tr></thead><tbody><tr><td>request</td><td>Varchar</td><td align="center">O</td><td>Response Description</td></tr><tr><td>merchant_id</td><td>Varchar (32)</td><td align="center">M</td><td>Merchant Name</td></tr><tr><td>merchant</td><td>Numeric (5)</td><td align="center">M</td><td>Merchant Code</td></tr><tr><td>member_id</td><td>Varchar (50)</td><td align="center">M</td><td>Merchant's Member ID</td></tr><tr><td>signature</td><td>Varchar (50)</td><td align="center">M</td><td>sha1(md5(transaction account + transaction password + member_id))</td></tr></tbody></table>

*Notes:*&#x20;

M = Mandatory

O = Optional

C = Conditional
{% endtab %}

{% tab title="Sample Code Request" %}

```json
{
    "merchant_id":"99999",
    "merchant":"Sophia Store",
    "member_id":"20210726085543",
    "signature":"f2f80fe2d49f9a73a6cc6fe92c12776d41cc27b3"
}
```

{% endtab %}
{% endtabs %}

### Response Parameter:&#x20;

{% tabs %}
{% tab title="Parameters" %}

<table><thead><tr><th width="219">Parameter</th><th width="129">Data Type</th><th width="84" align="center">M/O/C</th><th>Description</th></tr></thead><tbody><tr><td>response</td><td>Varchar</td><td align="center">M</td><td>Response Description</td></tr><tr><td>merchant_id</td><td>Numeric (5)</td><td align="center">M</td><td>Merchant Code</td></tr><tr><td>merchant</td><td>Varchar (32)</td><td align="center">O</td><td>Merchant Name</td></tr><tr><td>member_id</td><td>Varchar (50)</td><td align="center">M</td><td>Merchant's Member ID</td></tr><tr><td>member_name</td><td>Varchar (50)</td><td align="center">M</td><td>Member name</td></tr><tr><td>member_email</td><td>Varchar (50)</td><td align="center">M</td><td>Member email</td></tr><tr><td>process_date</td><td>Varchar</td><td align="center">M</td><td><p>Process date = Date,Date (up to 9 times)</p><p>Process date, this parameters used for date of transaction and date of retry recurring if there is a failed recurring.</p><p>Sample :</p><p>process_date = "12,15,20,25,01,05,10". (Max 9 date)</p><p>12 is a date for register new recurring transaction date.</p><p>15,20,25,01,05,10 is a date for retry recurring if any failed recurring to this member.</p></td></tr><tr><td>recurring_amount</td><td>Varchar</td><td align="center">M</td><td>Recurring amount</td></tr><tr><td>recurring_start_date</td><td>Datetime</td><td align="center">M</td><td>Date = YYYY-MM-DD</td></tr><tr><td>recurring_end_date</td><td>Datetime</td><td align="center">M</td><td>Date = YYYY-MM-DD</td></tr><tr><td>recurring_period</td><td>Varchar (1)</td><td align="center">M</td><td><p>Recurring period</p><p>recurring_period_at Varchar (1) M Recurring period at</p><p>recurring_trx_id Varchar M Recurring transaction ID</p><p>transaction_id Numeric M ID of Transaction</p><p>transaction_reff Numeric (64) M Transaction reff</p><p>transaction_amount Numeric M Transaction amount</p><p>transaction_status Varchar (1) M Transaction status of payment S = Sales (Success) F = Failed A = Authorized C = Captured (confirm that the funds can be settled) B = Block CF = Captured Failed E = Error N = Not Yet Processed P = On Processed</p><p>recurring_trx_status Varchar(1) M Recurring transaction status</p><p>recurring_trx_attempt Numeric(1) M Recurring transaction attempt</p><p>total_trx Numeric M Total transaction of member</p><p>detail_trx Varchar M Details of transaction</p><p>trx_id Varchar (50) M Transaction ID of creditcard</p><p>trx_date Datetime M Format Datetime (YYYY-MM-DD hh:mm:ss)</p><p>amount Numeric M Amount of transaction</p><p>recurring_billing_date Datetime M Date YYYY-MM-DD hh:mm:ss</p><p>recurring_last_trx_date Datetime M Recurring last transaction date. Format Date YYYY-MM-DD hh:mm:ss</p><p>user_error_code Numeric (1) M User error code</p><p>user_error_desc Varchar (32) M User error Description</p><p>bank_error_code Numeric (1) M Bank error code 0: Success</p><p>bank_error_desc Varchar (32) M Bank error description</p><p>response_code Varchar (2) M Response code</p><p>response_desc Varchar (32) M Response description</p></td></tr></tbody></table>
{% endtab %}

{% tab title="Sample Code Response" %}

```json
{
    "merchant_id": "99999",
    "merchant": "Sophia Store",
    "member_id": "20220314085941",
    "member_name": "John Doe",
    "member_email": "john@gmail.com",
    "process_date": "26,27",
    "recurring_amount": "10000",
    "recurring_start_date": "2022-03-14 00:00:00",
    "recurring_end_date": "2022-08-14 00:00:00",
    "recurring_period": "D",
    "recurring_period_at": 1,
    "recurring_trx_id": 1160,
    "transaction_id": "2C4A74A2-4112-4597-BAF8-0055B0EA8879",
    "transaction_reff": "20220314085941",
    "transaction_amount": "10000",
    "transaction_status": "S",
    "recurring_trx_status": 1,
    "recurring_trx_attempt": 1,
    "total_trx": 2,
    "detail_trx": [
        {
            "trx_id": 1160,
            "trx_date": "2022-06-19 05:27:20",
            "amount": "10000"
        },
        {
            "trx_id": 1237,
            "trx_date": "2022-06-26 13:28:04",
            "amount": "10000"
        }
    ],
    "recurring_billing_date": "2022-06-19 05:27:20",
    "recurring_last_trx_date": "2022-03-14 15:00:18",
    "user_error_code": "0",
    "user_error_desc": "No error.",
    "bank_error_code": "0",
    "bank_error_desc": "Complete",
    "response_code": "00",
    "response_desc": "Success"
}
```

{% endtab %}
{% endtabs %}
