SOAP-запрос:
<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><GetDataAreaSlice xmlns="http://www.fsight.ru/PP.SOM.Som"> <mon xmlns="">MFMABINKFPPDGOAEOBOOGFNHBKBGDINECKCPBCDFBECFODJM!M!S!PJGOCAMNKFPPDGOAEBKLCKKHMBCAFDKDEMLAJMEJFLDNGLJMJ!DataArea!DataSources!1!DataSourceSlices!1</mon>
<tArg xmlns=""> <k>1</k>
<pivotSlice><pivot><dims><its><it> <k>-1</k>
<id />
<n />
<dimMetadata><id> <id />
</id>
<data><selection> <selectedCount>-1</selectedCount>
</selection>
</data>
<els><id> <id />
</id>
</els>
</dimMetadata>
</it>
</its>
</dims>
</pivot>
</pivotSlice>
</tArg>
</GetDataAreaSlice>
</s:Body>
</s:Envelope>
SOAP-ответ:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><GetDataAreaSliceResult xmlns="http://www.fsight.ru/PP.SOM.Som" xmlns:q1="http://www.fsight.ru/PP.SOM.Som" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <k xmlns="">1</k>
<pivotSlice xmlns=""><pivot><dims><its><it> <k>339501</k>
<id>FACTS</id>
<n>Факты</n>
<dimMetadata><id> <id />
</id>
<data><obInst><obDesc ds="" isShortcut="0" isLink="0" ver="2" hf="0"> <i>FACTS</i>
<n>Факты</n>
<k>339501</k>
<c>1028</c>
<p>339499</p>
<h>0</h>
<hasPrv>0</hasPrv>
<ic>0</ic>
<trackElementDependents>0</trackElementDependents>
<isPermanent>1</isPermanent>
<isTemp>0</isTemp>
</obDesc>
<openArgs />
</obInst>
<selection> <selectedCount>1</selectedCount>
<schema> <k>-1</k>
<vis>1</vis>
<applyOnlyOnce>0</applyOnlyOnce>
<onceApplied>1</onceApplied>
<applyOnRebuild>0</applyOnRebuild>
</schema>
<allowToChangeElementGroup>1</allowToChangeElementGroup>
</selection>
<isAbacSecured>0</isAbacSecured>
</data>
<els> <els />
<totalCount>1</totalCount>
<id> <id />
</id>
<selectionInfo><firstSelected> <n>Значение</n>
<k>1</k>
<h>0</h>
<o>0</o>
</firstSelected>
<lastSelected> <n>Значение</n>
<k>1</k>
<h>0</h>
<o>0</o>
</lastSelected>
<selectedCount>1</selectedCount>
<schema> <k>-1</k>
<vis>1</vis>
<applyOnlyOnce>0</applyOnlyOnce>
<onceApplied>1</onceApplied>
<applyOnRebuild>0</applyOnRebuild>
</schema>
</selectionInfo>
</els>
</dimMetadata>
</it>
<it> <k>339497</k>
<id>OBJ339497</id>
<n>Календарь</n>
<dimMetadata><id> <id />
</id>
<data><obInst><obDesc ds="" isShortcut="0" isLink="0" ver="1" hf="0"> <i>OBJ339497</i>
<n>Календарь</n>
<k>339497</k>
<c>1026</c>
<p>339494</p>
<h>0</h>
<hasPrv>0</hasPrv>
<ic>0</ic>
<trackElementDependents>0</trackElementDependents>
<isPermanent>1</isPermanent>
<isTemp>0</isTemp>
</obDesc>
<openArgs />
</obInst>
<selection> <selectedCount>11</selectedCount>
<schema> <k>-1</k>
<vis>1</vis>
<applyOnlyOnce>0</applyOnlyOnce>
<onceApplied>1</onceApplied>
<applyOnRebuild>0</applyOnRebuild>
</schema>
<allowToChangeElementGroup>1</allowToChangeElementGroup>
</selection>
<isAbacSecured>0</isAbacSecured>
</data>
<els> <els />
<totalCount>11</totalCount>
<id> <id />
</id>
<selectionInfo><firstSelected> <n>2010</n>
<k>YEARS:2010</k>
<h>0</h>
<o>0</o>
</firstSelected>
<lastSelected> <n>2020</n>
<k>YEARS:2020</k>
<h>0</h>
<o>0</o>
</lastSelected>
<selectedCount>11</selectedCount>
<calendarPeriod> <active>0</active>
<start>2010-01-01</start>
<end>2020-12-31</end>
<levels> <it>Year</it>
</levels>
</calendarPeriod>
<schema> <k>-1</k>
<vis>1</vis>
<applyOnlyOnce>0</applyOnlyOnce>
<onceApplied>1</onceApplied>
<applyOnRebuild>0</applyOnRebuild>
</schema>
</selectionInfo>
</els>
</dimMetadata>
</it>
<it> <k>339495</k>
<id>OBJ339495</id>
<n>Справочник</n>
<dimMetadata><id> <id />
</id>
<data><obInst><obDesc ds="" isShortcut="0" isLink="0" ver="3" hf="0"> <i>OBJ339495</i>
<n>Справочник</n>
<k>339495</k>
<c>3076</c>
<p>339494</p>
<h>0</h>
<hasPrv>0</hasPrv>
<ic>0</ic>
<trackElementDependents>0</trackElementDependents>
<isPermanent>1</isPermanent>
<isTemp>0</isTemp>
</obDesc>
<openArgs />
</obInst>
<selection> <selectedCount>3</selectedCount>
<schema> <k>-1</k>
<vis>1</vis>
<applyOnlyOnce>0</applyOnlyOnce>
<onceApplied>1</onceApplied>
<applyOnRebuild>0</applyOnRebuild>
</schema>
<allowToChangeElementGroup>1</allowToChangeElementGroup>
</selection>
<isAbacSecured>0</isAbacSecured>
</data>
<els> <els />
<totalCount>3</totalCount>
<id> <id />
</id>
<selectionInfo><firstSelected> <n>Приход</n>
<k>1</k>
<h>0</h>
<o>0</o>
</firstSelected>
<lastSelected> <n>Остаток</n>
<k>3</k>
<h>0</h>
<o>0</o>
</lastSelected>
<selectedCount>3</selectedCount>
<schema> <k>-1</k>
<vis>1</vis>
<applyOnlyOnce>0</applyOnlyOnce>
<onceApplied>1</onceApplied>
<applyOnRebuild>0</applyOnRebuild>
</schema>
</selectionInfo>
</els>
</dimMetadata>
</it>
</its>
</dims>
<drillThrough>0</drillThrough>
</pivot>
</pivotSlice>
</GetDataAreaSliceResult>
</soapenv:Body>
</soapenv:Envelope>
JSON-запрос:
{
"GetDataAreaSlice" :
{
"mon" : "MFMABINKFPPDGOAEOBOOGFNHBKBGDINECKCPBCDFBECFODJM!M!S!PJGOCAMNKFPPDGOAEBKLCKKHMBCAFDKDEMLAJMEJFLDNGLJMJ!DataArea!DataSources!1!DataSourceSlices!1",
"tArg" :
{
"k" : "1",
"pivotSlice" :
{
"pivot" :
{
"dims" :
{
"its" :
{
"it" :
[
{
"k" : "-1",
"id" : "",
"n" : "",
"dimMetadata" :
{
"id" :
{
"id" : ""
},
"data" :
{
"selection" :
{
"selectedCount" : "-1"
}
},
"els" :
{
"id" :
{
"id" : ""
}
}
}
}
]
}
}
}
}
}
}
}
JSON-ответ:
{
"GetDataAreaSliceResult" :
{
"k" : "1",
"pivotSlice" :
{
"pivot" :
{
"dims" :
{
"its" :
{
"it" :
[
{
"k" : "339501",
"id" : "FACTS",
"n" : "Факты",
"dimMetadata" :
{
"id" :
{
"id" : ""
},
"data" :
{
"obInst" :
{
"obDesc" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "2",
"@hf" : "0",
"i" : "FACTS",
"n" : "Факты",
"k" : "339501",
"c" : "1028",
"p" : "339499",
"h" : "0",
"hasPrv" : "0",
"ic" : "0",
"trackElementDependents" : "0",
"isPermanent" : "1",
"isTemp" : "0"
},
"openArgs" : ""
},
"selection" :
{
"selectedCount" : "1",
"schema" :
{
"k" : "4294967295",
"vis" : "1",
"applyOnlyOnce" : "0",
"onceApplied" : "1",
"applyOnRebuild" : "0"
},
"allowToChangeElementGroup" : "1"
},
"isAbacSecured" : "0"
},
"els" :
{
"els" : "",
"totalCount" : "1",
"id" :
{
"id" : ""
},
"selectionInfo" :
{
"firstSelected" :
{
"n" : "Значение",
"k" : "1",
"h" : "0",
"o" : "0"
},
"lastSelected" :
{
"n" : "Значение",
"k" : "1",
"h" : "0",
"o" : "0"
},
"selectedCount" : "1",
"schema" :
{
"k" : "4294967295",
"vis" : "1",
"applyOnlyOnce" : "0",
"onceApplied" : "1",
"applyOnRebuild" : "0"
}
}
}
}
},
{
"k" : "339497",
"id" : "OBJ339497",
"n" : "Календарь",
"dimMetadata" :
{
"id" :
{
"id" : ""
},
"data" :
{
"obInst" :
{
"obDesc" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "1",
"@hf" : "0",
"i" : "OBJ339497",
"n" : "Календарь",
"k" : "339497",
"c" : "1026",
"p" : "339494",
"h" : "0",
"hasPrv" : "0",
"ic" : "0",
"trackElementDependents" : "0",
"isPermanent" : "1",
"isTemp" : "0"
},
"openArgs" : ""
},
"selection" :
{
"selectedCount" : "11",
"schema" :
{
"k" : "4294967295",
"vis" : "1",
"applyOnlyOnce" : "0",
"onceApplied" : "1",
"applyOnRebuild" : "0"
},
"allowToChangeElementGroup" : "1"
},
"isAbacSecured" : "0"
},
"els" :
{
"els" : "",
"totalCount" : "11",
"id" :
{
"id" : ""
},
"selectionInfo" :
{
"firstSelected" :
{
"n" : "2010",
"k" : "YEARS:2010",
"h" : "0",
"o" : "0"
},
"lastSelected" :
{
"n" : "2020",
"k" : "YEARS:2020",
"h" : "0",
"o" : "0"
},
"selectedCount" : "11",
"calendarPeriod" :
{
"active" : "0",
"start" : "2010-01-01",
"end" : "2020-12-31",
"levels" :
{
"it" : "Year"
}
},
"schema" :
{
"k" : "4294967295",
"vis" : "1",
"applyOnlyOnce" : "0",
"onceApplied" : "1",
"applyOnRebuild" : "0"
}
}
}
}
},
{
"k" : "339495",
"id" : "OBJ339495",
"n" : "Справочник",
"dimMetadata" :
{
"id" :
{
"id" : ""
},
"data" :
{
"obInst" :
{
"obDesc" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "3",
"@hf" : "0",
"i" : "OBJ339495",
"n" : "Справочник",
"k" : "339495",
"c" : "3076",
"p" : "339494",
"h" : "0",
"hasPrv" : "0",
"ic" : "0",
"trackElementDependents" : "0",
"isPermanent" : "1",
"isTemp" : "0"
},
"openArgs" : ""
},
"selection" :
{
"selectedCount" : "3",
"schema" :
{
"k" : "4294967295",
"vis" : "1",
"applyOnlyOnce" : "0",
"onceApplied" : "1",
"applyOnRebuild" : "0"
},
"allowToChangeElementGroup" : "1"
},
"isAbacSecured" : "0"
},
"els" :
{
"els" : "",
"totalCount" : "3",
"id" :
{
"id" : ""
},
"selectionInfo" :
{
"firstSelected" :
{
"n" : "Приход",
"k" : "1",
"h" : "0",
"o" : "0"
},
"lastSelected" :
{
"n" : "Остаток",
"k" : "3",
"h" : "0",
"o" : "0"
},
"selectedCount" : "3",
"schema" :
{
"k" : "4294967295",
"vis" : "1",
"applyOnlyOnce" : "0",
"onceApplied" : "1",
"applyOnRebuild" : "0"
}
}
}
}
}
]
}
},
"drillThrough" : "0"
}
}
}
}
public static DataAreaSlice GetDataAreaSlice(string moniker, uint sourceKey, uint sliceKey)
{
var somClient = new SomPortTypeClient(); // Прокси-объект для выполнения операций
// Параметры выполнения операции
var tSet = new GetDataAreaSlice()
{
tArg = new DataAreaSlice()
{
k = sliceKey,
pivotSlice = new DataAreaPivotSlice()
{
pivot = new PivotMetaData()
{
dims = new PivotDimensions()
{
its = new PivotDimension[]
{
new PivotDimension()
{
id = string.Empty,
n = string.Empty,
k = uint.MaxValue,
dimMetadata = new GetDimMetadataResult()
{
data = new DmMetadata()
{
selection = new DmSelectionMeta()
{
selectedCount = -1
}
},
els = new GetDimElementsResult()
{
id = new DmId() { id = string.Empty }
},
id = new DmId(){ id = string.Empty }
}
}
}
}
}
}
},
mon = moniker + "!DataArea!DataSources!" + sourceKey + "!DataSourceSlices!" + sliceKey
};
// Получение настроек среза аналитической области данных
var result = somClient.GetDataAreaSlice(tSet);
return result;
}