Mapping of Restful Web Service JSON Results to Grid

Unanswered Question
Feb 13th, 2017
User Badges:

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.

Kalle


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.

Actions

This Discussion