Reformat JSON in Rails

Question

Is there a utility that will help me reformat JSON structure in Rails, JS or Ruby?

I'm making a call to a legacy db with raw sql. sql_result = ActiveRecord::Base.connection.execute(sql) render json: sql_result, root:false

Data returns fine but I need to reformat this JSON output... ["MyBiz, LLC", "55 Main St","San Francisco","CA","94103", "3/06/2007","12/31/2007"]

To look like this... { "Company":"MyBiz, LLC", "Address":"55 Main St", "City":"San Francisco", "State":"CA", "ZipCode":"94103", "Start":"03/06/2007", "End":"12/31/2007" }

Robert Krzyzanowski · Accepted Answer · 2014-03-28 17:39:05Z

1

The field names were lost. Try something like:

 keys = ["Company", "Address", "City", "State", "ZipCode", "Start", "End"]
 ["MyBiz, LLC", "55 Main St","San Francisco","CA","94103", "3/06/2007","12/31/2007"].
   each_with_index.map { |v, i| { keys[i] => v } }.reduce(:merge).to_json

 #  => "{\"Company\":\"MyBiz, LLC\",\"Address\":\"55 Main St\",\"City\":\"San Francisco\",\"State\":\"CA\",\"ZipCode\":\"94103\",\"Start\":\"3/06/2007\",\"End\":\"12/31/2007\"}"

answered Mar 28, 2014 at 17:39

Robert Krzyzanowski

9,34430 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user913129 Over a year ago

This is beautiful. The code I posted wasn't exactly the right format but you answered correctly. Thanks for the help!

Sanjeev · Accepted Answer · 2014-03-28 17:42:53Z

0

 keys = ["Company", "Address", "City", "State", "ZipCode", "Start", "End"]
 Hash[*keys.zip(sql_result).flatten]

answered Mar 28, 2014 at 17:42

Sanjeev

3084 silver badges11 bronze badges

Collectives™ on Stack Overflow

Reformat JSON in Rails

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related