extract column name , values from JSONB object and insert or update to database

Anonymous — Sat, 16 Nov 2024 04:47:43 GMT

Json format:

{
"attributeValue":[
{
"specName":"CUSTOMER_ID",
"specValue":"112345"
},
{
"specName":"CUSTOMER_TYPE",
"specValue":"12"
},
{
"specName":"CUSTOMER_FEATURES",
"specValue":"REPORT_GENERATION",
"specValueId":"223"
},
]
}

i might get n number of specname and spec value from the json object. extract the value dynamically and update or insert into target table.

In the above scenario

if a record is not present we will INSERT if record is already present we will update the value. how we can extract the column name and column value dynamically and insert or update the record (customer_id is primary key).

if we can not do dynamically say if we have fixed column names and column value how to do that.

below is expectation when we run the job it will read the json object and insert/update the target table data based on json object.

insert into customer(customer_id,CUSTOMER_TYPE,CUSTOMER_FEATURES,REPORT_TYPE) VALUES

(112345,12,'REPORT_GENERATION',223);

Re: extract column name , values from JSONB object and insert or update to database

fdenis — Wed, 04 Sep 2019 08:33:47 GMT

have a look at textractJsonFields https://help.talend.com/reader/jomWd_GKqAmTZviwG_oxHQ/Z7vp_~tJvB~UohrQmhu8SQ
good luck

topic extract column name , values from JSONB object and insert or update to database in Talend Studio

extract column name , values from JSONB object and insert or update to database

Re: extract column name , values from JSONB object and insert or update to database