Aito and Parabola make your computer work for you

Use case: avoiding duplicates in CRM data

Prerequisites

  • You’ll need your own Parabola account. At time of writing you can sign up and get free credits here.
  • I’m using Google Sheets in my example, so you’ll want to have a Google account at your disposal. You can also use CSV’s or other datasources/destinations.

Creating my first workflow

  1. Read company search inputs (aka “human inputs”) from a Google Sheet.
  2. For each row of inputs, check with Aito if the CRM database already contains an entry that is a likely match.
  3. Write search parameters and found likely matches to a new Google Sheet.

#1 Read data from Google Sheet

#2 Get results from Aito API

  1. We are using Aito’s Similiarity function, so we need to set HTTP request type to be “POST”.
  2. Set the endpoint URL, which is in our public example this: https://public-1.api.aito.ai/api/v1/_similarity.
  3. To the “body” field we write the query that goes into Aito. Inside, we need to use {ColumnName} notation to pull the appropriate fields from our input data. The entire query looks like this:
{
"from": "company_info",
"similarity": {
"Name": "{Name}",
"City": "{City}"
},
"limit": 1
}
  1. Add a custom header for content-type with a value application/json.
  2. Add a custom header for authentication. In our case we use the read only key of our demo instance. Replace with your own, if you have one (and the data is there, too!). So x-api-key equals to bvss2i2dIkaWUfBCdzEO89LpxUkwO3A24hYg8MBq
  3. Finally in “Nested Keys” choose “hits” so that you get Aito’s results conveniently broken down as columns in your results.

#3 Write results to Google Sheets

Run it

Wrap up

--

--

--

20+ years of SW and tech leadership. Two startup exits. Building next-gen machine learning tools for no-coders and RPA devs at Aito.ai. Used to travel a lot

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Kubernetes Recipe aka Kuberator

Introduction to Python Programming

The Surprising Connection: New Year Resolutions and Cloud Software

DEFCON 201 Meet Up — March 2019 — Two F&#%ing Years

My First Step Towards Complete Automation!

[New Coin Listing] Binance USD (BUSD) to be Listed on DigiFinex!

OWASP TOP 10- DAY 1: Injection

Getting started in python

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Tommi Holmgren

Tommi Holmgren

20+ years of SW and tech leadership. Two startup exits. Building next-gen machine learning tools for no-coders and RPA devs at Aito.ai. Used to travel a lot

More from Medium

WHAT IS A BOT? The digital workforce that will be joining your team

5 Ways To Solve IoT Scalability Challenges

Medusa Commerce — First Thoughts

How Restaurants can use Cloud Messaging