---
# System prepended metadata

title: FDC Pusdafil Host to Host v1.0.0
tags: [Task List, List Project]

---


![](https://i.imgur.com/YdqzegG.png)

![Python37](https://img.shields.io/badge/Python-v3.7-3776AB.svg?style=flat-square&logo=python) ![Jupyter](https://img.shields.io/badge/Jupyter-v1.0.0-F37626.svg?style=flat-square&logo=jupyter) ![Nginx](https://img.shields.io/badge/Nginx-v1.10.3-269539.svg?style=flat-square&logo=nginx) ![HTML](https://img.shields.io/badge/HTML-v5-E34F26.svg?style=flat-square&logo=html5) ![Docker](https://img.shields.io/badge/Docker-v2.1.0-1488C6.svg?style=flat-square&logo=docker)
###### 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": {...}
}
```
