Skip to main content
bharathkumarreddys0001
October 23, 2022
Question

Cloud data base to process model interface

  • October 23, 2022
  • 6 replies
  • 0 views

I am facing issue in apian, as I need to get the data which is present in cloud data base store to
my appian process modeler in CDT form of every data, how to do that could you suggest your ideas on it 

mainly i need to get the data which is present in cloud data store to into my  appain  ui  inteface . every data which is present in cloud data store (table) need to come one by one in array form . 

6 replies

Participating Frequently
October 23, 2022

Hi, we can create a query rule to get the data from the database https://docs.appian.com/suite/help/22.3/fnc_system_a_queryentity.html.

And we can use that rule inside a script task to get the data and save it into your process variable https://docs.appian.com/suite/help/22.3/Configuring_the_Script_Task.html.

To display the data on the interface you can use the readOnly grid.

bharathkumarreddys0001
October 23, 2022

yes , i am getting data in script task but  i need data in CDT format in my process model  , i means with that data i need to perform one operation on it. and i need to get in arry format ( table which present in cloud data). so if u how to  write code in script task or expression rule could you send plz

Participating Frequently
October 23, 2022

Hi we just have to create the process variable of CDT fromat you want with multiple as true and you can use the update function to update the data.