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" } ...
Forum Discussion
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.
Hi rcummings,
Im bit busy today (moving house) so cant reproduce today, however, ive just remembered when i was using the json datasource a couple of years ago i always had problems. It seemed a little flakey and struggled to get it to work and dont know if the functionality has changed.
I could be wrong, but i think i got around the problems by using the xml datasource but switched the type to jsonpath within the xml datasource. This worked for me.
Can you try the xml datsource but changing the type?
I will get to looking at it tomorrow, but wanted to respond with this possible workaround whilst youre waiting.
Cheers,
Rich
Im bit busy today (moving house) so cant reproduce today, however, ive just remembered when i was using the json datasource a couple of years ago i always had problems. It seemed a little flakey and struggled to get it to work and dont know if the functionality has changed.
I could be wrong, but i think i got around the problems by using the xml datasource but switched the type to jsonpath within the xml datasource. This worked for me.
Can you try the xml datsource but changing the type?
I will get to looking at it tomorrow, but wanted to respond with this possible workaround whilst youre waiting.
Cheers,
Rich
