Rails Httparty JSON to params to save

Question

Rails 4.5 Ruby 2.3.1

I am getting json from an API and trying to store the following into a model CLrates 1. timestamp as unix time (date) 2. Currency_code (string) 3. quote (decimal monetary value)

I can use the following in irb after parsing the json and know how to get the elements individually using: response["quotes"]. How can I generate params to be saved in the model above when the body is as follows:

irb(main):036:0> puts response.body
{
 "success":true,
 "terms":"https:\/\/xxxxx.com\/terms",
 "privacy":"https:\/\/xxxxx.com\/privacy",
 "timestamp":1504817289,
 "source":"USD",
 "quotes":{
   "USDAED":3.672703,
   "USDAFN":68.360001,
   "USDCUC":1,
   "USDCUP":26.5,
   "USDCVE":91.699997,
   "USDCZK":21.718701,
    ............ many more lines removed for brevity
   "USDZWL":322.355011
 }

I can do this using a separate associated model but have very little idea how to create the params to save to a single table.

The following links got me to this point and well worth a read if you need info on httparty GET (client): 1. http://www.rubydoc.info/github/jnunemaker/httparty/HTTParty/ 2. http://eric-price.net/blog/rails-api-wrapper/ 3. https://www.driftingruby.com/episodes/playing-with-json

The class and method in lib/clayer.rb:

 class clayer
   include HTTParty
   format :json
   read_timeout 10

  def self.get_quotes
    response = HTTParty.get('http://www.nnnnnnn.net/api/live?
    access_key=nnnnnnnnnn&format=1')
  end
end

I used irb as I am still learning how to run this through rails c. This will be called in the controller and saved however need to work out how to get the params from the json

Thanks for the help

OK: after digging I think I am on the right track I get the response["QUOTES"], loop through them and build the params required saving each at the end of the loop

rates = response["QUOTES"]
rates.each do |k,v|
  clrate = Realtimerates.new
  clrate.date = response["timestamp"] 
  clrate.countrycode = "#{k}"
  clrate.price = "#{v}"
  clrate.save
end

Going to give this a whirl

In model

class Realtimerate < ActiveRecord::Base

 include HTTParty
 format :json
 read_timeout 5


def self.get_cl_rates
    response = HTTParty.get('http://www.mmmmm.net/api/live?access_key="key"&format=1')
    rates = response["quotes"]
    rates.each do |k,v|
        create!(
        date: Time.at(response["timestamp"]),
        country_code: "#{k}",
        price: "#{v}")

    end

 end

end

In the controller:

def index
  Realtimerate.get_cl_rates
  @realtimerates = Realtimerate.all
end

This is working and shows latest GET.

Answer 1

You already have a hash in your response.body. All you need to do now is to assign the relevant key-value to your model's attributes. e.g.

clrate = ClRate.new
res = response.body
clate.time = res["timestamp"] 
...
clate.save