topic Re: Cannot get JSON Data with REST connection in Archived Discussions

Cannot get JSON Data with REST connection

cansu — Thu, 08 May 2025 17:40:29 GMT

Hello, I am trying to pull json values from airtable table with a REST connection. Connection works in Postman and I am able to see json data. But I keep getting this error on Pipeline Designer. Please help.

Fetching a new sample
Could not fetch the sample for DatasetId(fe968567-4164-48c9-b5ac-2721f9360756). - Property 'configuration.dataset.datastore.authentication' is required. - Property 'configuration.dataset.datastore.base' is required. - Property 'configuration.dataset.datastore.connectionTimeout' is required. - Property 'configuration.dataset.datastore.readTimeout' is required. - Property 'configuration.dataset.format' is required. - Property 'configuration.dataset.maxRedirect' is required. - Property 'configuration.dataset.methodType' is required. - Property 'configuration.dataset.resource' is required.

Thank you,

Cansu

Re: Cannot get JSON Data with REST connection

Ramya_V — Mon, 25 Jul 2022 09:34:25 GMT

Hello @Cansu Mericli

For JSON: you must respect a specific format for your JSON values and be consistent: sequence of records, one after another, separated, or not, by a line feed. Each record does not have to be on a single line. At the end, the data in the text area is not a typical JSON document with square brackets.

Example:

{

"Id": 3146717,

"PosTime": 1525097499899,

"Latitude": 48.8585,

"Longitude": 2.4921,

"Operator": "Air France"

}

{

"Id": 3757865,

"PosTime": 1525097474634,

"Latitude": 48.5018,

"Longitude": 2.2246,

"Operator": "Lufthansa"

}

As per the error, please also check the parameter that is missing from your dataset.

Refer to the below for more information

https://help.talend.com/r/en-US/Cloud/data-preparation-user-guide/creating-test-dataset

Re: Cannot get JSON Data with REST connection

nicoclavier — Tue, 13 Dec 2022 14:25:08 GMT

Hi @Cansu Mericli

Did you happen to fix your issue ? I'd be curious, meeting the exact same situation.

Re: Cannot get JSON Data with REST connection

cansu — Sat, 24 Dec 2022 02:03:03 GMT

Hi @Nicolas Clavier, unfortunately couldn't find a solution for the pipeline designer. Apparently, it requires very specific structure for JSON. Instead, I run python script in Data Studio to fetch the data.

Re: Cannot get JSON Data with REST connection

LHall1681108134 — Fri, 12 May 2023 10:33:22 GMT

You still can't find the solution? But I think the error message suggests that certain properties related to the dataset configuration are missing, such as authentication, base, connection timeout, read timeout etc resource. I