Hi all,
We've created an expression backed record type, with the expression calling an integration to return the data. In the returned payload there are several fields which are return as lists (i.e. List of Text String), and these are not appearing in the record type and I can't seem to map them.
Record type data model:
Payload:
As you can see, the list of text string names/ids fields aren't appearing in the record.
Is there any way to resolve this?
Discussion posts and replies are publicly visible
Appian records are, as of now, only a abstraction on top of other data sources like a relational database, and have very similar limitations. One is, that you can only store a single value in one field.
To map such a nested data structure to the DB and Record, you will have to build a relational data model and write an expression which creates the necessary entities from the incoming data.
Thanks for the reply Stefan. Just to be clear, do you mean essentially transforming the incoming payload in the expression rule? I.e. when the expression calls the integration, loop through the returned results and create a map (with the arrayed fields transformed into a joined array for example), which is then passed back to the record?