Please look it this post: RESTful and XML Integration - #22 by Reijer and the post above. This looks a bit like what you have/want.
I think you need not to write name:
but value_template: '{{ value_json[...][...] }}'
like in the example I link above.
And the trick is to find the correct strings to put between the [ ]'s.