Search a column of a worksheet and return the match's full row. This is like a VLookup function in a spreadsheet.
Note: The table you're looking up against should be in the top left corner of your worksheet. And it should have headers.
Google Sheets
Copy this URL into Tableau's Web Data Connector input:
https://t.blockspring.com/pkpp1233/vlookup-google-sheets
Finish the setup steps to use Search Column in Tableau.
Finish the setup steps to use Search Column 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 "{ \"file_id\": , \"worksheet_id\": , \"lookup\": , \"search_type\": , \"vlookup_column\": , \"google_token\": }" "https://run.blockspring.com/api_v2/blocks/vlookup-google-sheets?"
var blockspring = require("blockspring");
blockspring.runParsed("vlookup-google-sheets", { "file_id": , "worksheet_id": , "lookup": , "search_type": , "vlookup_column": , google_token: }, function(res) {
console.log(res.params);
});
var request = require("request");
request.post({
url: "https://run.blockspring.com/api_v2/blocks/vlookup-google-sheets?",
form: { "file_id": , "worksheet_id": , "lookup": , "search_type": , "vlookup_column": , google_token: }
},
function(err, response, body) {
console.log(JSON.parse(body));
});
<?php
$url = 'https://run.blockspring.com/api_v2/blocks/vlookup-google-sheets?';
$data = json_encode(array("file_id" => , "worksheet_id" => , "lookup" => , "search_type" => , "vlookup_column" => , "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("vlookup-google-sheets", array("file_id" => , "worksheet_id" => , "lookup" => , "search_type" => , "vlookup_column" => , "google_token" => ))->params);
import json
import urllib2
req = urllib2.Request("https://run.blockspring.com/api_v2/blocks/vlookup-google-sheets?")
req.add_header('Content-Type', 'application/json')
data = { "file_id": , "worksheet_id": , "lookup": , "search_type": , "vlookup_column": , "google_token": }
results = urllib2.urlopen(req, json.dumps(data)).read()
print json.loads(results)
import blockspring
import json
print blockspring.runParsed("vlookup-google-sheets", { "file_id": , "worksheet_id": , "lookup": , "search_type": , "vlookup_column": , "google_token": }).params
require 'rest_client'
response = RestClient.post 'https://run.blockspring.com/api_v2/blocks/vlookup-google-sheets?', JSON.dump({ "file_id" => , "worksheet_id" => , "lookup" => , "search_type" => , "vlookup_column" => , "google_token" => }), :content_type => :json
puts JSON.load(response)
require 'blockspring'
puts Blockspring.runParsed("vlookup-google-sheets", { "file_id" => , "worksheet_id" => , "lookup" => , "search_type" => , "vlookup_column" => , "google_token" => } ).params
require 'rest_client'
response = RestClient.post 'https://run.blockspring.com/api_v2/blocks/vlookup-google-sheets?', JSON.dump({ "file_id" = , "worksheet_id" = , "lookup" = , "search_type" = , "vlookup_column" = , "google_token" = }), :content_type => :json
puts JSON.load(response)
library('blockspring')
library('rjson')
print(blockspringRunParsed("vlookup-google-sheets", list( "file_id" = , "worksheet_id" = , "lookup" = , "search_type" = , "vlookup_column" = , "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("vlookup-google-sheets", { "file_id": , "worksheet_id": , "lookup": , "search_type": , "vlookup_column": , google_token: }, { "api_key": "" }, function(res){
console.log(res.params);
})
</script>
https://run.blockspring.com/api_v2/blocks/vlookup-google-sheets?
Finish the setup steps to use Search Column in Code.