gistfile1.txt

https://api-dev.akashic.dhira.io/application/source_data_source/getInstanceSchema/v2

Payload:
{
    "type": "postgres",
    "source_data_source_id": 4194,
    "table_name": ""
}

Response:
[
    {
        "instance_details": [
            {
                "source_data_source_id": 4194,
                "roo_id": 4188,
                "username": "postgres",
                "password": "password",
                "endpoint": "52.36.76.75:7654?test_source",
                "database_name": "data_lake",
                "data_source_name": "postgres_Source_415",
                "data_source_type": "RDBMS",
                "data_source_instance": "postgres",
                "secret_key": "",
                "secret_key2": "",
                "path": "",
                "is_active": true,
                "created_datetime_timestamp": "2025-06-16T08:08:06.000741+00:00",
                "last_modified_datetime_timestamp": "2025-06-16T08:08:06.000741+00:00",
                "source_files": [
                    {
                        "source_file_id": 3901,
                        "file_name": "DimProduct",
                        "source_file_path": "",
                        "source_file_type": "table",
                        "authentication_method": "",
                        "payload_query": "",
                        "headers": "",
                        "request_type": "",
                        "params": "",
                        "source_file_fields": [
                            {
                                "source_file_field_id": 28893,
                                "field_name": "brand",
                                "field_data_type": "string",
                                "field_size": 1024,
                                "is_business_primary_key": false
                            },
                            {
                                "source_file_field_id": 28894,
                                "field_name": "category",
                                "field_data_type": "string",
                                "field_size": 1024,
                                "is_business_primary_key": false
                            },
                            {
                                "source_file_field_id": 28895,
                                "field_name": "created_dt",
                                "field_data_type": "timestamp",
                                "field_size": 0,
                                "is_business_primary_key": false
                            },
                            {
                                "source_file_field_id": 28896,
                                "field_name": "is_active",
                                "field_data_type": "boolean",
                                "field_size": 0,
                                "is_business_primary_key": false
                            },
                            {
                                "source_file_field_id": 28897,
                                "field_name": "is_deleted",
                                "field_data_type": "boolean",
                                "field_size": 0,
                                "is_business_primary_key": false
                            },
                            {
                                "source_file_field_id": 28898,
                                "field_name": "modified_dt",
                                "field_data_type": "timestamp",
                                "field_size": 0,
                                "is_business_primary_key": false
                            },
                            {
                                "source_file_field_id": 28899,
                                "field_name": "price",
                                "field_data_type": "float",
                                "field_size": 0,
                                "is_business_primary_key": false
                            },
                            {
                                "source_file_field_id": 28900,
                                "field_name": "product_id",
                                "field_data_type": "int",
                                "field_size": 0,
                                "is_business_primary_key": true
                            },
                            {
                                "source_file_field_id": 28901,
                                "field_name": "product_name",
                                "field_data_type": "string",
                                "field_size": 1024,
                                "is_business_primary_key": false
                            }
                        ]
                    }
                ]
            }
        ]
    }
]