Fuzzy Match Within Table

Data Utilities by pkpp1233

Given some text, look up the closest match row within a table. This uses a fuzzy matching algorithm.

You can search through an arbitrary number of rows and columns and find the row in which the match exists.

Connect an Account

Setup Your Connector

Choose your Format

More Options

Access Data Utilities - Fuzzy Match Within Table from your tools

or Log in

Step 1: Choose your tool

Step 2: Install Blockspring

Curl Node PHP Python Ruby R jQuery Webhook

curl -H "Content-Type: application/json" -d "{ \"lookup\": , \"table\":  }" "https://run.blockspring.com/api_v2/blocks/fuzzy-match-within-table?"

Run this function with a POST request to Blockspring.

var blockspring = require("blockspring");

blockspring.runParsed("fuzzy-match-within-table", { "lookup": , "table":  }, function(res) {
  console.log(res.params);
});

var request = require("request");

request.post({
  url: "https://run.blockspring.com/api_v2/blocks/fuzzy-match-within-table?",
  form: { "lookup": , "table": }
},
function(err, response, body) {
  console.log(JSON.parse(body));
});

Visit the node.js quickstart to get started fast.

<?php
$url = 'https://run.blockspring.com/api_v2/blocks/fuzzy-match-within-table?';
$data = json_encode(array("lookup" => , "table" => ));

// 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("fuzzy-match-within-table", array("lookup" => , "table" => ))->params);

Visit the php quickstart to get started fast.

import json
import urllib2

req = urllib2.Request("https://run.blockspring.com/api_v2/blocks/fuzzy-match-within-table?")
req.add_header('Content-Type', 'application/json')

data = { "lookup": , "table": }

results = urllib2.urlopen(req, json.dumps(data)).read()

print json.loads(results)

import blockspring
import json

print blockspring.runParsed("fuzzy-match-within-table", { "lookup": , "table":  }).params

Visit the python quickstart to get started fast.

require 'rest_client'

response = RestClient.post 'https://run.blockspring.com/api_v2/blocks/fuzzy-match-within-table?', JSON.dump({ "lookup" => , "table" =>  }), :content_type => :json

puts JSON.load(response)

require 'blockspring'

puts Blockspring.runParsed("fuzzy-match-within-table", { "lookup" => , "table" =>  } ).params

Visit the ruby quickstart to get started fast.

require 'rest_client'

response = RestClient.post 'https://run.blockspring.com/api_v2/blocks/fuzzy-match-within-table?', JSON.dump({ "lookup" = , "table" =  }), :content_type => :json

puts JSON.load(response)

library('blockspring')
library('rjson')

print(blockspringRunParsed("fuzzy-match-within-table", list( "lookup" = , "table" =  ))$params)

Visit the r quickstart to get started fast.

<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("fuzzy-match-within-table", { "lookup": , "table": }, { "api_key": "" }, function(res){
    console.log(res.params);
  })
</script>

Visit the javascript quickstart to get started fast.

https://run.blockspring.com/api_v2/blocks/fuzzy-match-within-table?

Use this URL for webhooks. You'll want to make a POST request.

Finish the setup steps to use Fuzzy Match Within Table in Code.