GetDataAreaGridAttachments

Syntax

EaxAttachments GetDataAreaGridAttachments(string mon, EaxAttachmentPattern tPattern)

Parameters

mon. Moniker of the Table visualizer.

tPattern. Operation execution pattern.

Description

The GetDataAreaGridAttachments operation gets a list of table cell attachments.

Comments

To execute the operation, in the mon field specify regular report instance moniker with the !DataArea!DataSources!source key!DataSourceSlices!slice key!Views!table key postfix. The moniker can be obtained on executing the OpenPrxMeta operation. In the tPattern field specify coordinates of the cell, which attachments should be obtained.

The operation results in the obtained list of attachments.

Example

Below is the example of getting a list of attachments added for a table cell. The request contains table moniker and cell coordinates. The response contains the obtained list of attachments.

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">
<GetDataAreaGridAttachments xmlns="http://www.fsight.ru/PP.SOM.Som">
  <mon xmlns="">MEIAHFNGIHOCGOAEIHCLFJLBBEPLGOEELKAMEOCBAIKLGBGC!M!S!PJOILJGNGIHOCGOAEGFPAJAHCFFGJOBPEBIDPPGBPPHEIJJHB!DataArea!DataSources!1!DataSourceSlices!1!Views!1</mon>
<tPattern xmlns="">
  <row>3</row>
  <column>2</column>
  </tPattern>
  </GetDataAreaGridAttachments>
  </s:Body>
  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<GetDataAreaGridAttachmentsResult 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">
<its xmlns="">
<it>
  <key>8</key>
  <name>Data source</name>
  <type>URL</type>
  <url>https://rosstat.gov.ru/statistic</url>
  <date>2024-05-15T18:17:43.000</date>
  <user>the ADMIN user</user>
  </it>
<it>
  <key>9</key>
  <name>image1</name>
  <type>Value</type>
  <fileName>Image1.png</fileName>
  <date>2020-04-20T15:00:06.000</date>
  <size>3327</size>
  <user>the ADMIN user</user>
  </it>
  </its>
  </GetDataAreaGridAttachmentsResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

{
"GetDataAreaGridAttachments" :
{
"mon" : "MEIAHFNGIHOCGOAEIHCLFJLBBEPLGOEELKAMEOCBAIKLGBGC!M!S!PJOILJGNGIHOCGOAEGFPAJAHCFFGJOBPEBIDPPGBPPHEIJJHB!DataArea!DataSources!1!DataSourceSlices!1!Views!1",
"tPattern" :
{
"row" : "3",
"column" : "2"
}
}
}

JSON response:

{
"GetDataAreaGridAttachmentsResult" :
{
"its" :
{
"it" :
[
{
"key" : "8",
"name" : "Data source",
"type" : "URL",
"url" : "https:\/\/rosstat.gov.ru\/statistic",
"date" : "2024-05-15T18:17:43.000",
"user" : "the ADMIN user"
},
{
"key" : "9",
"name" : "Image1",
"type" : "Value",
"fileName" : "Image1.png",
"date" : "2020-04-20T15:00:06.000",
"size" : "3327",
"user" : "the ADMIN user"
}
]
}
}
}
public static EaxAttachments GetDataAreaGridAttachments(string moniker, uint sourceKey, uint sliceKey, uint viewKey, uint cellRow, uint cellColumn)
{
var somClient = new SomPortTypeClient(); // Proxy object for operation execution
// Operation execution parameters
var tGet = new GetDataAreaGridAttachments()
{
tPattern = new EaxAttachmentPattern()
{
row = cellRow,
column = cellColumn
},
mon = moniker + "!DataArea!DataSources!" + sourceKey.ToString() + "!DataSourceSlices!" + sliceKey.ToString() + "!Views!" + viewKey.ToString()
};
// Get information about cell attachments
var result = somClient.GetDataAreaGridAttachments(tGet);
return result;
}

See also:

Working with Regular Reports