Here is the data structure . I would like to print the values for 'name' and 'values'.

"$VAR1 = [
          {
            'namespace' => 'urn:oasis:names:tc:SAML:2.0:attrname-forma
+t:unspecified',
            'name' => 'First Name',
            'values' => [
                          'user.firstName'
                        ],
            'type' => 'EXPRESSION'
          },
          {
            'namespace' => 'urn:oasis:names:tc:SAML:2.0:attrname-forma
+t:unspecified',
            'name' => 'Last Name',
            'values' => [
                          'user.lastName'
                        ],
            'type' => 'EXPRESSION'
          }
        ];
[download]

Here is the SSCCE for that:

#!/usr/bin/env perl
use strict;
use warnings;

my $VAR1 = [
          {
            'namespace' => 'urn:oasis:names:tc:SAML:2.0:attrname-forma
+t:unspecified',
            'name' => 'First Name',
            'values' => [
                          'user.firstName'
                        ],
            'type' => 'EXPRESSION'
          },
          {
            'namespace' => 'urn:oasis:names:tc:SAML:2.0:attrname-forma
+t:unspecified',
            'name' => 'Last Name',
            'values' => [
                          'user.lastName'
                        ],
            'type' => 'EXPRESSION'
          }
        ];

for my $x (@$VAR1) {
    print "Name = $x->{name}, Values = $x->{values}[0]\n";
}
[download]

See perldsc for more on using data structures like this.

---

🦛

Do you understand the change you have made to $VAR1? You have replaced the string 'user.firstName' with a reference to an array containing only one element (the original string). The error message you reported in your chatterbox message is exactlly what you should expect if you made only this change to my script. Note that my for $var loop no longer makes much sense because all the values no longer have the same structure. Use hippo's method to dereference just the two required values.

Now show us your best effort to put these two values into your spread sheet.

Bill