I need to fill a grid table in a service form via an data retrieval rule using query type "Restful Web Service".
The result is a JSON structure. I have tried several possibilities to define the mapping of the JSON structure elements to the dictionary elements which should be displayed in a grid table.
For simplicity I used the JSON structure at https://github.com/jayway/JsonPath and the JSON path evaluator using various input formats, e.g. $.store..author which should the list of book author's.
Then I tried to do the same in the data retrieval rule on the "Use Lookup Results on the Form":
In my form I get the only the author of the last book in the JSON sequence for books. I tried several other version like "$store.book[*].author" but either the same result or an error message!
How do I have to specify the JSON path in order to get the grid filled with all four entries?
Thanks for an ideas.