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