Fetch records from DynamoDb db table

{
  "cDate":"2024-03-04",
  "myList":[
     {
       "M" : {
          "rt":"1.06",
          "sDt":"2024-03-01",
          "c":"ABC",
          "t":"BCD"
        }
     },
     {
       "M" : {
          "rt":"0.96",
          "sDt":"2024-03-01",
          "c":"CDE",
          "t":"DEF"
        }
     }
   ],
   "type":"inter"
} 

Read the json struct you provide , conclude you may missed there still is a attribute M below myList class , so orm framework might could not found the mapping column, you should make it up , like following code snippet

public class MyTable {
    private String cDate;
    private String type;
    private List<MyListItem> myList;

    // Getters and setters
}

public class MyListItem {
    private MyItem M;

    // Getters and setters for M
}

public class MyItem {
    private String rt;
    private String sDt;
    private String c;
    private String t;

    // Getters and setters
}

and then do you orm query , the question encounter may be processed

Dynamic structure

if you want receive the Dynamic structure try to use additional class for trans;

public class MyAttributeValueItem {
    private Map<String, AttributeValue> M;

    // Getters and setters for M
}

//  above is your code snippet 
List<MyTable> collectedItems = new ArrayList<>();

pageResult.stream().forEach(page -> page.items().stream().forEach(mt -> {
    log.info(mt.toString());
    List<MyList> myList = mt.getMyList().stream()
        .map(myListItem -> {
            if (myListItem.getM() != null) {
                MyItem myItem = myListItem.getM();
                return new MyList(myItem.getRt(), myItem.getsDt(), myItem.getC(), myItem.getT());
            } else {
                MyAttributeValueItem myAttributeValueItem = myListItem.getMAttribute();
                Map<String, AttributeValue> attributes = myAttributeValueItem.getM();
                return new MyList(
                    attributes.get("rt").n(),
                    attributes.get("sDt").s(),
                    attributes.get("c").s(),
                    attributes.get("t").s()
                );
            }
        }).collect(Collectors.toList());
    mt.setMyList(myList);
    collectedItems.add(mt);

above is basic operate code snippet ,its unified the output structure in orm query layer , you can modify it in your own structure.

or that you can receive both structure with M or without M , abstruct a new method to standardise it .

all in all ， there must be a abstract layer for standardise query .