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.
If you are able to sync all the data, you could create separate service backed Records for each of those relations and simply relate them together. If not, you'll need to create your own schema and populate the data for specific Records.
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?
Thanks for the reply Mathieu. So we'd basically need to transform the payload so that those arrayed fields are joined into a single string, for example, and pass that back to the record?
Hi johng, were you able to resolve this?