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
Did you follow this?
docs.appian.com/.../Mapping_CDTs_to_Pre-defined_Database_Tables.html
I looked at that but didn't see anywhere that a view needed to have a unique identifier as well in order for it to be added to a Data Store.