Formating json response in Ruby on Rails

Question

I am have student table with fields student_id, name and course_id. I need to fetch all records in the table as json response in Ruby on Rails. I need the json in the format

 {"records" : [{ "course" : 1  #course id in the table
    "students" : [ {
           "id" : 5
           "name" : "Ragav"
           },
           {
            "id":6,
            "name": "Rohith"
           }]
   },
   { "course":2,
     "students" : [ {
           "id" : 8
           "name" : "Ragav"
           },
           {
            "id":10,
            "name": "Rohith"
           }]
      }
 ]}

I am doing this using JBuilder like this

json = Jbuilder.new do |j|
  j.id student_id
  j.name name
end

in as_json method in model. I am new in RoR. Please help

nburkley · Accepted Answer · 2017-01-17 11:47:34Z

Since you're using JBuilder you should really be making uses of templates to render your JSON. Doing so keep your view and model layer separate, and allow you to cache and reuse template partials.

Here's a basic example:

Assuming this is the response to the index action on CoursesController you pass the @courses as an instance variable to the view

# Controller, responding to json requests
class CoursesContrller < ApplicationController

   respond_to :json

   def index
      @courses = Courses.all
   end
end

By default, this will look for a corresponding template at /views/courses/index.json.jbuilder

You can define your JSON structure using a JBuilder template:

json.records do
  json.array! @courses do |course|
    json.course course.id
    json.students do
      json.array! course.students do |student|
        json.id   student.id
        json.name student.name
      end
    end
  end
end

abhiahirwar · Accepted Answer · 2017-01-17 09:43:35Z

0

@students = Student.all
@studnetlist = @students.map do |u|
  { :id => u.id, :name => u.name }
end
json = @studnetlist.to_json

You can do this. Modify json according to your need.

answered Jan 17, 2017 at 9:43

abhiahirwar

135 bronze badges

Comments

kartik upadhyay · Accepted Answer · 2017-01-17 11:01:17Z

0

try this out in your model

 students_data = Student.select(:id,:name,:course_id).group_by(&:course_id).collect{|k, v| {course: k, students: v}}.as_json

{ records: students_data }

answered Jan 17, 2017 at 11:01

kartik upadhyay

1628 bronze badges

Comments

Denis · Accepted Answer · 2017-01-17 11:40:12Z

0

you need to create .jbuilder file in your views folder. For example:

app/views/students/show.json.jbuilder

json.extract! @student, :student_id, :course, :course_id

And of course render json in your controller method.

You can find useful examples here. Hope it helps.

answered Jan 17, 2017 at 11:40

Denis

1431 silver badge6 bronze badges

Collectives™ on Stack Overflow

Formating json response in Ruby on Rails

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related