Google Spreadsheets API Removes Underscore

Question

I am using the Google Spreadsheets API with a list-based feed. When I get the tag values ​​- with getCustomElements (). GetTags () - I get them without underscore. For example: parent_id becomes parentid.

Does anyone know how to solve this?

Answer 1

I managed to get the "true" column names using the cell feed.

<?php // given $spreadsheetKey, $worksheetId, $spreadsheetService... $qry = new Zend_Gdata_Spreadsheets_CellQuery(); $qry->setSpreadsheetKey($spreadsheetKey); $qry->setWorksheetId($worksheetId); $qry->setMinCol(1); $qry->setMaxCol(null); $qry->setMinRow(1); $qry->setMaxRow(1); $cellFeed = $spreadsheetService->getCellFeed($qry); foreach ($cellFeed as $cellEntry) { $columnNumber = $cellEntry->cell->getColumn(); $columnLabel = $cellEntry->cell->getText(); echo "Column $columnNumber is labeled $columnLabel<br>\n"; } ?>