ETL: Xplenty-Consoleの使い方

field1 ='hello'
field2 ='world'
CONCAT(field1, field2)

[{
	"label": "FIRST NAME",
	"value": "Taro",
	"key": "first_name"
}, {
	"label": "LAST NAME",
	"value": "Yamada",
	"key": "last_name"
}, {
	"is_required": "required",
	"datatype": "text",
	"label": "GENDER",
	"value": "Male",
	"key": "gender"
}]

field1='[{"label":"FIRST NAME","value":"Taro","key":"first_name"},{"label":"LAST NAME","value":"Yamada","key":"last_name"},{"is_required":"required","datatype":"text","label":"GENDER","value":"Male","key":"gender"}]'

JsonExtractScalar(field1,'$.[0].value')
==> Taro
JsonExtractScalar(field1,'$.[1].value')
==> Yamada
JsonExtractScalar(field1,'$.[2].value')
==> Male