I'm trying to expose a view from the Appian DB via a Web API.
The Web API requires a Data Store Entity Constant. So I try to create a constant with a Data Store Entity type, but I need a Data Store Entity created with the View Data Type. I create the view data type without issue and add it to the Data Store but it will not save and publish (I get a 'Appian.vwMyView' is not of type 'BASE TABLE' (APNX-1-4178-000) error). Also I do not want the view created as a table as it is already created in my DB as a View. How would I add an existing view into a Data Store?
Discussion posts and replies are publicly visible
I realized that the CDT definition needed to have a a unique identifier as this link explains: https://community.appian.com/discussions/f/process/5818/having-trouble-getting-my-data-store-for-views-to-map-a-data-type-to-an-existing
I edited my CDT and added a primary key to one of my columns (a unique column) and it worked.