Skip to main content
August 9, 2021
Question

CDT data to SQL Query

  • August 9, 2021
  • 3 replies
  • 0 views

Hello Everyone,

  1. I had a requirement where I had to read an excel file and populate that excel data in a CDT (let's call it example_CDT) for displaying that data in an interface. 
  2. I did that and now the whole data is there as a list of items where items are of type example_CDT.  This CDT is already mapped to a table in the DB. 
  3. Now, I want to generate and download SQL queries that can be used to insert the data which is there in the list of CDT into the DB.

Is there any Appian smart service available through which I can convert get SQL queries from CDT data?

please consider example_CDT as a Nested CDT.

3 replies

mikes0011
Brainy
August 9, 2021

Is there any particular reason why you can't use the Appian Write to Data Store Entity functionality to handle this?  Why the extra steps to "generate and download" SQL queries?

The Expression Guru
August 10, 2021

It is so because excel is being populated by another team and we as developers want to review the data once before it is inserted into DB.

mikes0011
Brainy
August 10, 2021
developers want to review the data

Why does this require generation / download of SQL scripts?   You could simply show the data on an interface within the process instance for example.

The Expression Guru