Hi, I'm trying to decode a JSON to get a field for a saved search, but i would like to go through the structure of the JSON
this is my JSON
"committente": {
"cf": "00180940041",
"denominazione": "S.A.I.S.E.F. SPA",
"piva": "IT00180940041",
"indirizzo": "VIA VITTORIO VENETO N. 4",
"cap": "12084",
"comune": "MONDOVI'",
"provincia": "CN",
"nazione": "IT"
},
i need to get the field "denominazione"
If i run
REGEXP_SUBSTR({custrecord_nexil_elect_impbill_json}, '"committente":"(.+?)"', 1, 1, NULL, 1)
i get no result.
trying
REGEXP_SUBSTR({custrecord_nexil_elect_impbill_json}, '"denominazione":"(.+?)"', 1, 1, NULL, 1)
get the right value but can be mismatched with other JSON part...
i was trying to concatenate the query
REGEXP_SUBSTR(
REGEXP_SUBSTR({custrecord_nexil_elect_impbill_json}, '"committente":"(.+?)"', 1, 1, NULL, 1)
, '"denominazione":"(.+?)"', 1, 1, NULL, 1)
but no result...
any suggestion?