{"id":28244,"date":"2021-06-05T14:02:00","date_gmt":"2021-06-05T11:02:00","guid":{"rendered":"https:\/\/themewp.inform.click\/?p=28244"},"modified":"2021-10-18T04:04:22","modified_gmt":"2021-10-18T01:04:22","slug":"grave-dados-na-planilha-do-onedrive-usando-microsoft-graph-api-e-php","status":"publish","type":"post","link":"https:\/\/themewp.inform.click\/pt-pt\/grave-dados-na-planilha-do-onedrive-usando-microsoft-graph-api-e-php\/","title":{"rendered":"Grave dados na planilha do OneDrive usando Microsoft Graph API e PHP"},"content":{"rendered":"

Recentemente, publiquei um artigo Como integrar API de planilhas do Google com PHP,<\/a> onde expliquei como escrever dados na planilha do Google usando PHP e APIs do Google. Um dos leitores perguntou de maneira semelhante como gravar dados na planilha do OneDrive. Neste tutorial, estudaremos como usar a API do Microsoft Graph e PHP para gravar os dados na planilha do OneDrive.<\/p>\n

A API do Microsoft Graph segue o fluxo OAuth para a autoriza\u00e7\u00e3o. Isso significa que precisamos gerar um token de acesso usando o processo OAuth. Para isso, primeiro voc\u00ea precisa registrar o aplicativo e pegar suas credenciais.<\/p>\n

Registrar um aplicativo e criar credenciais<\/h3>\n

Ao integrar um processo OAuth, voc\u00ea precisa ter um ID de cliente e um segredo do cliente. Voc\u00ea o receber\u00e1 ap\u00f3s registrar os aplicativos. Pode-se seguir as etapas mencionadas nesta p\u00e1gina<\/a> e registrar seu aplicativo com a Microsoft.<\/p>\n

Fa\u00e7a login no Portal<\/a> do Azure<\/a> e pesquise por Registro de Aplicativo. Preencha o formul\u00e1rio. Voc\u00ea precisa passar um URL para o campo URI de redirecionamento. Para este campo, estou passando um URL de servidor local. Vou criar um callback.php<\/code>nas pr\u00f3ximas etapas. Preenchi os detalhes conforme mostrado na imagem abaixo.<\/p>\n

\"Grave<\/a><\/p>\n

Ao enviar um formul\u00e1rio, voc\u00ea obter\u00e1 o ID do cliente na guia Vis\u00e3o geral.<\/p>\n

\"Grave<\/a><\/p>\n

Em seguida, v\u00e1 para a guia ‘Certificados e segredos’ e clique em ‘Novo segredo do cliente’.<\/p>\n

\"Grave<\/a><\/p>\n

Ele abrir\u00e1 um pop-up onde voc\u00ea precisa adicionar uma descri\u00e7\u00e3o e escolher a op\u00e7\u00e3o Expira.<\/p>\n

\"Grave<\/a><\/p>\n

Depois disso, voc\u00ea obter\u00e1 o segredo do seu cliente conforme mostrado abaixo.<\/p>\n

\"Grave<\/a><\/p>\n

Instale os pacotes necess\u00e1rios<\/h4>\n

Temos que integrar duas coisas – OAuth e REST API. Para o OAuth, vou usar a biblioteca Hybridauth<\/a>. E para interagir com a API do Microsoft Graph, vamos usar a biblioteca Guzzle<\/a>.<\/p>\n

Podemos facilmente instalar esses 2 pacotes usando um Composer. Crie um composer.json<\/code>arquivo no diret\u00f3rio raiz do seu projeto e adicione as linhas abaixo a ele.<\/p>\n

{\n\u00a0\u00a0\u00a0\u00a0\"require\": {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"hybridauth\/hybridauth\": \"~3.0\",\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"guzzlehttp\/guzzle\": \"^7.0\"\n\u00a0\u00a0\u00a0\u00a0}\n}<\/code><\/pre>\n
Execute o comando abaixo que instalar\u00e1 esses pacotes.<\/p>\n
composer install<\/code><\/pre>\n
Como dito, a API do Microsoft Graph usa OAuth para realizar as opera\u00e7\u00f5es da API. Exige que voc\u00ea gere um token de acesso que atua como um identificador de sua conta. Usando esse token de acesso, as APIs do Microsoft Graph validam se a solicita\u00e7\u00e3o de entrada \u00e9 v\u00e1lida e autorizada.<\/p>\n
O token de acesso tem vida curta. Eles expiram em breve. E uma vez expirado, n\u00e3o podemos fazer chamadas de API, pois a Microsoft trata a solicita\u00e7\u00e3o com o token expirado como uma solicita\u00e7\u00e3o n\u00e3o autorizada. Para resolver esse problema, usamos o ‘refresh_token’ para gerar novamente o token de acesso em segundo plano. \u00c9 assim que o OAuth funciona.<\/p>\n
Configura\u00e7\u00e3o de banco de dados<\/h3>\n
Para atingir nosso objetivo, precisamos armazenar o token em um local seguro. Precisamos do token ao chamar as APIs. Al\u00e9m disso, ele deve se regenerar ap\u00f3s expirar. Portanto, para armazenar os detalhes do token, crie uma tabela de banco de dados da seguinte maneira.<\/p>\n
CREATE TABLE `token` (\u00a0`id` int(11) NOT NULL AUTO_INCREMENT,\n\u00a0`access_token` text NOT NULL,\n\u00a0PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;<\/code><\/pre>\n
Vamos inserir o token no banco de dados ap\u00f3s concluir o processo de autoriza\u00e7\u00e3o. Al\u00e9m disso, atualizaremos o token em segundo plano. Para isso, vou criar uma classe de banco de dados para que possamos fazer facilmente as opera\u00e7\u00f5es de inser\u00e7\u00e3o, sele\u00e7\u00e3o e atualiza\u00e7\u00e3o.<\/p>\n
class-db.php<\/strong><\/p>\n
<?php\nclass DB {\n\u00a0\u00a0\u00a0\u00a0private $dbHost\u00a0\u00a0\u00a0\u00a0 = \"DB_HOST\";\n\u00a0\u00a0\u00a0\u00a0private $dbUsername = \"DB_USERNAME\";\n\u00a0\u00a0\u00a0\u00a0private $dbPassword = \"DB_PASSWORD\";\n\u00a0\u00a0\u00a0\u00a0private $dbName\u00a0\u00a0\u00a0\u00a0 = \"DB_NAME\";\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0public function __construct(){\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0if(!isset($this->db)){\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/ Connect to the database\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$conn = new mysqli($this->dbHost, $this->dbUsername, $this->dbPassword, $this->dbName);\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0if($conn->connect_error){\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0die(\"Failed to connect with MySQL: \". $conn->connect_error);\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}else{\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$this->db = $conn;\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\n\u00a0\u00a0\u00a0\u00a0}\n\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0public function is_table_empty() {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$result = $this->db->query(\"SELECT id FROM token\");\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0if($result->num_rows) {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return false;\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\n\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return true;\n\u00a0\u00a0\u00a0\u00a0}\n\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0public function get_access_token() {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$sql = $this->db->query(\"SELECT access_token FROM token\");\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$result = $sql->fetch_assoc();\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return json_decode($result['access_token']);\n\u00a0\u00a0\u00a0\u00a0}\n\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0public function get_refersh_token() {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$result = $this->get_access_token();\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return $result->refresh_token;\n\u00a0\u00a0\u00a0\u00a0}\n\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0public function update_access_token($token) {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0if($this->is_table_empty()) {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$this->db->query(\"INSERT INTO token(access_token) VALUES('$token')\");\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0} else {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$this->db->query(\"UPDATE token SET access_token = '$token' WHERE id = (SELECT id FROM token)\");\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\n\u00a0\u00a0\u00a0\u00a0}\n}<\/code><\/pre>\n
Gerar token de acesso<\/h3>\n
Quando estiver pronto com os pacotes necess\u00e1rios e a classe de banco de dados, a pr\u00f3xima parte \u00e9 fazer a autentica\u00e7\u00e3o e armazenar os detalhes do token no banco de dados.<\/p>\n
A biblioteca Hybridauth fornece seu pr\u00f3prio processo para realizar a autoriza\u00e7\u00e3o. Ent\u00e3o, vamos segui-los. Crie um config.php<\/code>arquivo e adicione o c\u00f3digo abaixo nele.<\/p>\n
config.php<\/strong><\/p>\n
<?php\nrequire_once 'vendor\/autoload.php';\nrequire_once 'class-db.php';\n\u00a0\ndefine('ONEDRIVE_CLIENT_ID', 'CLIENT_ID_HERE');\ndefine('ONEDRIVE_CLIENT_SECRET', 'CLIENT_SECRET_HERE');\ndefine('ONEDRIVE_SCOPE', 'files.read files.read.all files.readwrite files.readwrite.all offline_access');\ndefine('ONEDRIVE_CALLBACK_URL', 'CALLBACK_URL_HERE'); \/\/ in my case it is http:\/\/localhost\/sajid\/onedrive\/callback.php\n\u00a0\n$config = [\n\u00a0\u00a0\u00a0\u00a0'callback' => ONEDRIVE_CALLBACK_URL,\n\u00a0\u00a0\u00a0\u00a0'keys'\u00a0\u00a0\u00a0\u00a0 => [\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0'id' => ONEDRIVE_CLIENT_ID,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0'secret' => ONEDRIVE_CLIENT_SECRET\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0],\n\u00a0\u00a0\u00a0\u00a0'scope'\u00a0\u00a0\u00a0 => ONEDRIVE_SCOPE,\n\u00a0\u00a0\u00a0\u00a0'authorize_url_parameters' => [\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0'approval_prompt' => 'force',\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0'access_type' => 'offline'\n\u00a0\u00a0\u00a0\u00a0]\n];\n\u00a0\n$adapter = new HybridauthProviderMicrosoftGraph( $config );<\/code><\/pre>\n
Certifique-se de substituir todos os marcadores de posi\u00e7\u00e3o por seus valores reais. Passei nos escopos necess\u00e1rios para nosso objetivo final, portanto, mantenha-o como est\u00e1. Agora, em callback.php<\/code>que \u00e9 minha URL de retorno de chamada, escreverei um c\u00f3digo que inicia o processo de autentica\u00e7\u00e3o, redireciona para ele ap\u00f3s a autoriza\u00e7\u00e3o bem-sucedida e armazena as informa\u00e7\u00f5es dos tokens na tabela do banco de dados.<\/p>\n
callback.php<\/strong><\/p>\n
<?php\nrequire_once 'config.php';\n\u00a0\ntry {\n\u00a0\u00a0\u00a0\u00a0$adapter->authenticate();\n\u00a0\u00a0\u00a0\u00a0$token = $adapter->getAccessToken();\n\u00a0\u00a0\u00a0\u00a0$db = new DB();\n\u00a0\u00a0\u00a0\u00a0if($db->is_table_empty()) {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$db->update_access_token(json_encode($token));\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0echo \"Access token inserted successfully.\";\n\u00a0\u00a0\u00a0\u00a0}\n}\ncatch( Exception $e ){\n\u00a0\u00a0\u00a0\u00a0echo $e->getMessage() ;\n}<\/code><\/pre>\n
Execute callback.php<\/code>no navegador e conclua o processo de autentica\u00e7\u00e3o. Ap\u00f3s a conclus\u00e3o da autentica\u00e7\u00e3o, voc\u00ea deve ver os detalhes do token armazenados na tabela de ‘tokens’.<\/p>\n
Adicionar tabela na planilha do OneDrive<\/h3>\n
Para adicionar os dados por meio da API do Microsoft Graph, voc\u00ea precisa inserir uma tabela na planilha do OneDrive. V\u00e1 para a p\u00e1gina do OneDrive. Clique na ‘pasta de trabalho do Excel’ no menu suspenso ‘Novo’.<\/p>\n
\"Grave<\/a><\/p>\n
Quando estiver na p\u00e1gina da planilha, clique no \u00edcone ‘Tabela’ e depois em ‘OK’ no pop-up aberto.<\/p>\n
\"Grave<\/a><\/p>\n
Depois disso, voc\u00ea ver\u00e1 a Tabela inserida na planilha do OneDrive da seguinte forma.<\/p>\n
\"Grave<\/a><\/p>\n
Ajuste as colunas de acordo com suas necessidades. No meu caso, mantive 3 colunas.<\/p>\n
Agora, pode-se perguntar por que a necessidade de inserir uma tabela na planilha? Quando estava pesquisando este t\u00f3pico, descobri que esta \u00e9 a \u00fanica maneira de gravar dados na pasta de trabalho do Excel. Voc\u00ea pode ler mais sobre isso em sua documenta\u00e7\u00e3o<\/a>.<\/p>\n
Observe que quando inserirmos a tabela pela primeira vez na planilha, seu valor ser\u00e1 ‘Tabela1’. Precisamos desse valor no momento de chamar APIs. Se, por algum motivo, voc\u00ea remover a tabela e inseri-la novamente, seu valor se tornar\u00e1 ‘Tabela2’ e assim por diante.<\/p>\n
Copie o ID da sua planilha, que \u00e9 necess\u00e1rio em uma chamada de API. Voc\u00ea pode obt\u00ea-lo no URL do navegador, conforme mostrado na imagem abaixo.<\/p>\n
\"Grave<\/a><\/p>\n
Grave dados na planilha do OneDrive com Microsoft Graph API e PHP<\/h3>\n
At\u00e9 o momento, conclu\u00edmos a instala\u00e7\u00e3o dos pacotes necess\u00e1rios, a inser\u00e7\u00e3o de tokens no banco de dados, a cria\u00e7\u00e3o de uma pasta de trabalho do Excel com uma tabela. Agora, estamos prontos para prosseguir e escrever um c\u00f3digo que anexa dados \u00e0 planilha do OneDrive usando a API do Microsoft Graph e PHP.<\/p>\n
Estou criando um arquivo append-to-onedrive-sheet.php<\/code>e meu c\u00f3digo ser\u00e1 como escrito abaixo.<\/p>\n
<?php\nrequire_once 'config.php';\n\u00a0\n\/\/ here you can pass as many data as a separate array element\n$arr_data = [\n\u00a0\u00a0\u00a0\u00a0['John Doe', 'john@test.com', '8888888888']\n];\n\u00a0\nappend_to_sheet($arr_data);\n\u00a0\nfunction append_to_sheet($arr_data = array()) {\n\u00a0\u00a0\u00a0\u00a0$item_id = 'YOUR_SHEET_ID';\n\u00a0\u00a0\u00a0\u00a0$table = 'Table1'; \/\/in your case it can be Table2, Table3, ...\n\u00a0\n\u00a0\u00a0\u00a0\u00a0$db = new DB();\n\u00a0\n\u00a0\u00a0\u00a0\u00a0$arr_token = (array) $db->get_access_token();\n\u00a0\u00a0\u00a0\u00a0$accessToken = $arr_token['access_token'];\n\u00a0\n\u00a0\u00a0\u00a0\u00a0try {\n\u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$client = new GuzzleHttpClient([\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/ Base URI is used with relative requests\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0'base_uri' => 'https:\/\/graph.microsoft.com',\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0]);\n\u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$response = $client->request(\"POST\", \"\/v1.0\/me\/drive\/items\/$item_id\/workbook\/tables\/$table\/rows\/add\", [\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0'json' => [\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0'values' => $arr_data\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0],\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0'headers' => [\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0'Authorization' => 'Bearer '. $accessToken\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0],\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0'verify' => false,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0]);\n\u00a0\u00a0\u00a0\u00a0} catch(Exception $e) {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0if( 401 == $e->getCode()) {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$refresh_token = $db->get_refersh_token();\n\u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$client = new GuzzleHttpClient(['base_uri' => 'https:\/\/login.microsoftonline.com']);\n\u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$response = $client->request('POST', '\/common\/oauth2\/v2.0\/token', [\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0'form_params' => [\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"grant_type\" => \"refresh_token\",\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"refresh_token\" => $refresh_token,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"client_id\" => ONEDRIVE_CLIENT_ID,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"client_secret\" => ONEDRIVE_CLIENT_SECRET,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"scope\" => ONEDRIVE_SCOPE,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"redirect_uri\" => ONEDRIVE_CALLBACK_URL,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0],\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0]);\n\u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$db->update_access_token($response->getBody());\n\u00a0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0append_to_sheet($arr_data);\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0} else {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0echo $e->getMessage(); \/\/print the error just in case your video is not uploaded.\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\n\u00a0\u00a0\u00a0\u00a0}\n}<\/code><\/pre>\n
No c\u00f3digo acima, criei uma matriz que possui o elemento da matriz com 3 valores. Voc\u00ea pode passar tantos elementos de array. Voc\u00ea tem que passar o id da sua planilha para a $item_id<\/code>vari\u00e1vel.<\/p>\n
Este c\u00f3digo busca um token de acesso do banco de dados e envia uma solicita\u00e7\u00e3o POST para o endpoint de API necess\u00e1rio. Se o token expirar, ele o regenerar\u00e1 automaticamente em segundo plano e continuar\u00e1 o processo.<\/p>\n
Experimente e voc\u00ea ver\u00e1 que seus dados est\u00e3o anexados \u00e0 pasta de trabalho do Excel de sua conta do OneDrive.<\/p>\n
Espero que voc\u00ea saiba como gravar dados na planilha do OneDrive usando a API do Microsoft Graph e PHP. Por favor, compartilhe seus pensamentos e sugest\u00f5es na se\u00e7\u00e3o de coment\u00e1rios abaixo.<\/p>\n
Artigos relacionados<\/h4>\n