JSON:ParseError in ruby

Question

i am using sequel and json gem in ruby

when i try to converting a record into json object and trying to get its fields my code is

require 'json'
require "rubygems"
require "sequel"
require 'yaml'
require "sequel/extensions/pg_array"

DB = Sequel.connect('postgres://ritesh:newpassword@localhost')

pokes=DB[:use];
car = {:make => pokes.all, :year => "2003"}
cp = pokes.filter(:id =>1).first.inspect

jj = cp.to_json
puts jj
parseObject = JSON.parse(cp)

in the last line i am getting error

"{:id=>1, :first_name=>\"Ritesh\", :last_name=>\"Mehandiratta\", :email=>\"riteshmehandiratta@gmail.com\", :zipcode=>\"127021\", :comapnay_name=>\"heroku\", :google_profile=>\"google\", :skype=>\"helloworld\", :phone=>\"9013895056\", :about=>\"i am a great person\", :linkedin_profile_url=>\"linkedin.com\", :comapny_url=>\"company.com\", :needs=>[\"Web Designer\", \"Web Developer\", \"SoftWare Developer\"], :offering=>[\"Web Designer\", \"Web Developer\", \"SoftWare Developer\"], :upcoming_meetings=>[1, 2, 3, 4], :past_meetings=>[1, 2, 3, 4], :top_matches=>[1, 2, 3, 4]}"
/home/ritesh/.rvm/rubies/ruby-1.9.3-p327/lib/ruby/1.9.1/json/common.rb:148:in `parse': 743: unexpected token at '{:id=>1, :first_name=>"Ritesh", :last_name=>"Mehandiratta", :email=>"riteshmehandiratta@gmail.com", :zipcode=>"127021", :comapnay_name=>"heroku", :google_profile=>"google", :skype=>"helloworld", :phone=>"9013895056", :about=>"i am a great person", :linkedin_profile_url=>"linkedin.com", :comapny_url=>"company.com", :needs=>["Web Designer", "Web Developer", "SoftWare Developer"], :offering=>["Web Designer", "Web Developer", "SoftWare Developer"], :upcoming_meetings=>[1, 2, 3, 4], :past_meetings=>[1, 2, 3, 4], :top_matches=>[1, 2, 3, 4]}' (JSON::ParserError)
    from /home/ritesh/.rvm/rubies/ruby-1.9.3-p327/lib/ruby/1.9.1/json/common.rb:148:in `parse'
    from hello1.rb:15:in `<main>'

when i parse jj variable like this as suggested in answer

jj = cp.to_json
puts jj
parseObject = JSON.parse(jj)

then i am getting error

"{:id=>1, :first_name=>\"Ritesh\", :last_name=>\"Mehandiratta\", :email=>\"riteshmehandiratta@gmail.com\", :zipcode=>\"127021\", :comapnay_name=>\"heroku\", :google_profile=>\"google\", :skype=>\"helloworld\", :phone=>\"9013895056\", :about=>\"i am a great person\", :linkedin_profile_url=>\"linkedin.com\", :comapny_url=>\"company.com\", :needs=>[\"Web Designer\", \"Web Developer\", \"SoftWare Developer\"], :offering=>[\"Web Designer\", \"Web Developer\", \"SoftWare Developer\"], :upcoming_meetings=>[1, 2, 3, 4], :past_meetings=>[1, 2, 3, 4], :top_matches=>[1, 2, 3, 4]}"
/home/ritesh/.rvm/rubies/ruby-1.9.3-p327/lib/ruby/1.9.1/json/common.rb:148:in `parse': 743: unexpected token at '"{:id=>1, :first_name=>\"Ritesh\", :last_name=>\"Mehandiratta\", :email=>\"riteshmehandiratta@gmail.com\", :zipcode=>\"127021\", :comapnay_name=>\"heroku\", :google_profile=>\"google\", :skype=>\"helloworld\", :phone=>\"9013895056\", :about=>\"i am a great person\", :linkedin_profile_url=>\"linkedin.com\", :comapny_url=>\"company.com\", :needs=>[\"Web Designer\", \"Web Developer\", \"SoftWare Developer\"], :offering=>[\"Web Designer\", \"Web Developer\", \"SoftWare Developer\"], :upcoming_meetings=>[1, 2, 3, 4], :past_meetings=>[1, 2, 3, 4], :top_matches=>[1, 2, 3, 4]}"' (JSON::ParserError)
    from /home/ritesh/.rvm/rubies/ruby-1.9.3-p327/lib/ruby/1.9.1/json/common.rb:148:in `parse'
    from hello1.rb:15:in `<main>'

instead of cp in jj only in string there is difference of

'{:id=>1
'"{:id=>1

note in two errors but error is same

why i am getting this parser exception error this is a valid json string.i have to convert this into a hash please tell a way how to convert into hash and how to rectify this error

JSON.parse(jj) will also give parse error. Because you used `inspect` first then converted to `json`. So `inspect` also adds `slash`. It creates ambiguity to `parse`. I think it may be bug in my gem. Try using latest version. — Rahul Tapali, Feb 01 '13 at 19:30
please see the edit what happen when i follow ur instruction — mathlearner, Feb 01 '13 at 19:30
@checkit: it does not add ambiguity to parse. It's plainly invalid JSON. Valid JSON object can't be a standalone string. It must be an array or hash/dictionary/object. — Sergio Tulentsev, Feb 01 '13 at 19:34
Why are you inspecting? Why not just: `cp = pokes.filter(:id =>1).first.inspect jj = cp.to_json puts jj parseObject = JSON.parse(cp)` — BlackHatSamurai, Feb 01 '13 at 19:35
@checkit its working giving no error how to convert parseObject into hash please reply to second part — mathlearner, Feb 01 '13 at 19:35
@RiteshMehandiratta: " this is a valid json string" - this is certainly **not** a valid json string. — Sergio Tulentsev, Feb 01 '13 at 19:38
@RiteshMehandiratta its already hash. you mean activerecord hash?? — Rahul Tapali, Feb 01 '13 at 19:41
@checkit no apology for that i got it thanks thanks thanks for quick reply :D — mathlearner, Feb 01 '13 at 19:43

score 0 · Answer 1 · answered Feb 01 '13 at 19:22

0

i think you want to parse jj and not cp...

jj = cp.to_json
puts jj
parseObject = JSON.parse(jj)

answered Feb 01 '13 at 19:22

user934801

1,119
1
12
30

JSON:ParseError in ruby

1 Answers1