How to access JSON object value

Question

i have this print STDERR Dumper $data:
$VAR1 = '{ "url_date":null, "footer":null,"id":"18", "authors":[ {"initials":"B.","last_name":"Best","has":0,"id":12}, {"initials":"D.","last_name":"Dough","has":1,"id":10}, {"initials":"F.","last_name":"Fuss","has":0,"id":15,} ], "url_headline":null, "headline":"test"}';
i would like to to access Dough how would i do that?
i tried print STDERR Dumper $data.authors[1].last_name but got syntax error.

2nd try
use JSON::XS qw( decode_json ); my $coder = JSON::XS->new->utf8->pretty->allow_nonref; my $p = $coder->decode ($.data);

ikegami · Accepted Answer · 2012-06-01 16:27:51Z

4

You have a string. What the string contains is valid JSON and valid YAML. You need to parse the JSON, and the best way to do that is with an existing parser like JSON::XS.

use JSON::XS qw( decode_json );
my $data = decode_json($data_json);
$data->{authors}[1]{last_name}

edited Jun 1, 2012 at 16:27

answered Jun 1, 2012 at 16:16

ikegami

391k17 gold badges291 silver badges555 bronze badges

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

4 Comments

mamesaye Over a year ago

i have a syntax error... i updated the code see 2nd try. print STDERR Dumper %{$p}; gave me the whole $data info but when i do print STDERR Dumper %{$p}->authors[1]{last_name}; i have a syntax error too..

ikegami Over a year ago

That's cause you didn't use what I posted.

mamesaye Over a year ago

i did tried what you posted and got syntax error at line 78, near "->authors[" then i when to the JSON::XS page and found the 2nd try and have a syntax error too.. what is the problem?

jmcneirney Over a year ago

$p->{authors}[1]{last_name} not %{$p}->authors[1]{last_name}. Looks like you're trying to call a method on a what ends up being a string. %{$p} with stringify the hashref and then you're trying to call a method on that. You just need to dereference that hashref like $p->{account}.

Oleg V. Volkov · Accepted Answer · 2012-06-01 16:11:31Z

2

The best way is to decode string to Perl hash reference first with JSON module and then use regular Perl's hash access syntax $data->{"authors"}[1]{"last_name"}.

answered Jun 1, 2012 at 16:11

Oleg V. Volkov

22.6k4 gold badges49 silver badges68 bronze badges

Collectives™ on Stack Overflow

How to access JSON object value

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related