POST api/DashboardBuilder/SaveTablesAndColumns

Request Information

URI Parameters

None.

Body Parameters

AccessConfigurationVM
NameDescriptionTypeAdditional information
AccessID

integer

None.

TABLE_NAME

string

None.

COLUMN_NAME

string

None.

Tables

Collection of TableColumnViewModel

None.

IsAccessible

boolean

None.

DatabaseID

integer

None.

DatabaseName

string

None.

ISACTIVE

integer

None.

USERID

integer

None.

CURRENTUSERROLEID

integer

None.

CURRENTSCREENID

integer

None.

CREATED_BY

integer

None.

CREATED_DATE

date

None.

UPDATED_BY

integer

None.

UPDATED_DATE

date

None.

UNIT_ID

integer

None.

LINE_ID

integer

None.

PLANT_ID

integer

None.

ORG_ID

integer

None.

ISCHILDRESULT

boolean

None.

PageSize

integer

None.

PageNumber

integer

None.

SortBy

string

None.

SortOrder

string

None.

SearchFilter

string

None.

SESSIONID

integer

None.

CURRENTSESSIONID

string

None.

ISLOGGEDIN

boolean

None.

MOB_PLAYERID

string

None.

ISWEBLOGIN

boolean

None.

OptTime

string

None.

Date

string

None.

AuditLogID

integer

None.

OperationType

string

None.

ScreenName

string

None.

Description

string

None.

ACTION_USER_NAME

string

None.

OperationDateTime

date

None.

SUBSCRIPTION_ID

string

None.

CONSUMED_TOKEN_CNT

integer

None.

TOTAL_TOKEN_SIZE

integer

None.

TOTAL_CONSUMED_SIZE

string

None.

AI_FLAG

integer

None.

Request Formats

application/json, text/json

Sample:
{
  "AccessID": 1,
  "TABLE_NAME": "sample string 1",
  "COLUMN_NAME": "sample string 2",
  "Tables": [
    {
      "TABLE_NAME": "sample string 1",
      "COLUMN_NAMES": [
        "sample string 1",
        "sample string 2"
      ],
      "TABLE_ALIAS": "sample string 2",
      "DatabaseId": 1
    },
    {
      "TABLE_NAME": "sample string 1",
      "COLUMN_NAMES": [
        "sample string 1",
        "sample string 2"
      ],
      "TABLE_ALIAS": "sample string 2",
      "DatabaseId": 1
    }
  ],
  "IsAccessible": true,
  "DatabaseID": 1,
  "DatabaseName": "sample string 4",
  "ISACTIVE": 1,
  "USERID": 1,
  "CURRENTUSERROLEID": 1,
  "CURRENTSCREENID": 5,
  "CREATED_BY": 1,
  "CREATED_DATE": "2026-01-23T19:36:20.3082857+05:30",
  "UPDATED_BY": 1,
  "UPDATED_DATE": "2026-01-23T19:36:20.3082857+05:30",
  "UNIT_ID": 1,
  "LINE_ID": 1,
  "PLANT_ID": 1,
  "ORG_ID": 1,
  "ISCHILDRESULT": true,
  "PageSize": 1,
  "PageNumber": 1,
  "SortBy": "sample string 6",
  "SortOrder": "sample string 7",
  "SearchFilter": "sample string 8",
  "SESSIONID": 1,
  "CURRENTSESSIONID": "sample string 9",
  "ISLOGGEDIN": true,
  "MOB_PLAYERID": "sample string 10",
  "ISWEBLOGIN": true,
  "OptTime": "sample string 11",
  "Date": "sample string 12",
  "AuditLogID": 1,
  "OperationType": "sample string 13",
  "ScreenName": "sample string 14",
  "Description": "sample string 15",
  "ACTION_USER_NAME": "sample string 16",
  "OperationDateTime": "2026-01-23T19:36:20.3082857+05:30",
  "SUBSCRIPTION_ID": "sample string 17",
  "CONSUMED_TOKEN_CNT": 1,
  "TOTAL_TOKEN_SIZE": 1,
  "TOTAL_CONSUMED_SIZE": "sample string 18",
  "AI_FLAG": 1
}

multipart/form-data

Sample:
{"AccessID":1,"TABLE_NAME":"sample string 1","COLUMN_NAME":"sample string 2","Tables":[{"TABLE_NAME":"sample string 1","COLUMN_NAMES":["sample string 1","sample string 2"],"TABLE_ALIAS":"sample string 2","DatabaseId":1},{"TABLE_NAME":"sample string 1","COLUMN_NAMES":["sample string 1","sample string 2"],"TABLE_ALIAS":"sample string 2","DatabaseId":1}],"IsAccessible":true,"DatabaseID":1,"DatabaseName":"sample string 4","ISACTIVE":1,"USERID":1,"CURRENTUSERROLEID":1,"CURRENTSCREENID":5,"CREATED_BY":1,"CREATED_DATE":"2026-01-23T19:36:20.3082857+05:30","UPDATED_BY":1,"UPDATED_DATE":"2026-01-23T19:36:20.3082857+05:30","UNIT_ID":1,"LINE_ID":1,"PLANT_ID":1,"ORG_ID":1,"ISCHILDRESULT":true,"PageSize":1,"PageNumber":1,"SortBy":"sample string 6","SortOrder":"sample string 7","SearchFilter":"sample string 8","SESSIONID":1,"CURRENTSESSIONID":"sample string 9","ISLOGGEDIN":true,"MOB_PLAYERID":"sample string 10","ISWEBLOGIN":true,"OptTime":"sample string 11","Date":"sample string 12","AuditLogID":1,"OperationType":"sample string 13","ScreenName":"sample string 14","Description":"sample string 15","ACTION_USER_NAME":"sample string 16","OperationDateTime":"2026-01-23T19:36:20.3082857+05:30","SUBSCRIPTION_ID":"sample string 17","CONSUMED_TOKEN_CNT":1,"TOTAL_TOKEN_SIZE":1,"TOTAL_CONSUMED_SIZE":"sample string 18","AI_FLAG":1}

application/xml, text/xml

Sample:
<AccessConfigurationVM xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/IPMS.FT.Business.Entities.ViewModel">
  <ACTION_USER_NAME>sample string 16</ACTION_USER_NAME>
  <AI_FLAG>1</AI_FLAG>
  <AuditLogID>1</AuditLogID>
  <CONSUMED_TOKEN_CNT>1</CONSUMED_TOKEN_CNT>
  <CREATED_BY>1</CREATED_BY>
  <CREATED_DATE>2026-01-23T19:36:20.3082857+05:30</CREATED_DATE>
  <CURRENTSCREENID>5</CURRENTSCREENID>
  <CURRENTSESSIONID>sample string 9</CURRENTSESSIONID>
  <CURRENTUSERROLEID>1</CURRENTUSERROLEID>
  <Date>sample string 12</Date>
  <Description>sample string 15</Description>
  <ISACTIVE>1</ISACTIVE>
  <ISCHILDRESULT>true</ISCHILDRESULT>
  <ISLOGGEDIN>true</ISLOGGEDIN>
  <ISWEBLOGIN>true</ISWEBLOGIN>
  <LINE_ID>1</LINE_ID>
  <MOB_PLAYERID>sample string 10</MOB_PLAYERID>
  <ORG_ID>1</ORG_ID>
  <OperationDateTime>2026-01-23T19:36:20.3082857+05:30</OperationDateTime>
  <OperationType>sample string 13</OperationType>
  <OptTime>sample string 11</OptTime>
  <PLANT_ID>1</PLANT_ID>
  <PageNumber>1</PageNumber>
  <PageSize>1</PageSize>
  <SESSIONID>1</SESSIONID>
  <SUBSCRIPTION_ID>sample string 17</SUBSCRIPTION_ID>
  <ScreenName>sample string 14</ScreenName>
  <SearchFilter>sample string 8</SearchFilter>
  <SortBy>sample string 6</SortBy>
  <SortOrder>sample string 7</SortOrder>
  <TOTAL_CONSUMED_SIZE>sample string 18</TOTAL_CONSUMED_SIZE>
  <TOTAL_TOKEN_SIZE>1</TOTAL_TOKEN_SIZE>
  <UNIT_ID>1</UNIT_ID>
  <UPDATED_BY>1</UPDATED_BY>
  <UPDATED_DATE>2026-01-23T19:36:20.3082857+05:30</UPDATED_DATE>
  <USERID>1</USERID>
  <AccessID>1</AccessID>
  <COLUMN_NAME>sample string 2</COLUMN_NAME>
  <DatabaseID>1</DatabaseID>
  <DatabaseName>sample string 4</DatabaseName>
  <IsAccessible>true</IsAccessible>
  <TABLE_NAME>sample string 1</TABLE_NAME>
  <Tables>
    <TableColumnViewModel>
      <COLUMN_NAMES xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:string>sample string 1</d4p1:string>
        <d4p1:string>sample string 2</d4p1:string>
      </COLUMN_NAMES>
      <DatabaseId>1</DatabaseId>
      <TABLE_ALIAS>sample string 2</TABLE_ALIAS>
      <TABLE_NAME>sample string 1</TABLE_NAME>
    </TableColumnViewModel>
    <TableColumnViewModel>
      <COLUMN_NAMES xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:string>sample string 1</d4p1:string>
        <d4p1:string>sample string 2</d4p1:string>
      </COLUMN_NAMES>
      <DatabaseId>1</DatabaseId>
      <TABLE_ALIAS>sample string 2</TABLE_ALIAS>
      <TABLE_NAME>sample string 1</TABLE_NAME>
    </TableColumnViewModel>
  </Tables>
</AccessConfigurationVM>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

IHttpActionResult

None.

Response Formats

application/json, text/json, multipart/form-data, application/xml, text/xml

Sample:

Sample not available.