- SAP Managed Tags
perry.clausen3 wrote an excellent blog about consuming RWS in Data Services here: https://blogs.sap.com/2016/06/07/consuming-rest-web-service-in-sap-data-services-using-web-service-r...
In short: he shows how to call Google's geocoding API with Data Services to retrieve geolocation data in an XML format. I've had no issues whatsoever replicating the demo.
Now I'm trying to do basically the same thing, with 1 change: I want to retrieve the response in a JSON format. (http://maps.googleapis.com/maps/api/geocode/json?address=1600%20Amphitheatre%20Parkway,%20Mountain%2...)
I'v attached the .wadl & .xsd used to create the Web Service datastore (had to rename both files to upload them here).
Creating the datastore and importing the json function works fine. I'm also able to call the json function from a query transform without an issue. I'm having trouble unnesting the result of the function. The query isn't validating, as shown here:
I'm not sure what the problem is exactly. When adding another query transform after the "unnesting" query, I can clearly see all output columns:
Am I missing something?
| User | Count |
|---|---|
| 41 | |
| 15 | |
| 11 | |
| 9 | |
| 6 | |
| 5 | |
| 5 | |
| 5 | |
| 5 | |
| 4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.