{"id":29143,"date":"2021-06-05T14:19:00","date_gmt":"2021-06-05T11:19:00","guid":{"rendered":"https:\/\/themewp.inform.click\/?p=29143"},"modified":"2021-10-17T04:25:19","modified_gmt":"2021-10-17T01:25:19","slug":"skriv-data-till-onedrive-ark-med-microsoft-graph-api-och-php","status":"publish","type":"post","link":"https:\/\/themewp.inform.click\/sv\/skriv-data-till-onedrive-ark-med-microsoft-graph-api-och-php\/","title":{"rendered":"Skriv data till OneDrive-ark med Microsoft Graph API och PHP"},"content":{"rendered":"

Nyligen har jag publicerat en artikel Hur man integrerar Google Sheets API med PHP<\/a> d\u00e4r jag f\u00f6rklarade hur man skriver data till Google Sheet med PHP och Google API. En av l\u00e4sarna fr\u00e5gade p\u00e5 liknande s\u00e4tt hur man skulle skriva data till OneDrive-arket. I den h\u00e4r handledningen studerar vi hur man anv\u00e4nder Microsoft Graph API och PHP f\u00f6r att skriva data i OneDrive-arket.<\/p>\n

Microsoft Graph API f\u00f6ljer OAuth-fl\u00f6det f\u00f6r auktoriseringen. Det betyder att vi m\u00e5ste skapa en \u00e5tkomsttoken med OAuth-processen. F\u00f6r detta m\u00e5ste du f\u00f6rst registrera applikationen och ta dina referenser.<\/p>\n

Registrera en ans\u00f6kan och skapa referenser<\/h3>\n

N\u00e4r du integrerar en OAuth-process m\u00e5ste du ha ett klient-id och en klienthemlighet. Du f\u00e5r det efter att du registrerat ans\u00f6kningarna. Man kan f\u00f6lja stegen som n\u00e4mns p\u00e5 den h\u00e4r sidan<\/a> och registrera deras applikation hos Microsoft.<\/p>\n

Logga in p\u00e5 Azure Portal<\/a> och s\u00f6k sedan efter appregistrering. Fyll i formul\u00e4ret. Du m\u00e5ste skicka en URL till URI-f\u00e4ltet Redirect. Till det h\u00e4r f\u00e4ltet skickar jag en lokal server-URL. Jag skapar en callback.php<\/code>i n\u00e4sta steg. Jag har fyllt i detaljerna som visas p\u00e5 sk\u00e4rmdumpen nedan.<\/p>\n

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

N\u00e4r du skickar ett formul\u00e4r f\u00e5r du klient-ID fr\u00e5n fliken \u00d6versikt.<\/p>\n

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

G\u00e5 sedan till fliken ’Certifikat och hemligheter’ och klicka p\u00e5 ’Ny klienthemlighet’.<\/p>\n

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

Det \u00f6ppnar en popup d\u00e4r du beh\u00f6ver l\u00e4gga till en beskrivning och v\u00e4lja alternativet Utg\u00e5r.<\/p>\n

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

Efter detta f\u00e5r du din klienthemlighet som visas nedan.<\/p>\n

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

Installera obligatoriska paket<\/h4>\n

Vi m\u00e5ste integrera tv\u00e5 saker – OAuth och REST API. F\u00f6r OAuth ska jag anv\u00e4nda Hybridauth-<\/a> biblioteket. Och f\u00f6r att interagera med Microsoft Graph API, l\u00e5t oss anv\u00e4nda Guzzle-<\/a> biblioteket.<\/p>\n

Vi kan enkelt installera dessa tv\u00e5 paket med en Composer. Skapa en composer.json<\/code>fil i din projektkatalog och l\u00e4gg till nedanst\u00e5ende rader i den.<\/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
K\u00f6r kommandot nedan som kommer att installera dessa paket.<\/p>\n
composer install<\/code><\/pre>\n
Som sagt anv\u00e4nder Microsoft Graph API OAuth f\u00f6r att utf\u00f6ra API-operationerna. Det kr\u00e4ver att du genererar en \u00e5tkomsttoken som fungerar som en identifierare f\u00f6r ditt konto. Med hj\u00e4lp av denna \u00e5tkomsttoken validerar Microsoft Graph API: er om den inkommande beg\u00e4ran \u00e4r giltig och auktoriserad.<\/p>\n
\u00c5tkomsttoken har kort livsl\u00e4ngd. De upph\u00f6r snart. Och n\u00e4r den har l\u00f6pt ut kan vi inte g\u00f6ra API-samtal eftersom Microsoft behandlar beg\u00e4ran med den utg\u00e5ngna token som en obeh\u00f6rig beg\u00e4ran. F\u00f6r att l\u00f6sa problemet anv\u00e4nder vi ’refresh_token’ f\u00f6r att \u00e5terskapa \u00e5tkomsttoken i bakgrunden. S\u00e5 h\u00e4r fungerar OAuth.<\/p>\n
Databaskonfiguration<\/h3>\n
F\u00f6r att uppn\u00e5 v\u00e5rt m\u00e5l m\u00e5ste vi lagra symbolen p\u00e5 en s\u00e4ker plats. Vi beh\u00f6ver token n\u00e4r vi ringer till API: er. Det b\u00f6r ocks\u00e5 regenereras n\u00e4r det har l\u00f6pt ut. S\u00e5 f\u00f6r att lagra tokeninformation skapar du en databastabell enligt f\u00f6ljande.<\/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
Vi s\u00e4tter in token i databasen efter att auktoriseringsprocessen har slutf\u00f6rts. Vi kommer ocks\u00e5 att uppdatera token i bakgrunden. F\u00f6r detta ska jag skapa en databasklass s\u00e5 att vi enkelt kan g\u00f6ra ins\u00e4ttnings-, markerings- och uppdaterings\u00e5tg\u00e4rder.<\/p>\n
klass-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
Skapa \u00e5tkomsttoken<\/h3>\n
N\u00e4r du \u00e4r redo med de obligatoriska paketen och databasklassen g\u00f6r n\u00e4sta del autentisering och lagring av tokeninformation i databasen.<\/p>\n
Hybridauth-biblioteket tillhandah\u00e5ller sin egen process f\u00f6r att utf\u00f6ra auktorisering. S\u00e5, l\u00e5t oss f\u00f6lja dem. Skapa en config.php<\/code>fil och l\u00e4gg till koden nedan i den.<\/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
Se till att ers\u00e4tta alla platsh\u00e5llare med deras faktiska v\u00e4rden. Jag har klarat de n\u00f6dv\u00e4ndiga r\u00e4ckvidden f\u00f6r v\u00e5rt slutm\u00e5l s\u00e5 h\u00e5ll det som det \u00e4r. Nu, i callback.php<\/code>vilken \u00e4r min \u00e5teruppringnings-URL, skriver jag en kod som startar autentiseringsprocessen, omdirigerar till den efter lyckad auktorisering och lagrar tokensinformationen i databastabellen.<\/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
K\u00f6r i callback.php<\/code>webbl\u00e4saren, slutf\u00f6r autentiseringsprocessen. N\u00e4r autentiseringen \u00e4r klar b\u00f6r du se tokeninformation lagrad i tabellen ’tokens’.<\/p>\n
L\u00e4gg till tabell i OneDrive-ark<\/h3>\n
F\u00f6r att l\u00e4gga till data via Microsoft Graph API m\u00e5ste du infoga en tabell i OneDrive-arket. G\u00e5 \u00f6ver till OneDrive-sidan. Klicka p\u00e5 "Excel-arbetsbok" under rullgardinsmenyn "Ny".<\/p>\n
\"Skriv<\/a><\/p>\n
N\u00e4r du v\u00e4l \u00e4r p\u00e5 arksidan klickar du p\u00e5 "Tabell" -ikonen och sedan "OK" fr\u00e5n det \u00f6ppnade popup-f\u00f6nstret.<\/p>\n
\"Skriv<\/a><\/p>\n
Efter detta ser du tabellen infogad i ditt OneDrive-ark enligt f\u00f6ljande.<\/p>\n
\"Skriv<\/a><\/p>\n
Justera kolumnerna enligt dina behov. I mitt fall beh\u00f6ll jag tre kolumner.<\/p>\n
Nu kan man fr\u00e5ga varf\u00f6r behovet av att infoga en tabell i arket? N\u00e4r jag unders\u00f6kte detta \u00e4mne fann jag att det h\u00e4r \u00e4r det enda s\u00e4ttet att skriva data till Excel-arbetsboken. Du kan l\u00e4sa mer om detta i deras dokumentation<\/a>.<\/p>\n
Notera n\u00e4r vi s\u00e4tter in tabellen f\u00f6rsta g\u00e5ngen i arket, dess v\u00e4rde \u00e4r ’Tabell1’. Vi beh\u00f6ver det h\u00e4r v\u00e4rdet n\u00e4r vi ringer API: er. Om du av n\u00e5gon anledning tar bort tabellen och s\u00e4tter in den igen blir dess v\u00e4rde ’Table2’ och s\u00e5 vidare.<\/p>\n
Kopiera ditt ark-ID som kr\u00e4vs i ett API-samtal. Du kan h\u00e4mta det fr\u00e5n webbl\u00e4sarens URL som visas p\u00e5 sk\u00e4rmdumpen nedan.<\/p>\n
\"Skriv<\/a><\/p>\n
Skriv data till OneDrive-ark med Microsoft Graph API och PHP<\/h3>\n
Hittills \u00e4r vi klara med att installera de n\u00f6dv\u00e4ndiga paketen, infoga tokens i databasen, skapa en Excel-arbetsbok med en tabell i den. Nu \u00e4r det bra att g\u00e5 vidare och skriva en kod som bifogar data till OneDrive-arket med hj\u00e4lp av Microsoft Graph API och PHP.<\/p>\n
Jag skapar en fil append-to-onedrive-sheet.php<\/code>och min kod kommer att vara som skrivet nedan.<\/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
I ovanst\u00e5ende kod skapade jag en array som har arrayelementet med 3 v\u00e4rden. Du kan skicka s\u00e5 m\u00e5nga matriselement. Du m\u00e5ste skicka ditt ark-id till $item_id<\/code>variabeln.<\/p>\n
Den h\u00e4r koden h\u00e4mtar en \u00e5tkomsttoken fr\u00e5n databasen och skickar en POST-beg\u00e4ran till det n\u00f6dv\u00e4ndiga API-slutpunkten. Om token upph\u00f6r, regenererar den automatiskt i bakgrunden och forts\u00e4tter processen.<\/p>\n
Prova det och du b\u00f6r se att dina data l\u00e4ggs till i Excel-arbetsboken f\u00f6r ditt OneDrive-konto.<\/p>\n
Jag hoppas att du fick l\u00e4ra dig att skriva data till OneDrive-arket med Microsoft Graph API och PHP. Dela dina tankar och f\u00f6rslag i kommentarsektionen nedan.<\/p>\n
relaterade artiklar<\/h4>\n