Hi gang, I'm trying to automate some google analytics stuff here. For this request:

$req = $analytics->new_request( realtime => "true",
 ids => "ga:12345678",
 dimensions =>"rt:country,rt:city,rt:pagePath,
rt:latitude,
rt:longitude",
metrics =>"rt:activeUsers",
filters =>"rt:country==England",
);
[download]

I'm using a database query to determine what the request parameters should be for this query. The multi line result set looks like

 select * from query_builder where query_no = 14; Result set of the query looks like

Record 1 realtime => "true",
Record 2 ids => "ga:12345678",
Record 3 dimensions =>"rt:country,rt:city,rt:pagePath,rt:latitude,rt:l
+ongitude",
Record 4 metrics =>"rt:activeUsers",
Record 5 filters =>"rt:country==England",
[download]

Or to show it another way:

realtime => "true",
ids => "ga:12345678",
dimensions =>"rt:country,rt:city,rt:pagePath,rt:latitude,rt:longitude"
+,
metrics =>"rt:activeUsers",
filters =>"rt:country==England",
[download]

So. If I created a string along the lines of

$qry_str = 'realtime => "true",
 ids => "ga:12345678",
 dimensions =>"rt:country,rt:city,rt:pagePath,rt:latitude,rt:longitude
+",
 metrics =>"rt:activeUsers",
 filters =>"rt:country==England",';
[download]

(in reality it's

while ( @row = $sth->fetchrow_array() ) {
 $qry_str .= $row[0];
 }
[download]

)
How can I do a

$req = $analytics->new_request(
$qry_str
);
[download]

Any thoughts?