Input Guidelines
When specifying a value for the list item attributes, you can follow certain input format guidelines to avoid an invalid input.
The following table lists all the data types in Microsoft SharePoint and its corresponding data types in the plug-in. It also provides an example of the input format for each data type.
| Data Type in Microsoft SharePoint | Data Type in the Plug-in | Description | Example |
|---|---|---|---|
| Text | String | Specifies a single line of text. | abc |
| Note | String | Specifies a field that can contain multiple lines of text. | abc |
| Number | Double | Specifies floating point numbers. Number (1, 1.0, 100). | 123.1 |
| Integer | Integer | Specifies an integer number. | 123 |
| Currency | Double | Specifies currency values formatted based on a specific locale. | 123.45 |
| DateTime | DateTime | Specifies date and time values. | 2013-01-16T16:44:20Z |
| Lookup | String | Specifies references to values in other lists. | 1 |
| Boolean | Boolean | Specifies Boolean values that are stored in the database as 1 or 0. | 0 |
| User | String | Specifies a user or group of a SharePoint site. | 1 |
| URL | URL (Description String) | Specifies hyperlinks. | https://sharepoint.microsoft.com/en-us/Pages/default.aspx |
| Calculated | String | Specifies calculated values. | abc |
| External Data | Not supported | N/A | N/A |
| Managed Metadata | Not supported | N/A | N/A |
| Choice | Not supported | N/A | N/A |
| MultiChoice | Not supported | N/A | N/A |
| LookupMulti | Not supported | N/A | N/A |
| AllDayEvent | Boolean | Specifies an all-day event. | 0 or 1 |
| Attachments | Not supported | N/A | N/A |
| Computed | String | Specifies an abstract field type that depends on other fields for its content and definition. | abc |
| ContentTypeId | String | Specifies a content type ID. | 0x0102 |
| Counter | Integer | Specifies an integer used for internal ID fields. | 123 |
| File | String | Specifies files. | abc.ext |
| GridChoice | Not supported | N/A | N/A |
| MaxItems | Integer | Specifies the maximum number of items. | 1000 |
| ModStat | Not supported | N/A | N/A |
| Recurrence | Not supported | N/A | N/A |