How to save the complete API response array inside another object in Connector Builder UI?
Hi everyone, In connector builder I want to save the complete API response(array) inside the another object(say data). how can I do that in the connector builder UI?
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.
In the Connector Builder UI, you can specify the property of the response object that holds the records using the “Record selector” field. If the response body itself is an array of records, you can omit the record selector and the whole response becomes the list of records. This is applicable when the response is similar to the one from the CoinAPI API as shown in the documentation. However, if the array of actual records is nested multiple levels deep in the response, you need to set the record selector to the property path. For example, for the “Archive” NY Times API, the record selector needs to be set to “response,docs” to select the nested array as shown in the documentation. In your case, if you want to save the complete API response inside another object named data, you would need to set the record selector to data if data is the property that holds the records in the response object. If data is nested within other objects, you would need to provide the complete path to data in the record selector. Please note that the Connector Builder UI is in beta and is still in active development. If you encounter any issues or have further questions, you can reach out to the Airbyte team via their Slack channel or email them at [email protected] as mentioned in the overview.
Hmmm. I’m not sure how to do that yet. What are you going to do with that data next? How do you want to use it?