How can I just give a display name to columns in CDT which has a different name in database Tables. Also i have more questions regarding Appian features

Question

I have the following doubts:
Can I bring the output parameters from the different tables or views which is added as process variable-I hope it is possible?
Can I pass alias values as table input parameter like table column name is Purchase Order-but parameter name in the the JSON TEXT should be Order_Del_Number. both are same column, but I need to have the names changed.  How can I link them together. What are the different ways available in Appian.
Please check the below link for more details about the issue addressed before for similar  query.
https://community.appian.com/discussions/f/integrations/22331/web-api-that-connects-to-process-model--i-need-to-pass-input-parameter-different-and-get-a-different-output-parameter-can-anyone-help-me-out/87405#87405

Thanks
Sunu Sam

davel001150 · Accepted Answer

Look at the definition of the rule inputs.  Appian doesn't automatically update the version of the CDT being used.  So if you see ^1 or ^<version number>, you know that it's not using the latest.  Redefine the rule input, if that's what you see.  If not, we can troubleshoot what else it could be.

davel001150 · Answer

You can totally take any amount of anything you want from a database and make it a process variable. Then you can take any field of a process variable and store it elsewhere. You could read 2 tables into 2 CDTs, read a view into a 3rd, then use the type! type constructor or some other scripting to make a new CDT out of individual parts from those 3, or take parts and make them primitive type process variables by themselves. You have all manner of options.

The fields of a CDT can have any names you want, and each will link to one column in the table, which does not have to have a similar name. It can be anything. If you do want them to be different, you simply link fields to columns in the XSD file of the CDT.

Likewise, when you're reading from the integration, you can save the individual components of the item you receive into process variables that have any names you'd like, or store the whole thing in a process variable with any name. One solution would be to make a "fromService" CDT, and a "toDatabase" CDT . Then you can use the type! type creator to put each field in the "fromService" into the "toDatabase", so that the names don't need any association at all. You could even do some conversion or arithmetic in the process of going from one to the other (changing Decimals into Integers, concatenating firstName and lastName together, formatting phone numbers, etc.)

You have lots of options.

Sign up

Login with SSO

Login to the community

Login with SSO