Support dynamic primary keys in the records array

[zamai]

What area the feature impact?

Connectors

Revelant Information

Hi, I'm trying to build a connector (with builder UI) to Zoho People API, specifically Forms API.

The API response has the following structure:

[ 
  {
    "form_id_1": [
      {
        "Client_Name": "XTZ",
        "CreatedTime": "1686577603496",
        // other fields

       }
    ]
  },
  {
    "form_id_2": [
      {
        "Client_Name": "XTZ",
        "CreatedTime": "1686577603496",
        // other fields
      }
    ]
  },
 // ....
]

Where form_id_1, form_id_2 are the unique record IDs in the ZOHO system (which I would like to use as primary keys)

Currently using the builder UI I'm not able to unpack this structure. Also tried to write a transformation that would extract that ID into it's separate field - but also failed.

URL to my connector.