i have one table in database and i want to get those data through GET web api call please suggest.
Discussion posts and replies are publicly visible
SO first question: why not get it directly from the database table using a queryEntity() ?
Thanks Stewart.
Actually i am new in appian only 1 month experience , so just wanted to best approach here
So, adding an additional layer above the database would be more work/overhead than going directly to the database. Appian supports a number of different database technologies (MySQL, MS SQL Server, Oracle, IBM DB2) and provides capabilities to read/write/delete content from them.
I am using my sql and please share me approach which would give me data from employee table.
If you have a pre-existing database table then you'll need to:
A WebAPI call would only be needed if you want to expose Appian data to an external system. If this is not your use case, then Stuart has highlighted how it can be achieved but would strongly suggest you read up on some content about Appian and what functions it can offer.
https://docs.appian.com/suite/help/19.2/Query_Recipes.html is page all about the query types Appian can offer but it sounds like you might be better off going through some of the tutorials first
https://docs.appian.com/suite/help/19.2/Tutorials.html