RelatedDataSourcesWithRelationshipsResult
| Field | NULL | Description | Note |
|---|---|---|---|
|
relatedDataSources array of objects |
An array of ReportDataSourceConnection objects | ||
|
selectedRealtionships array of objects |
An array of Relationship objects | Spelled as shown; this matches the property name the API returns. |
Sample:
{
"relatedDataSources": [
{
"serverTypeId": "00000000-0000-0000-0000-000000000001",
"serverTypeName": "MSSQL",
"id": "11111111-1111-1111-1111-111111111111",
"name": "Sample Connection",
"querySource": [
{
"id": "22222222-2222-2222-2222-222222222222",
"name": "SampleTable",
"originalName": "SampleTable",
"type": "Table",
"selected": false,
"visible": true,
"querySourceCategoryName": "dbo",
"connectionName": "Sample Connection",
"connectionId": "11111111-1111-1111-1111-111111111111",
"isAlias": false,
"isDynamic": false,
"fields": [
{
"name": "SampleFieldID",
"dataType": "nvarchar",
"izendaDataType": "Text",
"allowDistinct": true,
"visible": true,
"filterable": true,
"querySourceId": "22222222-2222-2222-2222-222222222222",
"id": "33333333-3333-3333-3333-333333333333"
}
],
"numOfChilds": 1,
"numOfCheckedChilds": 0
}
]
}
],
"selectedRealtionships": [
{
"joinConnectionId": "11111111-1111-1111-1111-111111111111",
"foreignConnectionId": "11111111-1111-1111-1111-111111111111",
"alias": "SampleTable (Self-Joined)",
"systemRelationship": false,
"joinType": "Inner",
"selectedForeignAlias": "22222222-2222-2222-2222-222222222222_SampleTable"
}
]
}