DynamoDB "simplify" on GetMany List of Maps returns in NULL

[vadique]

Describe the problem/error/question

DynamoDB connector in GerMany “simplify” mode is setting List of Maps (Array of Objects) to NULL

Found a reference to this fixed issue for top-level Map, but it seems to not work for List of Maps

Bug with dynamodb connector using "simplify" setting

When the dynamodb connector is in “simple” mode, columns containing JSON data (datatype “map”) are being set to null. Here is the results of a query with simplify on, note the null value: [image] Here is the output of the exact same query with simplify turned off, note the same field with “M” data (map) now shows data: [image] Please share the workflow Share the output returned by the last node Information on your n8n setup n8n version: 0.207.0 Running n8n via…

Reproduce

1. Create a record in DynamoDB with an array of objects for some key
   { “foo” : [{“a”:“b”,“c”:“d”},{“e”:“f”,“g”:“h”}] }
2. Run DynamoDB “GetMany” with “Simplify : ON”
3. Key “foo” is returned as NULL

Share the output returned by the last node

Response with Simplify:OFF (unmarshalled)

{
  "_id": {
    "S": "fbbf22cdccd2"
  },    
  "uploaded_files": {
    "L": [
      {
        "M": {
          "filename": {
            "S": "1691767758030.....docx"
          },
          "file_description": {
            "S": "New"
          },
          "created_ISO": {
            "S": "2023-08-11T15:29:18.210Z"
          }
        }
      },
      {
        "M": {
          "filename": {
            "S": "1691767758031.....docx"
          },
          "file_description": {
            "S": "Update"
          },
          "created_ISO": {
            "S": "2023-08-12T12:22:08.110Z"
          }
        }
      },
      ...
    ]
  },
  ...
}

Response with Simplify:ON (marshalled)

{
"_id":"fbbf22cdccd2",
"uploaded_files":null,
...
}

Information on your n8n setup

• n8n version: 1.3.1
• Database (default: SQLite):SQLite
• n8n EXECUTIONS_PROCESS setting (default: own, main):default
• Running n8n via (Docker, npm, n8n cloud, desktop app):Docker
• Operating system:MacOS

[EmeraldHerald]

Hi @vadique Welcome to the community

Thanks for such a descriptive post on the issue - I’ve created a ticket for our engineering team to look into this