Expression backed record - array fields not appearing in record

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

Parents
  • 0
    Certified Lead Developer

    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.

Reply
  • 0
    Certified Lead Developer

    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.

Children