// Include Composer autoload include __DIR__ . "/../../../../vendor/autoload.php"; $nodeId = 'XXXXX'; // Entrez le nom de votre noeud créé par OpenWide // Create the client $client = new \Sitra\ApiClient\Client(['projectId' => 00, 'baseUrl' => 'http://api.sitra-tourisme.com/', 'OAuthClientId' => 'XXXXXXXXXXXXXXXXXXXXXXX', 'OAuthSecret' => 'XXXXXXXXXXXXXXXXXXXXXXX']); /* Le fichier CSV validé doit être de la forme : ID_TRIP; NOM_TRIP; ID_SITRA; NOM_SITRA Si ce n'est pas le cas, BIEN REOORDONNER LES COLONNES dans cet ordre*/ if (($handle = fopen("/chemin/absolu/vers/le/fichier/valide/par/l/OT.csv", "r")) !== FALSE) { $i = 0; while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { if ($i > 0) { // S'il y a l'entête de colonne en première ligne, on ne la prend pas en compte $idTrip = intval($data[0]); $nameTrip = $data[1]; $idSitra = intval($data[2]); $nameSitra = $data[3]; try { $metadata = $client->putMetadata(['referenceId' => $idSitra, 'nodeId' => $nodeId, 'metadata' => ['general' => '{"locationId":"' . $idTrip . '","version":1}']]); } catch (\Sitra\ApiClient\Exception\SitraException $e) { echo $e->getMessage(); echo "\n"; echo $e->getPrevious()->getMessage(); } } $i++; } fclose($handle); } exit;
<?php // Include Composer autoload include __DIR__ . "/../vendor/autoload.php"; // Create the client $client = new \Sitra\ApiClient\Client(['apiKey' => 'XXX', 'projectId' => 00, 'baseUrl' => 'http://api.sitra-tourisme.com/', 'OAuthClientId' => 'XXX', 'OAuthSecret' => 'XXX']); try { $metadata = $client->getMetadata(['referenceId' => 123457, 'nodeId' => 'jolicode']); var_dump($metadata['identifiant']); $metadata = $client->putMetadata(['referenceId' => 123457, 'nodeId' => 'jolicode', 'metadata' => ['general' => '{"infoGenerale":"Mise à jour le ' . date('Y-m-d H:i:s') . '"}']]); $metadata = $client->getMetadata(['referenceId' => 123457, 'nodeId' => 'jolicode']); var_dump($metadata['identifiant']); $metadata = $client->putMetadata(['referenceId' => 123457, 'nodeId' => 'jolicode', 'metadata' => ['membres.membre_21' => '{"projet test":"Mise à jour le ' . date('Y-m-d H:i:s') . '"}']]); $metadata = $client->getMetadata(['referenceId' => 123457, 'nodeId' => 'jolicode', 'targetType' => 'membre', 'targetId' => 21]); var_dump($metadata['identifiant']); $metadata = $client->deleteMetadata(['referenceId' => 123457, 'nodeId' => 'jolicode', 'targetType' => 'membre', 'targetId' => 21]); var_dump($metadata); $metadata = $client->getMetadata(['referenceId' => 123457, 'nodeId' => 'jolicode', 'targetType' => 'membre', 'targetId' => 21]); var_dump($metadata); $metadata = $client->putMetadata(['referenceId' => 123457, 'nodeId' => 'jolicode', 'metadata' => ['node' => json_encode(['general' => json_encode(['toto' => true, 'foo' => 'bar']), 'membres' => [['targetId' => 111, 'jsonData' => json_encode(['foo' => 'barbar'])]]])]]); $metadata = $client->putMetadata(['referenceId' => 123457, 'nodeId' => 'jolicode', 'metadata' => ['membres' => '[{"targetId": 21, "jsonData": "{ \\"foo\\": \\"bar\\", \\"bar\\": 691 }" }, { "targetId": 12, "jsonData": "{ \\"bar\\": \\"foo\\" }" } ]']]); $metadata = $client->getMetadata(['referenceId' => 123457, 'nodeId' => 'jolicode', 'targetType' => 'membre']); var_dump($metadata); } catch (\Sitra\ApiClient\Exception\SitraException $e) { echo $e->getMessage(); echo "\n"; echo $e->getPrevious()->getMessage(); }