I use a json reader component and then a jsonpath where i extract to different columns. My problem is that I can not figure out how I should go about to fetch all record from the json feed, I only get the first one. I suspect I am missing something basic here, but would realy appreciate some guidance here.
For this you need to use the collection query option in the JSON Path node. Select a field and click Add collection query. Ensure that the List box is checked.
Everything works fine, but in the field name there is also a date- and timestamp inculded. What would be the easiest way to remove that, can it be done already in the json reader node or should I add another node to do that?