Skip to main content
March 25, 2025
Solved

Where create the master data and how to get them

  • March 25, 2025
  • 4 replies
  • 0 views

I have to create the master data in my new app. That's it, Countries, Cities, Genders, Languages, etc.

Where do I have to create this kind of data? In an external database? And how can I get the data from the app?: CDT, REcordType, etc?

Thanks!

    Best answer by daiw

    Unless this data is available via API's, you would need to create a datasource - probably via Records. You can then create the objects that write, update, read and delete the data. 

    The external database you would initially be the Appian OOB MariaDB use unless your IT team has another database used.

    For reference ...

    https://docs.appian.com/suite/help/25.1/data-fabric.html

    https://docs.appian.com/suite/help/25.1/Using_the_Records_Tab.html

    4 replies

    daiwAnswer
    March 25, 2025

    Unless this data is available via API's, you would need to create a datasource - probably via Records. You can then create the objects that write, update, read and delete the data. 

    The external database you would initially be the Appian OOB MariaDB use unless your IT team has another database used.

    For reference ...

    https://docs.appian.com/suite/help/25.1/data-fabric.html

    https://docs.appian.com/suite/help/25.1/Using_the_Records_Tab.html

    varuntejg243705
    March 25, 2025

    HI [mention:8cdd6119fd07485ea8670348a7dd2045:e9ed411860ed4f2ba0265705b8793d05] ,

    Yes you can create it from external sources like google, kaggle, ChatGPT etc.

    Just import the datasets that you downloaded from the above sites, or execute the queries searching in web.

    Create recordtype from existing database - Link.

    Done!! you have master data that can be used for any applications.

    Just query the data using Expression rule and use it.

    Links for reference - 

    https://www.kaggle.com/datasets

    https://mavenanalytics.io/data-playground


    datasetsearch.research.google.com

    Hope this helps you!!!

    kalpeshg0081
    March 25, 2025

    Hi [mention:8cdd6119fd07485ea8670348a7dd2045:e9ed411860ed4f2ba0265705b8793d05] ,

    You can create the master data or reference data table in the Appian cloud database only. And create a record type to easily use them in your application.

    docs.appian.com/.../reference-data-tables.html

    mathieud0001
    March 26, 2025