Custom Connector Setup Issue with Record Selector and Transformations


The user is facing issues setting up a custom connector for an API to extract specific values from an array in the response. They are struggling with using the record selector and transformations to get a single column with the meter.serials values.


Hi everyone! I need a bit of help with a custom connector I’m trying to setup for an API. I get the response in the following format:

    "routes": [
        "code": "000002",
        "name": "TestRoute",
        "meter.serials": [
I would need to get a single column just with the _<|>_rials values. As I need to use this as a parent for another API call. I’m trying to use the record selector in the custom connector builder, but I can’t figure out how to do this.

If I use only _routes, I get the 3_ columns _code, name, <|>_rials, but the meter.serials is still an array. If I try to use as record selector _routes, * ,meter.serials_ I get an: *list indices must be integers or slices, not str* which I guess it’s actually normal.

I also tried using “Transformations”, but after removid the two other columns, I can’t figure out how to break down the array into multiple rows.

Did anyone faced a similar issue and found a solution? Thank you!



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here]( if you want to access the original thread.

[Join the conversation on Slack](

["custom-connector", "api", "record-selector", "transformations", "array-values"]