Hi All,
I am new to snaplogic.
I've got this json output from Google Directory where the phone and fax number has field as value.
I've got two fields in DB to get both the values of phone and fax.
"phones":[
{
"value":"08 8344 1867"
"type":"work"
}
{
"value":"08 8344 7265"
"type":"work_fax"
}
]
"primaryEmail":
"abc@abc.com"
But in transformation, I can only see one type and value. This is the expression I get when I drag the field: jsonPath($, "$phones[*].value")
How do I get both values in different columns.
Let me know if you need more info.
Mayur
