iSheets API version 2 - Get column types
OVERVIEW
This method returns the allowed column types and should be used when creating a new column in an iSheet.
GET /api/3/isheets/columntypes
The method has no request parameters.
Response
<columntypes> <type> <id>1</id> <name>Single line text</name> <alias>SHEET_COLUMN_TYPE_SINGLE_LINE_TEXT</alias> </type> <type> <id>2</id> <name>Multiple line text</name> <alias>SHEET_COLUMN_TYPE_MULTIPLE_LINE_TEXT</alias> </type> <type> <id>3</id> <name>Choice</name> <alias>SHEET_COLUMN_TYPE_CHOICE</alias> </type> <type> <id>4</id> <name>Number</name> <alias>SHEET_COLUMN_TYPE_NUMBER</alias> </type> <type> <id>5</id> <name>Date and time</name> <alias>SHEET_COLUMN_TYPE_DATE_AND_TIME</alias> </type> <type> <id>6</id> <name>User lookup</name> <alias>SHEET_COLUMN_TYPE_LOOKUP</alias> </type> <type> <id>7</id> <name>Hyperlink</name> <alias>SHEET_COLUMN_TYPE_HYPERLINK</alias> </type> <type> <id>8</id> <name>Image</name> <alias>SHEET_COLUMN_TYPE_IMAGE</alias> </type> <type> <id>9</id> <name>Attachment</name> <alias>SHEET_COLUMN_TYPE_ATTACHMENT</alias> </type> <type> <id>10</id> <name>File link</name> <alias>SHEET_COLUMN_TYPE_DOCUMENT_LINK</alias> </type> <type> <id>11</id> <name>Folder link</name> <alias>SHEET_COLUMN_TYPE_FOLDER_LINK</alias> </type> <type> <id>12</id> <name>iSheet link</name> <alias>SHEET_COLUMN_TYPE_ISHEET_LINK</alias> </type> <type> <id>13</id> <name>Lookup</name> <alias>SHEET_COLUMN_TYPE_INJECT</alias> </type> <type> <id>14</id> <name>Join</name> <alias>SHEET_COLUMN_TYPE_JOIN</alias> </type> <type> <id>15</id> <name>Calculation</name> <alias>SHEET_COLUMN_TYPE_FORMULA</alias> </type> <type> <id>16</id> <name>Auto increment</name> <alias>SHEET_COLUMN_TYPE_AUTO_INCREMENT</alias> </type></columntypes>
Can I be sure that for any user of HighQ on any instance IDs and the Aliases of the columns will be the same? And that I can be sure that 3 will always be a choice? Or someone somehow can change it for a particular instance?
Comments
1 Comments