Skip to main content
vempatir680997
Inspiring
Mar 10, 2025 6:44 AM UTC
Question

Fetch Db tables into Appian Interface

Hi team,

I need help regarding to the Fetching the DB table names into Appian INV, using the table name,

Example: i have table name called Students in DB if i select that name in Appian Interface I need to display that Students table details in Interface

Is it possible or not if it's possible could anyone help me with it how we can do it

7 replies

gayatria0439
Participating Frequently
Mar 10, 2025 7:44 AM UTC

Hi [mention:b60fb15446f349da857c15dcd9b29bdb:e9ed411860ed4f2ba0265705b8793d05] , Yes, we can display the details in the interface. First, we need to create a record or CDT to connect with the table and retrieve the data into Appian. Later, we can fetch the data using a!queryRecordType() or a!queryEntity() or by creating a grid, or we can customize the interface based on the requirements or design.

vempatir680997
Inspiring
Mar 10, 2025 7:59 AM UTC

Hi [mention:0bc4c4bef9ec41cd9ea711bb76538c5d:e9ed411860ed4f2ba0265705b8793d05] ,

In your scenario i have to create the Records or CDT's in Appian but i don't want to create those in appian,
if i want to create those record and CDT's it should be dynamic only,
example: if a new table added in DB after if i select the same name in Appian that table will display with out creating the record or interface if we have to create record or CDT it should be dynamic only.

konduruc733182
Inspiring
Mar 10, 2025 7:50 AM UTC

Hello [mention:b60fb15446f349da857c15dcd9b29bdb:e9ed411860ed4f2ba0265705b8793d05]  Do you have records for all these tables? Have you created any stored procedures for doing this? How are you planning to select the DB Name. Also how many tables do you have or plan to show on selection in the interface?

vempatir680997
Inspiring
Mar 10, 2025 7:55 AM UTC

No i don't have records for all but it should be dynamic with the name of the table i want to fetch the table into Appian interface,
if i created new table in DB and after if i call that table name into appian interface so i need that table name and i have 8 tables currently in DB

gayatria0439
Participating Frequently
Mar 10, 2025 7:59 AM UTC

If you want to fetch the details to display in the Appian interface, we first need to connect to the database using a CDT or Records.