Interzoid

https://docs.interzoid.com
Admin
Interzoid provides AI-powered data quality, data matching, and data enrichment APIs and tools to...
Tokens:21,079
Snippets:436
Trust Score:7.6
Update:1 month ago
Show doc for...
Tokens:
Raw
### Business Info Enrichment Output Example

Source: https://docs.interzoid.com/entries/data-enrichment-wizard

Shows the structure of data after running the Get Business Info enrichment, where nine new columns are appended to the original three.

```text
Cisco,John Smith,jsmith@cisco.com,Cisco Systems Inc.,cisco.com,"170 W Tasman Dr, San Jose, CA","$56.7 billion",90400,511210,Chuck Robbins,"Chairman and CEO"
Salesforce,Jane Doe,jdoe@sfdc.com,Salesforce Inc.,salesforce.com,"415 Mission St, San Francisco, CA","$34.9 billion",79000,511210,Marc Benioff,"Chair and CEO"
```

--------------------------------

### Example API Call

Source: https://docs.interzoid.com/entries/data-matching-wizard

A cURL command demonstrating how to trigger a matching job via the Interzoid REST API.

```bash
$ curl "https://match.interzoid.com/match?connection=https://your-file-url/data.csv&filetype=csv&function=company-name-only&apikey=YOUR_API_KEY&company_column=3&showkeys=true&matchesonly=true"
```

--------------------------------

### Read-Only MySQL Connection String

Source: https://docs.interzoid.com/entries/mysql

Example of a connection string using a dedicated read-only user account for improved security.

```text
interzoid_app_ro:StrongPassword123@tcp(mysql-host.mycompany.com)/interzoid_db
```

--------------------------------

### Example Match Report Output

Source: https://docs.interzoid.com/entries/data-matching-wizard

Sample CSV output showing records grouped into clusters with similarity keys in the final column.

```text
IBM Corporation,1 New Orchard Rd,Armonk,NY,d477E1d7sG6dja3hDNsk9P
I.B.M. Corp,1 New Orchard Road,Armonk,NY,d477E1d7sG6dja3hDNsk9P

Microsoft Inc.,1 Microsoft Way,Redmond,WA,k8Rp2mNx4wQjL9vB3cYh7T
Microsoft Corporation,One Microsoft Way,Redmond,WA,k8Rp2mNx4wQjL9vB3cYh7T
MSFT Corp,1 Microsoft Way,Redmond,WA,k8Rp2mNx4wQjL9vB3cYh7T
```

--------------------------------

### GET /discover

Source: https://docs.interzoid.com/entries/snowflake-data-matching

Retrieves a list of Snowflake resources based on the specified resource type and connection parameters.

```APIDOC
## GET /discover

### Description
Retrieves a list of available Snowflake resources such as warehouses, databases, schemas, tables, or columns.

### Method
GET

### Endpoint
https://match.interzoid.com/discover

### Parameters
#### Query Parameters
- **db_host** (string) - Required - The Snowflake host address.
- **db_user** (string) - Required - The Snowflake username.
- **db_password** (string) - Required - The Snowflake password.
- **resource** (string) - Required - The type of resource to list (warehouses, databases, schemas, tables, or columns).
- **db_warehouse** (string) - Optional - The warehouse name (required for databases/schemas).
- **db_database** (string) - Optional - The database name (required for schemas/tables).
- **db_schema** (string) - Optional - The schema name (required for tables/columns).
- **table** (string) - Optional - The table name (required for columns).

### Response
#### Success Response (200)
- **resource** (string) - The type of resource returned.
- **items** (array) - A list of available resource names.

#### Response Example
{
  "resource": "warehouses",
  "items": ["COMPUTE_WH", "ANALYTICS_WH"]
}
```

--------------------------------

### Example Merged Output Format

Source: https://docs.interzoid.com/entries/merge-wizard-guide

Displays the structure of a merged CSV file containing columns from both the primary and secondary datasets.

```csv
Company,City,Company,Revenue
Acme Manufacturing,Chicago,ACME MFG CORP,584000
Global Industries Inc,Dallas,Global Industries,1250000
Northwind Traders,Seattle,Northwind Traders LLC,310500
Summit Partners,Denver,,
```

--------------------------------

### GET /match

Source: https://docs.interzoid.com/entries/data-matching-wizard

Performs a data matching operation on a provided file URL using a specified matching algorithm.

```APIDOC
## GET /match

### Description
Processes a data file to identify matching records based on the selected algorithm and returns a clustered report.

### Method
GET

### Endpoint
https://match.interzoid.com/match

### Parameters
#### Query Parameters
- **connection** (string) - Required - URL or path to the data file
- **filetype** (string) - Required - csv or tsv
- **function** (string) - Required - One of: company-name-only, fullname-only, address-only, company-and-address, company-and-fullname, address-and-fullname
- **apikey** (string) - Required - Your Interzoid API license key
- **company_column** (integer) - Optional - 1-based column number for company name
- **fullname_column** (integer) - Optional - 1-based column number for individual name
- **address_column** (integer) - Optional - 1-based column number for street address
- **showkeys** (boolean) - Optional - true (default) or false — append similarity key to output
- **matchesonly** (boolean) - Optional - true (default) or false — show only matching clusters

### Request Example
curl "https://match.interzoid.com/match?connection=https://your-file-url/data.csv&filetype=csv&function=company-name-only&apikey=YOUR_API_KEY&company_column=3&showkeys=true&matchesonly=true"

### Response
#### Success Response (200)
- **body** (text) - Plain text output containing records organized into clusters with similarity keys.
```

--------------------------------

### Read-Only Azure SQL Connection String

Source: https://docs.interzoid.com/entries/azure-sql

A secure connection string example using the Application Intent=ReadOnly parameter for optimized read-only access.

```text
  server=myserver.database.windows.net;user id=interzoid_app_ro;password=StrongPassword123;port=1433;database=interzoid_db;Application Intent=ReadOnly;
```

--------------------------------

### Organization Name Standardization Output Example

Source: https://docs.interzoid.com/entries/data-enrichment-wizard

Shows the structure of data after running the Standardize Org Name enrichment, where a single new column is appended to the original data.

```text
IBM,1 New Orchard Road,Armonk,International Business Machines Corporation
MSFT,One Microsoft Way,Redmond,Microsoft Corporation
b.o.a.,100 N Tryon St,Charlotte,Bank of America
```

--------------------------------

### Execute Snowflake Matching via REST API

Source: https://docs.interzoid.com/entries/snowflake-data-matching

Example cURL command to trigger a matching job directly against a Snowflake data source.

```bash
$ curl "https://match.interzoid.com/match?\
driver=snowflake&\
db_host=xy12345.us-west-2&\
db_user=MY_USER&\
db_password=MY_PASSWORD&\
db_database=MY_DB&\
db_schema=PUBLIC&\
db_warehouse=COMPUTE_WH&\
table=CUSTOMERS&\
columns=COMPANY,ADDRESS,CITY,STATE&\
function=company-name-only&\
company_column_name=COMPANY&\
apikey=YOUR_API_KEY&\
showkeys=true&\
matchesonly=true"
```

--------------------------------

### Basic MySQL Connection String

Source: https://docs.interzoid.com/entries/mysql

Standard format for connecting to a MySQL instance. Replace placeholders with your specific database credentials.

```text
root:password@tcp(domain)/database
```

--------------------------------

### GET /match

Source: https://docs.interzoid.com/entries/snowflake-data-matching

Performs a data matching operation on a specified Snowflake table using the selected matching algorithm.

```APIDOC
## GET /match

### Description
Executes a data matching job on a Snowflake table based on the provided configuration and matching function.

### Method
GET

### Endpoint
https://match.interzoid.com/match

### Parameters
#### Query Parameters
- **driver** (string) - Required - Set to 'snowflake'
- **db_host** (string) - Required - Snowflake account identifier
- **db_user** (string) - Required - Snowflake username
- **db_password** (string) - Required - Snowflake password
- **db_warehouse** (string) - Required - Snowflake compute warehouse name
- **db_database** (string) - Required - Snowflake database name
- **db_schema** (string) - Required - Snowflake schema name
- **table** (string) - Required - Name of the table or view to read from
- **columns** (string) - Required - Comma-separated list of column names to include in the output
- **function** (string) - Required - One of: company-name-only, fullname-only, address-only, company-and-address, company-and-fullname, address-and-fullname
- **apikey** (string) - Required - Your Interzoid API license key
- **company_column_name** (string) - Optional - Name of the column containing company names
- **fullname_column_name** (string) - Optional - Name of the column containing individual names
- **address_column_name** (string) - Optional - Name of the column containing street addresses
- **showkeys** (boolean) - Optional - true (default) or false — append similarity key to output
- **matchesonly** (boolean) - Optional - true (default) or false — show only matching clusters

### Request Example
curl "https://match.interzoid.com/match?driver=snowflake&db_host=xy12345.us-west-2&db_user=MY_USER&db_password=MY_PASSWORD&db_database=MY_DB&db_schema=PUBLIC&db_warehouse=COMPUTE_WH&table=CUSTOMERS&columns=COMPANY,ADDRESS,CITY,STATE&function=company-name-only&company_column_name=COMPANY&apikey=YOUR_API_KEY&showkeys=true&matchesonly=true"
```

--------------------------------

### Perform an API call with a license key

Source: https://docs.interzoid.com/entries/api-license-keys

Use the license parameter in the query string to authenticate API requests.

```bash
$ curl "https://api.interzoid.com/getcompanymatch?license=YOUR_LICENSE_KEY&company=IBM+Corporation"
```

--------------------------------

### Define PostgreSQL Connection String

Source: https://docs.interzoid.com/entries/postgres

Use this template to construct a secure connection string for your PostgreSQL instance.

```text
postgres://{user}:{password}@{host}:{port}/{database}?sslmode=require
```

--------------------------------

### MySQL Native Connection String Format

Source: https://docs.interzoid.com/entries/mysql-data-matching

Use this format when providing a full connection string instead of individual fields.

```text
user:password@tcp(host:3306)/database?tls=true
```

--------------------------------

### PostgreSQL Connection String Format

Source: https://docs.interzoid.com/entries/postgres-data-matching

Use this URL-style connection string format to connect to your PostgreSQL database.

```text
postgres://user:password@host:5432/database?sslmode=require
```

--------------------------------

### Discover Snowflake Resources via API

Source: https://docs.interzoid.com/entries/snowflake-data-matching

Use these curl commands to list various Snowflake resources. Each call requires valid credentials and specific parameters to filter the discovery scope.

```bash
$ curl "https://match.interzoid.com/discover?db_host=xy12345.us-west-2&db_user=MY_USER&db_password=MY_PASSWORD&resource=warehouses"
```

```bash
$ curl "https://match.interzoid.com/discover?...&db_warehouse=COMPUTE_WH&resource=databases"
```

```bash
$ curl "https://match.interzoid.com/discover?...&db_warehouse=COMPUTE_WH&db_database=MY_DB&resource=schemas"
```

```bash
$ curl "https://match.interzoid.com/discover?...&db_database=MY_DB&db_schema=PUBLIC&resource=tables"
```

```bash
$ curl "https://match.interzoid.com/discover?...&db_schema=PUBLIC&table=CUSTOMERS&resource=columns"
```

--------------------------------

### Basic Azure SQL Connection String

Source: https://docs.interzoid.com/entries/azure-sql

Use this template to connect Interzoid to your Azure SQL instance by replacing the placeholders with your specific database credentials.

```text
  server={servername}.database.windows.net;user id={youruserid};password={yourpassword};port=1433;database=mysample;
```
Tokens:
Raw