使用PHP从Google表格JSON数据中回显特定值

Question

I'm trying to figure out "how-to" echo out the "[e-mail]" (red arrow pointing to it) value from this JSON file. I can echo $data[feed][entry][1][id], but I run into trouble when I get to gsx$emailaddress. I assume it is because of the $ in the label. I do not have control over the label name (created by Google Sheets).

Any help is greatly appreciated.

My Code

$urlSheet = 'https://spreadsheets.google.com/feeds/list/1s7UCtbRY2dU3YdDu_kjnr-_y5Lh49yMHQRzgiDt8D4c/2/public/values?alt=json';
$jsonSheet = file_get_contents($urlSheet);
$data = json_decode($jsonSheet, true);

Thank you!

Todd

Answer 1

If you use single quotes, the $ won't trigger PHP variable interpolation.

echo $data['feed']['entry'][1]['gsx$emailaddress']['$t'];