calling a url that returns JSON, how to process the JSON

, , ,
1

Hi

I need to call this url

http://api.exchangeratesapi.io/2020-05-01?symbols=USD,GBP&base=DKK

which will return this JSON

{“rates”:{“EUR”:0.1340770138},“base”:“DKK”,“date”:“2020-04-30”}

How should I do that in webMethods? I use version 10.3

If the url returned xml I could use this service pub.xml:loadXMLNode where I will be able to specify the url as an input variable.

Kind regards Mikael

2

Using pub.client:http and setting “useJSSE” = yes made it work and method = get.

3

first use pub.string:bytesToString service to convert “body/bytes” to String. Then use pub.json:jsonStringToDocument service to convert JSON string Document.

4

Also - you would not want to call URL with parameters in the URL and instead parameterise in your service.