Skip to main content
vempatir680997
vempatir680997
March 10, 2025
Question

Fetch Db tables into Appian Interface

  • March 10, 2025
  • 7 replies
  • 0 views

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
gayatria0439
March 10, 2025

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
vempatir680997Author
March 10, 2025

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
konduruc733182
March 10, 2025

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
vempatir680997Author
March 10, 2025

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
gayatria0439
March 10, 2025

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.

Terms & ConditionsAccessibility statement