Setting JSON Source with Multiple Records

Slack Knowledge Base Q&A API, Terraform and Other Topics
, , , ,
1

Summary

When setting a JSON source with multiple records, the user wants to specifically extract the ‘objetsTouristiques’ records. They are considering starting with the connector builder to query the API URL.


Question

Hey guys ! I try to set a json source. the json is formatted like that (in a short version)

   "query": {
      "selectionIds": [
         64246
      ]
   },
   "objetsTouristiques" : [
      {
         "type": "HOTELLERIE",
         "id": 4661478,
      },
      {
         "type": "AUTRE",
         "id": 45356,
      },
      ....
    ]
}```
When I set the source I have only one record. I'd like the records to be the objectsTouristiques. But of course I don't really know how to do that :slightly_smiling_face:
I wanted to start with the builder maybe and query the api url. But then I don't know how to return only the objetsTouristiques :slightly_smiling_face:

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

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

<sub>
["json-source", "multiple-records", "objets-touristiques", "connector-builder", "api-url"]
</sub>
2

Oh, it’s the Record Selector option