
    
###### tags: `List Project`
# FDC Pusdafil Host to Host v1.0.0
###### tags: `Task List`
[TOC]
## GIT Repository
- [FDC Pusdafil Host to Host](https://gitlab.uangteman.com/data-science/fdc-pusdafil-host-to-host)
## Credentials
PATH : `/apps/config/config.yml`
```yaml=
version: '2.0.0'
env: 'development'
fdc_env: 'production'
database:
production:
host: '192.168.1.150'
port: '5432'
user: 'admin'
pass: ';nPv\V/Xy38$5Dea'
db_name: 'utwbprod2019'
staging:
host: '192.168.1.150'
port: '5432'
user: 'admin'
pass: ';nPv\V/Xy38$5Dea'
db_name: 'utwbprod2019'
development:
host: '192.168.1.150'
port: '5432'
user: 'admin'
pass: ';nPv\V/Xy38$5Dea'
db_name: 'utwbprod2019'
credential_api:
production:
username: 'devops@uangteman.com'
password: 'RUnQW6#EBWNzXl0hO9Rr9[m7EmnDZBqFtVcDkn'
staging:
username: 'devops@uangteman.com'
password: 'RUnQW6#EBWNzXl0hO9Rr9[m7EmnDZBqFtVcDkn'
development:
username: 'devops@uangteman.com'
password: 'RUnQW6#EBWNzXl0hO9Rr9[m7EmnDZBqFtVcDkn'
secret_key:
production: "FdCP3f1nd0U4n6T3m4n!@#45"
stagging: "FdCP3f1nd0U4n6T3m4n!@#45"
development: "FdCP3f1nd0U4n6T3m4n!@#45"
api_token:
production:
- "2ZwS5vBtrJdUwZsjqkMJdTLzdrCeEzD8"
- "kgzzWjRqTSP3zua2H5k4MCGVTEmBL2Q4"
- "rnm4v9zWfp5Rv5jVqAsaefv3Ktx3HyEY"
- "uf5eJD3395WR9DMQdbURvC4r9bruSCue"
- "Rup67BqTL6gDsr3mxLAYXCAFWyFKbqdP"
stagging:
- "twWZ7GKHCDZ2cJ5qm7HQTxycH9N27MSg"
- "mWjeUhxRYeR869VeVUrBbNcNyrHTSDUP"
- "sSBDFAnw8LccRPpYdQ72DdxUP3E7ntyn"
- "DgnMzXcYq8deEmy2HL8eTWBRQttM5MEG"
- "np5MgMKPu9Zz9f7HKAgK6gTDhD3L3tmM"
development:
- "pm8tASRPetPcVL5Fx6mgUDKXnzHTFXQv"
- "YJsAqgYCAUQvswhqH5kRtcnQ6kCRm93s"
- "dHPWJJWUWbxE2CJfkHk2qtCYRC395bLs"
- "TYyjWyZM5RBsYM3AMVtXEnPupQn67KAM"
- "5HYSSqW6fZsM962ZvBnqT3cFYaqwATyq"
slack_bot:
url: "https://hooks.slack.com/services/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"
```
## CREATE TABLE
```sql
CREATE TABLE "ut-thirdparty".ut_fdc_pusdafil (
id serial NOT NULL,
identity_card varchar(128) NULL,
app_loan_id varchar(128) NULL,
fdc_status varchar(128) NULL,
paid_status int NULL,
od_status int NULL,
wo_status int NULL,
nilai_pendanaan float null,
sisa_pinjaman_berjalan float null,
data_json text NULL,
created_at timestamp NULL DEFAULT now(),
updated_at timestamp NULL DEFAULT now(),
CONSTRAINT ut_fdc_pusdafil_pkey PRIMARY KEY (id)
);
```
## API Service
### Requests
---
#### Ping
- Host:
- Development: `http://localhost:8000`
- Staging: `https://mvp.uangteman.com`
- Endpoint: `/fdc-pusdafil/ping`
- Method: `GET`
- Return : `1.0.0` (Apps version)
---
#### Inquiry
- Host:
- Development: `http://localhost:8000`
- Staging: `https://mvp.uangteman.com`
- Endpoint: `/fdc-pusdafil/inquiry`
- Method: `POST`
- Headers:
|Key|Value||
|---|---|---|
|X-Api-Token|`xxx`|Based on credentials (api_token)|
- Body :
```json
{
"identity_card": "3XXXXXXX",
"app_loan_id": "P0XXXX",
"detail": True / False
}
```
- Return
```json
{
"status": 200,
"message": "Success",
"data": {...}
}
```