Get Database Migrations
GET /obp/v7.0.0/system/migrations
OBPv6.0.0-getMigrations Roles: CanGetMigrations SystemAPI
Get all database migration script logs.
This endpoint returns information about all migration scripts that have been executed or attempted.
User Authentication is Required. The User must be logged in. The Application must also be authenticated.
CanGetMigrations entitlement is required.
JSON response body fields (11)
- commit_id
- commit_id
- created_at
- created_at
- duration_in_ms
- duration_in_ms
- end_date
- is_successful
- is_successful
- migration_script_log_id
- migration_script_log_id
- migration_script_logs
- migration_script_logs
- name
- ACCOUNT_MANAGEMENT_FEE
- remark
- remark
- start_date
- 2020-01-27
- updated_at
- updated_at
Example success response
{
"migration_script_logs": [
{
"migration_script_log_id": "550e8400-e29b-41d4-a716-446655440000",
"name": "addUniqueIndexOnResourceUserUserId",
"commit_id": "abc123def456",
"is_successful": true,
"start_date": 1640000000000,
"end_date": 1640000005000,
"duration_in_ms": 5000,
"remark": "Added UNIQUE index on resourceuser.userid_ field",
"created_at": "1100-01-01T00:00:00Z",
"updated_at": "1100-01-01T00:00:00Z"
}
]
}Possible errors (3)
- OBP-20001: User not logged in. Authentication is required!
- OBP-20006: User is missing one or more roles:
- OBP-50000: Unknown Error.