Given the folder's ID (Parent ID) and the filename, find or create a spreadsheet.
You can find a file's parent id by looking at the URL of a folder. For example a folder with url - https://drive.google.com/drive/u/0/folders/0Bw51mIM56AtyOWM3alczT2pETVk - has a parent ID of 0Bw51mIM56AtyOWM3alczT2pETVk.
Google Sheets
Finish the setup steps to use Find or Create Spreadsheet within Drive Folder in Slack.
Run this function with a POST request to Blockspring.
Visit the node.js quickstart to get started fast.
Visit the php quickstart to get started fast.
Visit the python quickstart to get started fast.
Visit the ruby quickstart to get started fast.
Visit the r quickstart to get started fast.
Visit the javascript quickstart to get started fast.
Use this URL for webhooks. You'll want to make a POST request.
curl -H "Content-Type: application/json" -d "{ \"filename\": , \"parent_id\": , \"google_token\": }" "https://run.blockspring.com/api_v2/blocks/find-or-create-google-spreadsheet?"
var blockspring = require("blockspring");
blockspring.runParsed("find-or-create-google-spreadsheet", { "filename": , "parent_id": , google_token: }, function(res) {
console.log(res.params);
});
var request = require("request");
request.post({
url: "https://run.blockspring.com/api_v2/blocks/find-or-create-google-spreadsheet?",
form: { "filename": , "parent_id": , google_token: }
},
function(err, response, body) {
console.log(JSON.parse(body));
});
<?php
$url = 'https://run.blockspring.com/api_v2/blocks/find-or-create-google-spreadsheet?';
$data = json_encode(array("filename" => , "parent_id" => , "google_token" => ));
// use key 'http' even if you send the request to https://...
$options = array(
'http' => array(
'header' => array("Accept: application/json", "Content-Type: application/json"),
'method' => 'POST',
'content' => $data,
),
);
$context = stream_context_create($options);
$result = file_get_contents($url, false, $context);
var_dump(json_decode($result));
?>
<?php
require('blockspring.php');
var_dump(Blockspring::runParsed("find-or-create-google-spreadsheet", array("filename" => , "parent_id" => , "google_token" => ))->params);
import json
import urllib2
req = urllib2.Request("https://run.blockspring.com/api_v2/blocks/find-or-create-google-spreadsheet?")
req.add_header('Content-Type', 'application/json')
data = { "filename": , "parent_id": , "google_token": }
results = urllib2.urlopen(req, json.dumps(data)).read()
print json.loads(results)
import blockspring
import json
print blockspring.runParsed("find-or-create-google-spreadsheet", { "filename": , "parent_id": , "google_token": }).params
require 'rest_client'
response = RestClient.post 'https://run.blockspring.com/api_v2/blocks/find-or-create-google-spreadsheet?', JSON.dump({ "filename" => , "parent_id" => , "google_token" => }), :content_type => :json
puts JSON.load(response)
require 'blockspring'
puts Blockspring.runParsed("find-or-create-google-spreadsheet", { "filename" => , "parent_id" => , "google_token" => } ).params
require 'rest_client'
response = RestClient.post 'https://run.blockspring.com/api_v2/blocks/find-or-create-google-spreadsheet?', JSON.dump({ "filename" = , "parent_id" = , "google_token" = }), :content_type => :json
puts JSON.load(response)
library('blockspring')
library('rjson')
print(blockspringRunParsed("find-or-create-google-spreadsheet", list( "filename" = , "parent_id" = , "google_token" = ))$params)
<script src="https://code.jquery.com/jquery-1.10.1.min.js"></script>
<script src="https://cdn.blockspring.com/blockspring.js"></script>
<script>
blockspring.runParsed("find-or-create-google-spreadsheet", { "filename": , "parent_id": , google_token: }, { "api_key": "" }, function(res){
console.log(res.params);
})
</script>
https://run.blockspring.com/api_v2/blocks/find-or-create-google-spreadsheet?
Finish the setup steps to use Find or Create Spreadsheet within Drive Folder in Code.