Create a Json and send to BigQuery as a nested fields

Anonymous — Sat, 16 Nov 2024 08:32:14 GMT

Hello,

I'm trying to create the following flow:

1. Read from 3 DB tables and join them (Done)

2. Create from the DB data a JSON field (using tWriteJSONField) - Done

3. Send the results to other DB (Big Query) in the following format: column 1: string, column 2: JSON

For example:

tWriteJSONField output is many JSONs string as the following: (url is the loop element).

I need the final format to be as the follow:

"http://google.com/", {"id":"3","type":"28","sub_type":"3","exp":[],"or":"3","date":"19-05-2015","num":[]}}

How can I define the JSON scheme that will generate only the "url" and the JSON string?

Screenshots are attached.

Thanks,

Emma

topic Create a Json and send to BigQuery as a nested fields in Talend Studio