I have created a CDT and it has passed a verification too.
But when I try to insert that in the Data Store it throws below error:
The data source schema does not match the type mappings: Missing column: a_id in "table_name" (APNX-2-4056-000)
Please help
Discussion posts and replies are publicly visible
If you're trying to write data to a table using Appian the CDT needs to define one of the attributes as a Primary Key. The message you are getting is saying you do not have this defined as there MUST be a Primary Key defined for every table you're mapping to from Appian.
So I was adding a view, I need to put a primary key in a view, right?
AFAIK you cannot write to a VIEW. But yes, even a VIEW should have one of the columns defined as a Primary key.