Datasource JSONPath Array Not Returning Data
My JSON datasource has the following structure:
{
"name" : "test",
"customerId" : "123",
"contracts" : [
{
"url" : "http://1231"
},
{
"url" : "http://1232"
},
{
"url" : "http://1233"
}
]
}
I can extract name and customerId using Column Paths = name and customerId, but when I try to extract the whole array for contracts, I get nothing. I can access each url entry using contracts[0].url, but anything like contracts[0:]url or contracts[*].url is failing. How can I get the whole array?
