Skip to main content
September 1, 2021
Question

will uuid data type supported by Appian ?

  • September 1, 2021
  • 5 replies
  • 0 views

Hi, i have created external data source by using appian admin console. post creation i trying to create CDT for the existing postgre SQL Data base table.

below warning are populating due to data type miss matched. can some one suggest me how to overcome this problem ?

we are using external DB(PostGres Databae)

    5 replies

    danny.verb
    September 1, 2021

    I recommend using Text as the field type which will maintain the UUIDs. You would need to set uniqueness restraints on your database to ensure there are no duplicates

    September 1, 2021

    Hi Danny,

    Thank you for reply.

    but, while creating CDT in appian which are having UUID data type  the columns are not coming in fields. these are showing as not allowed to added. 

    how to do here ?

    danny.verb
    September 1, 2021

    After you create the CDT, you can manually add more fields