Forum Discussion
Hello @mtran21
Here’s a simple pipeline for GET call:
I’m using the following Service URL to GET weather info in this case for London:
As you can see, you need to provide your APPID, you will have that after successful registration on the OpenWeatherMap.
There’s a lot of different ways to get weather information about one or more cities.
Also, you can make this or another call using pipeline parameters as query parameters.
After a successful api call, you need a mapper, to make your data flat and to map only needed fields.
And then you can insert data in DB table, in this case I’m using MySql. No matter which DB you use, you are going to need an Account.
Hope this will help.
BR,
Marija
- darshthakkar4 years agoValued Contributor
Please check this out, might be helpful to you @tk-wf
Thanks @darshthakkar that is somewhat helpful.
The downside is that for us it misses the requirement of writing multiple sheets to a workbook (sans manual intervention).
It is a bit surprising that the Excel Formatter(s) cannot produce a field recognized as a Formula, though not sure if the fault lies in the SL implementation, a Java Component, or on the Excel side.
As a result of this, we are reevaluating the requirement to have the Formulas in the output, which might be the better thing anyway.
- darshthakkar4 years agoValued Contributor
Yes, I agree to your workaround @tk-wf.
We might be implementing it in an incorrect way on SL and I still haven’t achieved formulas on excel.
Related Content
- 4 months ago
- 3 years ago
- 3 years ago