GET /corrsuat/api/3/isheets/admin/1118/columns HTTP/1.1

HTTP/1.1 200 200
Date: Mon, 12 Feb 2018 21:34:27 GMT
Server: Apache
Cache-Control: no-cache, no-store
Pragma: no-cache
X-XSS-Protection: 1; mode=block
Strict-Transport-Security: max-age=31536000; includeSubDomains
X-Content-Type-Options: nosniff
X-Ratelimit-Limit: 500
X-Ratelimit-Remaining: 494
X-Ratelimit-Reset: 1518432201
X-Ratelimit-Relative-Reset: 533
Expires: Thu, 01 Jan 1970 00:00:00 GMT
Content-Type: application/json;charset=utf-8
Connection: close
Transfer-Encoding: chunked

{
	"column": [
		{
			"columnid": 6836,
			"name": "Created by",
			"type": 6,
			"section": 1716,
			"description": "<![CDATA[]]>",
			"addtodefaultview": "0",
			"columnconditionstate": "Display field",
			"columnconditions": {
				"row": []
			},
			"columnspecificdetail": {
				"defaultvalue": null,
				"columnwidth": 150,
				"mandatory": "0",
				"allowsearch": "1",
				"maxchars": null,
				"allowfieldfromanotherisheet": null,
				"allowrichhtmltext": null,
				"numberoflines": null,
				"displaymethod": null,
				"includeotheroption": null,
				"singleormultileselectioninsearch": null,
				"choices": null,
				"includeinalertpreferences": null,
				"min": null,
				"max": null,
				"decimalplaces": null,
				"showthousandseparators": null,
				"showaspercentage": null,
				"formattype": null,
				"dateformat": null,
				"defaultdateandtime": null,
				"sheetlookup": "SHEET_LOOKUP_CONTENT_ADMINISTRATORS",
				"fielddisplay": "Username",
				"allowmultipleusers": "0",
				"sheetids": null,
				"allowuserstorenamelinks": null,
				"methodtype": null,
				"sheetid": null,
				"columnids": null,
				"viewid": null,
				"allowmultiplevalues": null,
				"restrictdelete": null,
				"displaycolumnnameprefix": null,
				"linkname": null,
				"formula": null,
				"startvalue": null,
				"prefix": null,
				"postfix": null,
				"minlength": null,
				"lookupglossarysheetid": null,
				"lookupglossarysheetviewid": null,
				"width": null
			},
			"sequence": null,
			"attributecolumnid": null
		},
		{
			"columnid": 6837,
			"name": "Created date",
			"type": 5,
			"section": 1716,
			"description": "<![CDATA[]]>",
			"addtodefaultview": "0",
			"columnconditionstate": "Display field",
			"columnconditions": {
				"row": []
			},
			"columnspecificdetail": {
				"defaultvalue": "NONE",
				"columnwidth": 120,
				"mandatory": "0",
				"allowsearch": "1",
				"maxchars": null,
				"allowfieldfromanotherisheet": null,
				"allowrichhtmltext": null,
				"numberoflines": null,
				"displaymethod": null,
				"includeotheroption": null,
				"singleormultileselectioninsearch": null,
				"choices": null,
				"includeinalertpreferences": null,
				"min": null,
				"max": null,
				"decimalplaces": null,
				"showthousandseparators": null,
				"showaspercentage": null,
				"formattype": "DATE_TIME",
				"dateformat": "<![CDATA[dd MMM YYYY]]>",
				"defaultdateandtime": "0",
				"sheetlookup": null,
				"fielddisplay": null,
				"allowmultipleusers": null,
				"sheetids": null,
				"allowuserstorenamelinks": null,
				"methodtype": null,
				"sheetid": null,
				"columnids": null,
				"viewid": null,
				"allowmultiplevalues": null,
				"restrictdelete": null,
				"displaycolumnnameprefix": null,
				"linkname": null,
				"formula": null,
				"startvalue": null,
				"prefix": null,
				"postfix": null,
				"minlength": null,
				"lookupglossarysheetid": null,
				"lookupglossarysheetviewid": null,
				"width": null
			},
			"sequence": null,
			"attributecolumnid": null
		},
		{
			"columnid": 6838,
			"name": "Modified by",
			"type": 6,
			"section": 1716,
			"description": "<![CDATA[]]>",
			"addtodefaultview": "0",
			"columnconditionstate": "Display field",
			"columnconditions": {
				"row": []
			},
			"columnspecificdetail": {
				"defaultvalue": null,
				"columnwidth": 150,
				"mandatory": "0",
				"allowsearch": "1",
				"maxchars": null,
				"allowfieldfromanotherisheet": null,
				"allowrichhtmltext": null,
				"numberoflines": null,
				"displaymethod": null,
				"includeotheroption": null,
				"singleormultileselectioninsearch": null,
				"choices": null,
				"includeinalertpreferences": null,
				"min": null,
				"max": null,
				"decimalplaces": null,
				"showthousandseparators": null,
				"showaspercentage": null,
				"formattype": null,
				"dateformat": null,
				"defaultdateandtime": null,
				"sheetlookup": "SHEET_LOOKUP_CONTENT_ADMINISTRATORS",
				"fielddisplay": "Username",
				"allowmultipleusers": "0",
				"sheetids": null,
				"allowuserstorenamelinks": null,
				"methodtype": null,
				"sheetid": null,
				"columnids": null,
				"viewid": null,
				"allowmultiplevalues": null,
				"restrictdelete": null,
				"displaycolumnnameprefix": null,
				"linkname": null,
				"formula": null,
				"startvalue": null,
				"prefix": null,
				"postfix": null,
				"minlength": null,
				"lookupglossarysheetid": null,
				"lookupglossarysheetviewid": null,
				"width": null
			},
			"sequence": null,
			"attributecolumnid": null
		},
		{
			"columnid": 6839,
			"name": "Modified date",
			"type": 5,
			"section": 1716,
			"description": "<![CDATA[]]>",
			"addtodefaultview": "0",
			"columnconditionstate": "Display field",
			"columnconditions": {
				"row": []
			},
			"columnspecificdetail": {
				"defaultvalue": "NONE",
				"columnwidth": 120,
				"mandatory": "0",
				"allowsearch": "1",
				"maxchars": null,
				"allowfieldfromanotherisheet": null,
				"allowrichhtmltext": null,
				"numberoflines": null,
				"displaymethod": null,
				"includeotheroption": null,
				"singleormultileselectioninsearch": null,
				"choices": null,
				"includeinalertpreferences": null,
				"min": null,
				"max": null,
				"decimalplaces": null,
				"showthousandseparators": null,
				"showaspercentage": null,
				"formattype": "DATE_TIME",
				"dateformat": "<![CDATA[dd MMM YYYY]]>",
				"defaultdateandtime": "0",
				"sheetlookup": null,
				"fielddisplay": null,
				"allowmultipleusers": null,
				"sheetids": null,
				"allowuserstorenamelinks": null,
				"methodtype": null,
				"sheetid": null,
				"columnids": null,
				"viewid": null,
				"allowmultiplevalues": null,
				"restrictdelete": null,
				"displaycolumnnameprefix": null,
				"linkname": null,
				"formula": null,
				"startvalue": null,
				"prefix": null,
				"postfix": null,
				"minlength": null,
				"lookupglossarysheetid": null,
				"lookupglossarysheetviewid": null,
				"width": null
			},
			"sequence": null,
			"attributecolumnid": null
		},
		{
			"columnid": 6840,
			"name": "Project No.",
			"type": 1,
			"section": 1718,
			"description": "<![CDATA[]]>",
			"addtodefaultview": "0",
			"columnconditionstate": "Display field",
			"columnconditions": {
				"row": []
			},
			"columnspecificdetail": {
				"defaultvalue": "",
				"columnwidth": 150,
				"mandatory": "1",
				"allowsearch": "1",
				"maxchars": 255,
				"allowfieldfromanotherisheet": "0",
				"allowrichhtmltext": null,
				"numberoflines": null,
				"displaymethod": null,
				"includeotheroption": null,
				"singleormultileselectioninsearch": null,
				"choices": null,
				"includeinalertpreferences": null,
				"min": null,
				"max": null,
				"decimalplaces": null,
				"showthousandseparators": null,
				"showaspercentage": null,
				"formattype": null,
				"dateformat": null,
				"defaultdateandtime": null,
				"sheetlookup": null,
				"fielddisplay": null,
				"allowmultipleusers": null,
				"sheetids": null,
				"allowuserstorenamelinks": null,
				"methodtype": null,
				"sheetid": null,
				"columnids": null,
				"viewid": null,
				"allowmultiplevalues": null,
				"restrictdelete": null,
				"displaycolumnnameprefix": null,
				"linkname": null,
				"formula": null,
				"startvalue": null,
				"prefix": null,
				"postfix": null,
				"minlength": null,
				"lookupglossarysheetid": null,
				"lookupglossarysheetviewid": null,
				"width": null
			},
			"sequence": null,
			"attributecolumnid": null
		},
		{
			"columnid": 6841,
			"name": "Project Name",
			"type": 1,
			"section": 1718,
			"description": "<![CDATA[]]>",
			"addtodefaultview": "0",
			"columnconditionstate": "Display field",
			"columnconditions": {
				"row": []
			},
			"columnspecificdetail": {
				"defaultvalue": "",
				"columnwidth": 150,
				"mandatory": "1",
				"allowsearch": "1",
				"maxchars": 255,
				"allowfieldfromanotherisheet": "0",
				"allowrichhtmltext": null,
				"numberoflines": null,
				"displaymethod": null,
				"includeotheroption": null,
				"singleormultileselectioninsearch": null,
				"choices": null,
				"includeinalertpreferences": null,
				"min": null,
				"max": null,
				"decimalplaces": null,
				"showthousandseparators": null,
				"showaspercentage": null,
				"formattype": null,
				"dateformat": null,
				"defaultdateandtime": null,
				"sheetlookup": null,
				"fielddisplay": null,
				"allowmultipleusers": null,
				"sheetids": null,
				"allowuserstorenamelinks": null,
				"methodtype": null,
				"sheetid": null,
				"columnids": null,
				"viewid": null,
				"allowmultiplevalues": null,
				"restrictdelete": null,
				"displaycolumnnameprefix": null,
				"linkname": null,
				"formula": null,
				"startvalue": null,
				"prefix": null,
				"postfix": null,
				"minlength": null,
				"lookupglossarysheetid": null,
				"lookupglossarysheetviewid": null,
				"width": null
			},
			"sequence": null,
			"attributecolumnid": null
		},
		{
			"columnid": 6842,
			"name": "Project Description",
			"type": 2,
			"section": 1718,
			"description": "<![CDATA[]]>",
			"addtodefaultview": "0",
			"columnconditionstate": "Display field",
			"columnconditions": {
				"row": []
			},
			"columnspecificdetail": {
				"defaultvalue": "",
				"columnwidth": 250,
				"mandatory": "0",
				"allowsearch": "1",
				"maxchars": null,
				"allowfieldfromanotherisheet": "0",
				"allowrichhtmltext": "0",
				"numberoflines": 6,
				"displaymethod": null,
				"includeotheroption": null,
				"singleormultileselectioninsearch": null,
				"choices": null,
				"includeinalertpreferences": null,
				"min": null,
				"max": null,
				"decimalplaces": null,
				"showthousandseparators": null,
				"showaspercentage": null,
				"formattype": null,
				"dateformat": null,
				"defaultdateandtime": null,
				"sheetlookup": null,
				"fielddisplay": null,
				"allowmultipleusers": null,
				"sheetids": null,
				"allowuserstorenamelinks": null,
				"methodtype": null,
				"sheetid": null,
				"columnids": null,
				"viewid": null,
				"allowmultiplevalues": null,
				"restrictdelete": null,
				"displaycolumnnameprefix": null,
				"linkname": null,
				"formula": null,
				"startvalue": null,
				"prefix": null,
				"postfix": null,
				"minlength": null,
				"lookupglossarysheetid": null,
				"lookupglossarysheetviewid": null,
				"width": 40
			},
			"sequence": null,
			"attributecolumnid": null
		},
		{
			"columnid": 6843,
			"name": "Project Status",
			"type": 3,
			"section": 1718,
			"description": "<![CDATA[]]>",
			"addtodefaultview": "0",
			"columnconditionstate": "Display field",
			"columnconditions": {
				"row": []
			},
			"columnspecificdetail": {
				"defaultvalue": "Open",
				"columnwidth": 100,
				"mandatory": "1",
				"allowsearch": "1",
				"maxchars": null,
				"allowfieldfromanotherisheet": null,
				"allowrichhtmltext": null,
				"numberoflines": null,
				"displaymethod": "DROPDOWN",
				"includeotheroption": null,
				"singleormultileselectioninsearch": "MULTIPLE",
				"choices": {
					"choice": [
						{
							"id": "41828",
							"label": "<![CDATA[Open]]>"
						},
						{
							"id": "41829",
							"label": "<![CDATA[Closed]]>"
						}
					]
				},
				"includeinalertpreferences": "0",
				"min": null,
				"max": null,
				"decimalplaces": null,
				"showthousandseparators": null,
				"showaspercentage": null,
				"formattype": null,
				"dateformat": null,
				"defaultdateandtime": null,
				"sheetlookup": null,
				"fielddisplay": null,
				"allowmultipleusers": null,
				"sheetids": null,
				"allowuserstorenamelinks": null,
				"methodtype": null,
				"sheetid": null,
				"columnids": null,
				"viewid": null,
				"allowmultiplevalues": null,
				"restrictdelete": null,
				"displaycolumnnameprefix": null,
				"linkname": null,
				"formula": null,
				"startvalue": null,
				"prefix": null,
				"postfix": null,
				"minlength": null,
				"lookupglossarysheetid": null,
				"lookupglossarysheetviewid": null,
				"width": null
			},
			"sequence": null,
			"attributecolumnid": null
		}
	]
}