Supported Data Types
The add-in supports a variety of OpenAPI data types available from REST services. These data types are derived from the service's JSON Schema Specification.
This table shows how JSON data types are mapped to the Data Type property for Business Object fields as shown in the Business Object Field Editor.
| JSON Type | Business Object Field Data Type | Notes |
|---|---|---|
| Boolean | Boolean | |
| integer | Integer | integer is defined as a JSON number without a fraction or exponent part.
|
| object | Object | See the subfields description in Configure Business Object Fields. |
| number | Number | |
| string | String | |
| string | Date-time | When the OA3 format property is "date-time" |
| string | Date(no time) | When the OA3 format property is "date" |
| array | n/a | Not supported |
For OpenAPI properties with type "string", the following format values are explicitly unsupported:
- time
- binary
- byte
- long-text
Other format values are ignored and the field is mapped to the String data type.
The add-in ignores fields with unsupported data types when you create a Table layout or Form-over-Table layout in the Excel workbook. If, for example, a service that you use to retrieve data includes the binary attribute data type, the add-in ignores it and does not create a column in the data table for this attribute type.
Note:
File, text, and web page type attachments are supported. See Create Layouts for Attachment Business Objects.For more information, refer to the following OpenAPI and JSON resources: