Sectors Local Database Data Block

The Sectors Local Database (SectorsLocalDB) Data Block is not edited. The following details are informational only.

The Sectors Local Database (SectorsLocalDB) Data Block retrieves sector-related data from Assette. It accepts the parameters AsOfDate, UseSectorMapTable, Category, and Language. The Sectors Local Database (SectorsLocalDB) Data Block returns sector data based on these inputs. This Data Block is not edited.

General Info #

The following table shows the default fields of the Data Block.

Field	Value
Name	SectorsLocalDB
Block Category	Interface
Block Type	Local Database
Data Category	None
Output Type	None

Dependencies #

None

Columns #

None

Example Definition #

{
    "type": "Values",
    "sql": "EXEC [dbo].[sp_GetSectorsBySchemeAsOfData] @AsOfDate = ?, @UseSectorMapTable = ?, @Category=?,@Language=?",
    "parameters": ["AsOfDate","UseSectorMapTable","Category","Language"]
}

Example Request #

The following code shows an example request using the default values of the Data Block.

{
    "AsOfDate":"",
    "Categories":"",
    "UseSectorMapTable":"",
    "Category":"",
    "Language":""

}