cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
929
Views
0
Helpful
0
Replies

Mapping of Restful Web Service JSON Results to Grid

KDesch123
Level 1
Level 1

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

0 Replies 0

Review Cisco Networking for a $25 gift card