Pass json result of rest webservice into page items
Hello,
I have created a webservice reference, and a from with report on that webservice. I fill in a zipcode and click submit and the results will put in a collection.
The response is a json object and is stored in the CLOB001 column of the collection. Example. : {"success":true,"resource":{"street":"Amsterdamseweg","postcode":"1181BP","town":"Amstelveen","municipality":"Amstelveen","province":"Noord-Holland","latitude":52.3163363636,"longitude":4.856420303}}.
But I want that if you fill in a zipcode that only the values of street and town from the json object will passed in two seperated page items. What is the best way to achieve this?