CreateSatelliteAndItsMapping - POST
|
Path |
/api/projects/{projectId}/mappings/hubs/{hubMappingId}/satellites |
|---|---|
|
Http Method |
POST |
Overview
Required permissions
-
Write access to the Source module. source WRITE
Request
Request body
JSON
{
"satelliteColumns": [
"http://.../api/projects/0231c3594acd4abba267e66c50c98d72/metavault/sourcesystems/e605eb83-d483-4738-a56f-f5b848f2f54d/datapackages/d7d5c678-be2e-4ff9-b4d6-a2e6d40c37f9/tables/2ff90de59dab4c41b6499ab34ff5d739/columns/4708b9d354a04606863f1f0d9b293e18",
"http://.../api/projects/0231c3594acd4abba267e66c50c98d72/metavault/sourcesystems/e605eb83-d483-4738-a56f-f5b848f2f54d/datapackages/d7d5c678-be2e-4ff9-b4d6-a2e6d40c37f9/tables/2ff90de59dab4c41b6499ab34ff5d739/columns/a3f62bc3632d48d9a8b0b842234f896c",
"http://.../api/projects/0231c3594acd4abba267e66c50c98d72/metavault/sourcesystems/e605eb83-d483-4738-a56f-f5b848f2f54d/datapackages/d7d5c678-be2e-4ff9-b4d6-a2e6d40c37f9/tables/2ff90de59dab4c41b6499ab34ff5d739/columns/a82cd6f1030a4e1c9290c1bdaa509be6"
],
"satelliteName": "info",
"stagingTable": "http://.../api/projects/0231c3594acd4abba267e66c50c98d72/metavault/sourcesystems/e605eb83-d483-4738-a56f-f5b848f2f54d/datapackages/d7d5c678-be2e-4ff9-b4d6-a2e6d40c37f9/tables/2ff90de59dab4c41b6499ab34ff5d739",
"isMultiActive": true,
"subSequenceColumn": "http://.../api/projects/0231c3594acd4abba267e66c50c98d72/metavault/sourcesystems/e605eb83-d483-4738-a56f-f5b848f2f54d/datapackages/d7d5c678-be2e-4ff9-b4d6-a2e6d40c37f9/tables/2ff90de59dab4c41b6499ab34ff5d739/columns/a3f62bc3632d48d9a8b0b842234f896c"
}
Response
Success response (200 OK)
JSON
{
"_embedded": {
"satellite": {
"_embedded": {
"columns": [
{
"id": "98493854-67b9-447f-80e4-0dd3700dafdc",
"columnName": "mail",
"dataType": "String",
"typeFullName": "VARCHAR(255)",
"required": false,
"isComputed": false,
"order": 0,
"length": 255,
"isSequence": false
},
{
"id": "08e41cf8-a199-454a-b618-56bdac86f2ea",
"columnName": "team_name",
"dataType": "String",
"typeFullName": "VARCHAR(255)",
"required": false,
"isComputed": false,
"order": 1,
"length": 255,
"isSequence": false
},
{
"id": "0ea67a25-69f1-42a8-8987-6e463baa2352",
"columnName": "role",
"dataType": "String",
"typeFullName": "VARCHAR(255)",
"required": false,
"isComputed": false,
"order": 2,
"length": 255,
"isSequence": false
}
]
},
"id": "99ca9394-b51a-484f-9330-f35b4a41726b",
"name": "Employee_info2",
"displayName": "info2",
"businessDescription": "",
"technicalDescription": "",
"deployedInProduction": false,
"entityType": "Satellite",
"tableName": "dv.mash_Employee_info2",
"isMultiActive": true,
"subSequenceColumn": {
"id": "08e41cf8-a199-454a-b618-56bdac86f2ea",
"columnName": "team_name",
"dataType": "String",
"typeFullName": "VARCHAR(255)",
"required": false,
"isComputed": false,
"order": 1,
"length": 255,
"isSequence": false
}
}
},
"id": "a44183ae940340f99a30afd9f9b5a3b7",
"name": "D",
"hubId": "f81e889e-4d64-405f-bf3c-9ac317fb046c",
"satelliteId": "99ca9394-b51a-484f-9330-f35b4a41726b",
"parentName": "info2",
"mappingType": "Satellite",
"dataPackageTableId": "2ff90de59dab4c41b6499ab34ff5d739",
"satelliteParentMappingId": "dcf8486e5c4e4a36863cec2e7de96f53",
"satelliteColumnMappings": [
{
"satelliteColumnId": "98493854-67b9-447f-80e4-0dd3700dafdc",
"stagingTableColumnId": "4708b9d354a04606863f1f0d9b293e18"
},
{
"satelliteColumnId": "08e41cf8-a199-454a-b618-56bdac86f2ea",
"stagingTableColumnId": "a3f62bc3632d48d9a8b0b842234f896c"
},
{
"satelliteColumnId": "0ea67a25-69f1-42a8-8987-6e463baa2352",
"stagingTableColumnId": "a82cd6f1030a4e1c9290c1bdaa509be6"
}
],
"sourceSystemName": "Alpha 1",
"dataPackageName": "ALpHa1",
"dataPackageTableName": "ss1_dp1_employee_team"
}