topic Convert json file to table in Talend Studio

Convert json file to table

Sindhura1 — Fri, 15 Nov 2024 23:55:31 GMT

I have json file in my cloud storage bucket and I need to store into bigquery table.

Can someone please help me with this.

Anonymous — Mon, 26 Jul 2021 03:36:04 GMT

Hello,

Are you trying to load your json file from Google Cloud Storage?

Firstly, you can create a connection to Google Cloud Storage and download the file from GS.

After that, extracting the information from the json file.

The work flow should be: tGSConnection-->tGSGet-->onsubjobok-->tfileinputjson-->tExtractJsonField-->tBigQueryOutput

Let us know if it works.

Best regards

Sabrina

Sindhura1 — Tue, 27 Jul 2021 10:24:02 GMT

Hi Sabrina,

Thanks for your response. But I have multiple JSON files with different structure and need to handle them dynamically.

And also to load json file to bigquery.it should be Newline delimited json file.

But mine is not.