SOAP request:
<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"><SetEtl xmlns="http://www.fsight.ru/PP.SOM.Som"><tEtl xmlns=""> <id>S1!M!S!L1</id>
</tEtl>
<tArg xmlns=""><pattern> <obInst>true</obInst>
<objects>Add</objects>
<object> <settings>true</settings>
<provider> <props>true</props>
</provider>
</object>
</pattern>
<meta><objects><its><it> <k>0</k>
<id>REPO_PROVIDER</id>
<vis>true</vis>
<type>PlainDataMetabaseProvider</type>
<settings><plainProvider><provider><props> <type>Mb</type>
<mb><dataset> <i>T_INDICATOR</i>
<n>Table</n>
<k>7013</k>
<c>769</c>
</dataset>
</mb>
</props>
</provider>
<fillFields>FromSource</fillFields>
</plainProvider>
</settings>
</it>
</its>
</objects>
</meta>
<metaGet> <obInst>true</obInst>
<objects>Get</objects>
<objectsFilter><range> <start>3</start>
<count>1</count>
</range>
</objectsFilter>
<object> <settings>true</settings>
<provider> <fields>true</fields>
</provider>
<fields>Get</fields>
</object>
</metaGet>
</tArg>
</SetEtl>
</s:Body>
</s:Envelope>
SOAP response:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><SetEtlResult 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"><id xmlns=""> <id>S1!M!S!L1</id>
</id>
<meta xmlns=""><obInst><obDesc ds="" isShortcut="0" isLink="0" ver="3" hf="0"> <i>ETL_INDICATOR</i>
<n>ETL task for factor loading</n>
<k>7012</k>
<c>4097</c>
<p>7011</p>
<h>0</h>
<hasPrv>0</hasPrv>
<ic>0</ic>
<isPermanent>1</isPermanent>
<isTemp>0</isTemp>
</obDesc>
</obInst>
<dirty>1</dirty>
<objects><its><it> <k>3</k>
<id>REPO_PROVIDER</id>
<n>Repository provider1</n>
<vis>1</vis>
<type>PlainDataMetabaseProvider</type>
<obDesc ds="" isShortcut="0" isLink="0" ver="0" hf="0"> <i>T_INDICATOR</i>
<n>Table</n>
<k>7013</k>
<c>769</c>
<p>7011</p>
<h>0</h>
<hasPrv>0</hasPrv>
<ic>0</ic>
</obDesc>
<read>1</read>
<write>1</write>
<settings><plainProvider><provider><fields><its><it> <k>1</k>
<id>FKEY</id>
<n>FKey</n>
<vis>1</vis>
<dt>2</dt>
<dd>0</dd>
<size>10</size>
<precision>0</precision>
<expression />
<calculated>0</calculated>
<dateFormat>DMY</dateFormat>
</it>
<it> <k>2</k>
<id>FNAME</id>
<n>FName</n>
<vis>1</vis>
<dt>1</dt>
<dd>0</dd>
<size>255</size>
<precision>0</precision>
<expression />
<calculated>0</calculated>
<dateFormat>DMY</dateFormat>
</it>
<it> <k>3</k>
<id>ORD</id>
<n>Ord</n>
<vis>1</vis>
<dt>2</dt>
<dd>0</dd>
<size>10</size>
<precision>0</precision>
<expression />
<calculated>0</calculated>
<dateFormat>DMY</dateFormat>
</it>
<it> <k>4</k>
<id>FID</id>
<n>FId</n>
<vis>1</vis>
<dt>1</dt>
<dd>0</dd>
<size>255</size>
<precision>0</precision>
<expression />
<calculated>0</calculated>
<dateFormat>DMY</dateFormat>
</it>
</its>
</fields>
</provider>
<fetchBlockSize>-1</fetchBlockSize>
<ignoreIncorrectVals>0</ignoreIncorrectVals>
<unpivotMode>0</unpivotMode>
</plainProvider>
</settings>
</it>
</its>
</objects>
<shapes />
</meta>
</SetEtlResult>
</soapenv:Body>
</soapenv:Envelope>
JSON request:
{
"SetEtl" :
{
"tEtl" :
{
"id" : "S1!M!S!L1"
},
"tArg" :
{
"pattern" :
{
"obInst" : "true",
"objects" : "Add",
"object" :
{
"settings" : "true",
"provider" :
{
"props" : "true"
}
}
},
"meta" :
{
"objects" :
{
"its" :
{
"it" :
[
{
"k" : "0",
"id" : "REPO_PROVIDER",
"vis" : "true",
"type" : "PlainDataMetabaseProvider",
"settings" :
{
"plainProvider" :
{
"provider" :
{
"props" :
{
"type" : "Mb",
"mb" :
{
"dataset" :
{
"i" : "T_INDICATOR",
"n" : "Table",
"k" : "7013",
"c" : "769"
}
}
}
},
"fillFields" : "FromSource"
}
}
}
]
}
}
},
"metaGet" :
{
"obInst" : "true",
"objects" : "Get",
"objectsFilter" :
{
"range" :
{
"start" : "3",
"count" : "1"
}
},
"object" :
{
"settings" : "true",
"provider" :
{
"fields" : "true"
},
"fields" : "Get"
}
}
}
}
}
JSON response:
{
"SetEtlResult" :
{
"id" :
{
"id" : "S1!M!S!L1"
},
"meta" :
{
"obInst" :
{
"obDesc" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "3",
"@hf" : "0",
"i" : "ETL_INDICATOR",
"n" : "ETL task for loading indicators",
"k" : "7012",
"c" : "4097",
"p" : "7011",
"h" : "0",
"hasPrv" : "0",
"ic" : "0",
"isPermanent" : "1",
"isTemp" : "0"
}
},
"dirty" : "1",
"objects" :
{
"its" :
{
"it" :
[
{
"k" : "3",
"id" : "REPO_PROVIDER",
"n" : "Repository provider1",
"vis" : "1",
"type" : "PlainDataMetabaseProvider",
"obDesc" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "0",
"@hf" : "0",
"i" : "T_INDICATOR",
"n" : "Table",
"k" : "7013",
"c" : "769",
"p" : "7011",
"h" : "0",
"hasPrv" : "0",
"ic" : "0"
},
"read" : "1",
"write" : "1",
"settings" :
{
"plainProvider" :
{
"provider" :
{
"fields" :
{
"its" :
{
"it" :
[
{
"k" : "1",
"id" : "FKEY",
"n" : "FKey",
"vis" : "1",
"dt" : "2",
"dd" : "0",
"size" : "10",
"precision" : "0",
"expression" : "",
"calculated" : "0",
"dateFormat" : "DMY"
},
{
"k" : "2",
"id" : "FNAME",
"n" : "FName",
"vis" : "1",
"dt" : "1",
"dd" : "0",
"size" : "255",
"precision" : "0",
"expression" : "",
"calculated" : "0",
"dateFormat" : "DMY"
},
{
"k" : "3",
"id" : "ORD",
"n" : "Ord",
"vis" : "1",
"dt" : "2",
"dd" : "0",
"size" : "10",
"precision" : "0",
"expression" : "",
"calculated" : "0",
"dateFormat" : "DMY"
},
{
"k" : "4",
"id" : "FID",
"n" : "FId",
"vis" : "1",
"dt" : "1",
"dd" : "0",
"size" : "255",
"precision" : "0",
"expression" : "",
"calculated" : "0",
"dateFormat" : "DMY"
}
]
}
}
},
"fetchBlockSize" : "-1",
"ignoreIncorrectVals" : "0",
"unpivotMode" : "0"
}
}
}
]
}
},
"shapes" : ""
}
}
}
public static SetEtlResult AddProvider(MbId mb, EtlId moniker, string providerId)
{
var somClient = new SomPortTypeClient(); //Proxy object for operation execution
var providerDesc = FindObjectById(mb, providerId); // Provider description
//Operation execution parameters
var tSet = new SetEtl()
{
tArg = new SetEtlArg()
{
pattern = new EtlMdPattern()
{
objects = ListOperation.Add,
@object = new EtlObjectPattern()
{
settings = true,
provider = new EtlProviderPattern()
{
props = true
}
}
},
meta = new EtlMd()
{
objects = new EtlObjects()
{
its = new EtlObject[]
{
new EtlObject()
{
//Basic properties
id = "REPO_PROVIDER",
k = 0,
type = EtlObjectType.PlainDataMetabaseProvider,
vis = true,
//Set up provider
settings = new EtlObjectSettings()
{
plainProvider = new EtlPlainDataProvider()
{
fillFields = EtlFillFieldsType.FromSource,
provider = new DtProviderMd()
{
props = new DtProviderProps()
{
type = DtProviderType.Mb,
mb = new DtProviderMb()
{
dataset = new Ob()
{
k = providerDesc.k,
i = providerDesc.i,
c = providerDesc.c,
n = providerDesc.n
}
}
}
}
}
}
}
}
}
},
metaGet = new EtlMdPattern()
{
objects = ListOperation.Get,
objectsFilter = new ListFilter() { range = new ListRange() {start = 3, count = 1}},
@object = new EtlObjectPattern()
{
fields = ListOperation.Get,
settings = true,
provider = new EtlProviderPattern() {fields = true}
}
}
},
tEtl = moniker
};
//Add object to ETL task
var result = somClient.SetEtl(tSet);
return result;
}