Issue with API Response Parsing using Record Selector

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

Summary

User is encountering a challenge while parsing an API response using the record selector in Airbyte, where they can choose to select either ‘groups’ or ‘fields’, but not both simultaneously.


Question

Hello everyone! I have this API response. I am trying to parse the response using the record selector but it seems I can either grab the groups (, groups) or the fields (, fields) but no both. Any ideas?

  "status": 200,
  "body": [
    {
      "groups": {
        "Day": "02/12/2024"
      },
      "fields": {
        "field1": <tel:266.0369307|266.0369307>,
        "field2": 625357,
        "field3": 0.4254160914485646,
        "field4": 57716000,
        "field5": 6200000,
        "field6": 1.0835071730542658,
        "field7": 10.742255180539193
      }
    }
  ],
....
}```


<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/C027KKE4BCZ/p1733234097679529) if you want
to access the original thread.

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

<sub>
['api-response', 'record-selector', 'parsing-issue', 'airbyte']
</sub>
2

You can use * selector and maybe apply transformations to map fields to another column. This is not the prettiest json response to handle.