9
Views
4
Comments
Database Type not Supported by Outsystems

We are integrating our application with a Postgres external database, and one of the columns is of type Timespan. Since there is no mapping option for this type on Outsystems, we used "Time" but got the error 

We are able to select the records mapping to a text type on Outsystems but updates and inserts fail.

Are there any suggestions other than converting the type on the external database extension?

Thanks in advance. 

Rank: #175

Hi pvivacqua ,

I also connected with Postgres external database, and for timestamp type field I made the configuration below in the integration studio:



if not works, try to mark as ignore, example:


You can see more details in this link:

https://success.outsystems.com/Documentation/11/Reference/OutSystems_Language/Extensibility_and_Integration/Mapping_External_DB_Data_Types_to_OutSystems_Data_Types



Hope this helps.

Regards.