rcummings
New Contributor
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Datasource JSONPath Array Not Returning Data
Thank you... When I use "contracts", I get the first entry only when there is just a single element in the array, "[]" if the array is empty and for records with multiple elements in the array I get nothing. If I use contracts[*].url, I get nothing for any records. If I use contracts[0].url, I get the first element for records that have elements. And I can use other integers to access other elements. But I can't get all of them.991Views0likes1CommentDatasource 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?1KViews0likes6Comments