Trouble setting second level record selector in UI version 3.9.6

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

The user is facing an error related to setting the second level record selector in the connector configuration. The error indicates a dictionary update sequence length mismatch.


Question

I’m using UI version 3.9.6 and having trouble setting the second level record selector. The data contains

      "employeeId": [
        "A05130",
        "A10364"
]}```
This is what I have
`record_selector:`
          `type: RecordSelector`
          `extractor:`
            `type: DpathExtractor`
            `field_path:`
              `- employeeList`
              `- employeeId`
          `schema_normalization: Default`

And I'm getting the following error

```Something went wrong in the connector. See the logs for more details. - Traceback (most recent call last): File "/home/airbyte/.pyenv/versions/3.9.19/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 133, in read yield from self._read_stream( File "/home/airbyte/.pyenv/versions/3.9.19/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 232, in _read_stream for record_data_or_message in record_iterator: File "/home/airbyte/.pyenv/versions/3.9.19/lib/python3.9/site-packages/airbyte_cdk/sources/streams/core.py", line 185, in read for record_data_or_message in records: File "/home/airbyte/.pyenv/versions/3.9.19/lib/python3.9/site-packages/airbyte_cdk/sources/declarative/declarative_stream.py", line 136, in read_records yield from self.retriever.read_records(self.get_json_schema(), stream_slice) File "/home/airbyte/.pyenv/versions/3.9.19/lib/python3.9/site-packages/airbyte_cdk/sources/declarative/retrievers/simple_retriever.py", line 375, in read_records for stream_data in self._read_pages(record_generator, self.state, _slice): File "/home/airbyte/.pyenv/versions/3.9.19/lib/python3.9/site-packages/airbyte_cdk/sources/declarative/retrievers/simple_retriever.py", line 299, in _read_pages yield from records_generator_fn(response) File "/home/airbyte/.pyenv/versions/3.9.19/lib/python3.9/site-packages/airbyte_cdk/sources/declarative/retrievers/simple_retriever.py", line 445, in _parse_records yield from self._parse_response( File "/home/airbyte/.pyenv/versions/3.9.19/lib/python3.9/site-packages/airbyte_cdk/sources/declarative/retrievers/simple_retriever.py", line 245, in _parse_response for record in record_generator: File "/home/airbyte/.pyenv/versions/3.9.19/lib/python3.9/site-packages/airbyte_cdk/sources/declarative/extractors/record_selector.py", line 67, in select_records for data in normalized_data: File "/home/airbyte/.pyenv/versions/3.9.19/lib/python3.9/site-packages/airbyte_cdk/sources/declarative/extractors/record_selector.py", line 76, in _normalize_by_schema normalized_record = dict(record) ValueError: dictionary update sequence element #0 has length 1; 2 is required```
Any help/insight are greatly appreciated

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1726778838501389) if you want 
to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
["ui-version-3.9.6", "second-level-record-selector", "connector-configuration", "dictionary-update-error"]
</sub>