GET api/ExcelAddin

Request Information

URI Parameters

None.

Body Parameters

None.

Response Information

Resource Description

Collection of CacheMenus

Name	Type	Additional information
CachedMenuID	integer	None.
CachedModuleID	integer	None.
Event	string	None.
ExcelPath	string	None.
SheetName	string	None.
XColumnsSheetName	string	None.
RefreshOnSaveOfMenuID	integer	None.
RefreshOnSaveOfModuleID	integer	None.
RefreshCache_SP	string	None.
Level1FilterColumn	string	None.
Level2FilterColumn	string	None.
MergeColumnIndexStart	integer	None.
MergeColumnIndexEnd	integer	None.
RedisCache	boolean	None.
Datatable	DataTable	None.
DefaultFilterColumn	string	None.
FilterValue	string	None.
FilterType	string	None.
IsPivotedColumn	boolean	None.
FilterDataType	string	None.
Vertical	string	None.
DeleteColumn	string	None.
FixedColumn	string	None.
HorizontalXIndex	integer	None.
IsTranspose	boolean	None.
BlankColumn	boolean	None.
DeleteColumnIndex	integer	None.
DateOrderColumn	string	None.

Response Formats

application/json, text/json

Sample:

[
  {
    "CachedMenuID": 1,
    "CachedModuleID": 2,
    "Event": "sample string 3",
    "ExcelPath": "sample string 4",
    "SheetName": "sample string 5",
    "XColumnsSheetName": "sample string 6",
    "RefreshOnSaveOfMenuID": 7,
    "RefreshOnSaveOfModuleID": 8,
    "RefreshCache_SP": "sample string 9",
    "Level1FilterColumn": "sample string 10",
    "Level2FilterColumn": "sample string 11",
    "MergeColumnIndexStart": 12,
    "MergeColumnIndexEnd": 13,
    "RedisCache": true,
    "Datatable": null,
    "DefaultFilterColumn": "sample string 15",
    "FilterValue": "sample string 16",
    "FilterType": "sample string 17",
    "IsPivotedColumn": true,
    "FilterDataType": "sample string 19",
    "Vertical": "sample string 20",
    "DeleteColumn": "sample string 21",
    "FixedColumn": "sample string 22",
    "HorizontalXIndex": 23,
    "IsTranspose": true,
    "BlankColumn": true,
    "DeleteColumnIndex": 26,
    "DateOrderColumn": "sample string 27"
  },
  {
    "CachedMenuID": 1,
    "CachedModuleID": 2,
    "Event": "sample string 3",
    "ExcelPath": "sample string 4",
    "SheetName": "sample string 5",
    "XColumnsSheetName": "sample string 6",
    "RefreshOnSaveOfMenuID": 7,
    "RefreshOnSaveOfModuleID": 8,
    "RefreshCache_SP": "sample string 9",
    "Level1FilterColumn": "sample string 10",
    "Level2FilterColumn": "sample string 11",
    "MergeColumnIndexStart": 12,
    "MergeColumnIndexEnd": 13,
    "RedisCache": true,
    "Datatable": null,
    "DefaultFilterColumn": "sample string 15",
    "FilterValue": "sample string 16",
    "FilterType": "sample string 17",
    "IsPivotedColumn": true,
    "FilterDataType": "sample string 19",
    "Vertical": "sample string 20",
    "DeleteColumn": "sample string 21",
    "FixedColumn": "sample string 22",
    "HorizontalXIndex": 23,
    "IsTranspose": true,
    "BlankColumn": true,
    "DeleteColumnIndex": 26,
    "DateOrderColumn": "sample string 27"
  }
]

application/xml, text/xml

Sample:

<ArrayOfCacheMenus xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/IMBS.DO.Models">
  <CacheMenus>
    <BlankColumn>true</BlankColumn>
    <CachedMenuID>1</CachedMenuID>
    <CachedModuleID>2</CachedModuleID>
    <Datatable i:nil="true" />
    <DateOrderColumn>sample string 27</DateOrderColumn>
    <DefaultFilterColumn>sample string 15</DefaultFilterColumn>
    <DeleteColumn>sample string 21</DeleteColumn>
    <DeleteColumnIndex>26</DeleteColumnIndex>
    <Event>sample string 3</Event>
    <ExcelPath>sample string 4</ExcelPath>
    <FilterDataType>sample string 19</FilterDataType>
    <FilterType>sample string 17</FilterType>
    <FilterValue>sample string 16</FilterValue>
    <FixedColumn>sample string 22</FixedColumn>
    <HorizontalXIndex>23</HorizontalXIndex>
    <IsPivotedColumn>true</IsPivotedColumn>
    <IsTranspose>true</IsTranspose>
    <Level1FilterColumn>sample string 10</Level1FilterColumn>
    <Level2FilterColumn>sample string 11</Level2FilterColumn>
    <MergeColumnIndexEnd>13</MergeColumnIndexEnd>
    <MergeColumnIndexStart>12</MergeColumnIndexStart>
    <RedisCache>true</RedisCache>
    <RefreshCache_SP>sample string 9</RefreshCache_SP>
    <RefreshOnSaveOfMenuID>7</RefreshOnSaveOfMenuID>
    <RefreshOnSaveOfModuleID>8</RefreshOnSaveOfModuleID>
    <SheetName>sample string 5</SheetName>
    <Vertical>sample string 20</Vertical>
    <XColumnsSheetName>sample string 6</XColumnsSheetName>
  </CacheMenus>
  <CacheMenus>
    <BlankColumn>true</BlankColumn>
    <CachedMenuID>1</CachedMenuID>
    <CachedModuleID>2</CachedModuleID>
    <Datatable i:nil="true" />
    <DateOrderColumn>sample string 27</DateOrderColumn>
    <DefaultFilterColumn>sample string 15</DefaultFilterColumn>
    <DeleteColumn>sample string 21</DeleteColumn>
    <DeleteColumnIndex>26</DeleteColumnIndex>
    <Event>sample string 3</Event>
    <ExcelPath>sample string 4</ExcelPath>
    <FilterDataType>sample string 19</FilterDataType>
    <FilterType>sample string 17</FilterType>
    <FilterValue>sample string 16</FilterValue>
    <FixedColumn>sample string 22</FixedColumn>
    <HorizontalXIndex>23</HorizontalXIndex>
    <IsPivotedColumn>true</IsPivotedColumn>
    <IsTranspose>true</IsTranspose>
    <Level1FilterColumn>sample string 10</Level1FilterColumn>
    <Level2FilterColumn>sample string 11</Level2FilterColumn>
    <MergeColumnIndexEnd>13</MergeColumnIndexEnd>
    <MergeColumnIndexStart>12</MergeColumnIndexStart>
    <RedisCache>true</RedisCache>
    <RefreshCache_SP>sample string 9</RefreshCache_SP>
    <RefreshOnSaveOfMenuID>7</RefreshOnSaveOfMenuID>
    <RefreshOnSaveOfModuleID>8</RefreshOnSaveOfModuleID>
    <SheetName>sample string 5</SheetName>
    <Vertical>sample string 20</Vertical>
    <XColumnsSheetName>sample string 6</XColumnsSheetName>
  </CacheMenus>
</ArrayOfCacheMenus>

multipart/form-data

Sample:

<ArrayOfCacheMenus xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/IMBS.DO.Models"><CacheMenus><BlankColumn>true</BlankColumn><CachedMenuID>1</CachedMenuID><CachedModuleID>2</CachedModuleID><Datatable i:nil="true" /><DateOrderColumn>sample string 27</DateOrderColumn><DefaultFilterColumn>sample string 15</DefaultFilterColumn><DeleteColumn>sample string 21</DeleteColumn><DeleteColumnIndex>26</DeleteColumnIndex><Event>sample string 3</Event><ExcelPath>sample string 4</ExcelPath><FilterDataType>sample string 19</FilterDataType><FilterType>sample string 17</FilterType><FilterValue>sample string 16</FilterValue><FixedColumn>sample string 22</FixedColumn><HorizontalXIndex>23</HorizontalXIndex><IsPivotedColumn>true</IsPivotedColumn><IsTranspose>true</IsTranspose><Level1FilterColumn>sample string 10</Level1FilterColumn><Level2FilterColumn>sample string 11</Level2FilterColumn><MergeColumnIndexEnd>13</MergeColumnIndexEnd><MergeColumnIndexStart>12</MergeColumnIndexStart><RedisCache>true</RedisCache><RefreshCache_SP>sample string 9</RefreshCache_SP><RefreshOnSaveOfMenuID>7</RefreshOnSaveOfMenuID><RefreshOnSaveOfModuleID>8</RefreshOnSaveOfModuleID><SheetName>sample string 5</SheetName><Vertical>sample string 20</Vertical><XColumnsSheetName>sample string 6</XColumnsSheetName></CacheMenus><CacheMenus><BlankColumn>true</BlankColumn><CachedMenuID>1</CachedMenuID><CachedModuleID>2</CachedModuleID><Datatable i:nil="true" /><DateOrderColumn>sample string 27</DateOrderColumn><DefaultFilterColumn>sample string 15</DefaultFilterColumn><DeleteColumn>sample string 21</DeleteColumn><DeleteColumnIndex>26</DeleteColumnIndex><Event>sample string 3</Event><ExcelPath>sample string 4</ExcelPath><FilterDataType>sample string 19</FilterDataType><FilterType>sample string 17</FilterType><FilterValue>sample string 16</FilterValue><FixedColumn>sample string 22</FixedColumn><HorizontalXIndex>23</HorizontalXIndex><IsPivotedColumn>true</IsPivotedColumn><IsTranspose>true</IsTranspose><Level1FilterColumn>sample string 10</Level1FilterColumn><Level2FilterColumn>sample string 11</Level2FilterColumn><MergeColumnIndexEnd>13</MergeColumnIndexEnd><MergeColumnIndexStart>12</MergeColumnIndexStart><RedisCache>true</RedisCache><RefreshCache_SP>sample string 9</RefreshCache_SP><RefreshOnSaveOfMenuID>7</RefreshOnSaveOfMenuID><RefreshOnSaveOfModuleID>8</RefreshOnSaveOfModuleID><SheetName>sample string 5</SheetName><Vertical>sample string 20</Vertical><XColumnsSheetName>sample string 6</XColumnsSheetName></CacheMenus></ArrayOfCacheMenus>