API Express with SQL Server issue

[Bernie]

When I generate a new API Express database service from SQL Server, some columns are shown with the datatype "CLOB". These columns don't show up when I try to utilize the service by the API Express Generator. If I do add them manually creating new data sets behaves kind of odd and throws errors.
Do certain data types just not work?

[Serhii Kulibaba]

Hello Bernie,

Appery.io API Express supports the data type = CLOB.

Please send values into that parameter as base64 sting (Appery.io will convert it automatically into the binary format) and vice versa (it will convert binary data from your database into the base64 string)

The problem with generation these parameters: Please send us an ID of your database.
Click on the database connection

and read the URL there: https://appery.io/apiexpress/connecti...
Please, send us this URL

Also, send us a name of the database table you use there