Reference
Procedures
Every procedure is in the app's core schema, returns a VARIANT, and is called as
CALL TOMBA.core.<procedure>(...). Pass objects (not JSON strings) for VARIANT arguments, for example
{'domain': 'WEBSITE'}.
Tools on a table
| Procedure | What it does | Role |
|---|---|---|
find_emails(input_table STRING, domain_column STRING, first_name_column STRING, last_name_column STRING, output_table STRING, max_rows INT DEFAULT 100000) | Email Finder over a table | app_public |
verify_emails(input_table STRING, email_column STRING, output_table STRING, max_rows INT DEFAULT 100000) | Email Verifier over a table | app_public |
search_domains(input_table STRING, domain_column STRING, output_table STRING, max_rows INT DEFAULT 100000, emails_per_domain INT DEFAULT 10) | Domain Search over a table | app_public |
enrich_emails(input_table STRING, email_column STRING, output_table STRING, max_rows INT DEFAULT 100000) | Email Enrichment over a table | app_public |
enrich_people(input_table STRING, email_column STRING, output_table STRING, max_rows INT DEFAULT 100000) | Person Enrichment over a table | app_public |
enrich_companies(input_table STRING, domain_column STRING, output_table STRING, max_rows INT DEFAULT 100000) | Company Enrichment over a table | app_public |
enrich_combined(input_table STRING, email_column STRING, output_table STRING, max_rows INT DEFAULT 100000) | Combined Enrichment over a table | app_public |
find_emails_from_linkedin(input_table STRING, url_column STRING, output_table STRING, max_rows INT DEFAULT 100000) | LinkedIn Finder over a table | app_public |
find_authors(input_table STRING, url_column STRING, output_table STRING, max_rows INT DEFAULT 100000) | Author Finder over a table | app_public |
find_phones(input_table STRING, email_column STRING, output_table STRING, max_rows INT DEFAULT 100000) | Phone Finder over a table | app_public |
validate_phones(input_table STRING, phone_column STRING, output_table STRING, max_rows INT DEFAULT 100000, country_code_column STRING DEFAULT '') | Phone Validator over a table | app_public |
find_similar_domains(input_table STRING, domain_column STRING, output_table STRING, max_rows INT DEFAULT 100000) | Similar Domains over a table | app_public |
Tools on one value
| Procedure | What it does | Role |
|---|---|---|
email_finder(domain STRING, first_name STRING, last_name STRING) | Email Finder for one value | app_public |
email_verifier(email STRING) | Email Verifier for one value | app_public |
domain_search(domain STRING, emails_per_domain INT DEFAULT 10) | Domain Search for one value | app_public |
email_enrichment(email STRING) | Email Enrichment for one value | app_public |
person_enrichment(email STRING) | Person Enrichment for one value | app_public |
company_enrichment(domain STRING) | Company Enrichment for one value | app_public |
combined_enrichment(email STRING) | Combined Enrichment for one value | app_public |
linkedin_finder(url STRING) | LinkedIn Finder for one value | app_public |
author_finder(url STRING) | Author Finder for one value | app_public |
phone_finder(email STRING) | Phone Finder for one value | app_public |
phone_validator(phone STRING, country_code STRING DEFAULT '') | Phone Validator for one value | app_public |
similar_finder(domain STRING) | Similar Domains for one value | app_public |
Any tool
| Procedure | What it does | Role |
|---|---|---|
run_tool(tool STRING, input_table STRING, columns VARIANT, output_table STRING, max_rows INT, options VARIANT) | Any tool over a table, with a column mapping and options | app_public |
lookup(tool STRING, params VARIANT) | One lookup with any tool and inputs | app_public |
search_companies(filters VARIANT, output_table STRING, max_results INT DEFAULT 500) | Companies matching filters, into a table | app_public |
Background runs and resume
| Procedure | What it does | Role |
|---|---|---|
run_tool_async(tool STRING, input_table STRING, columns VARIANT, output_table STRING, max_rows INT, options VARIANT) | run_tool in the background; returns the run id | app_public |
search_companies_async(filters VARIANT, output_table STRING, max_results INT DEFAULT 500) | search_companies in the background | app_public |
cancel_run(run_id STRING) | Stop a running or queued run | app_public |
resume_run(run_id STRING) | Continue a stopped run | app_public |
set_auto_resume(run_id STRING, enabled BOOLEAN) | Turn auto-resume on or off for a run | app_public |
resume_pending() | Resume every run marked for auto-resume now (the app runs it daily) | app_public |
process_jobs() | Start queued background runs (the app runs it automatically) | app_public |
Schedules
| Procedure | What it does | Role |
|---|---|---|
create_schedule(name STRING, tool STRING, input_table STRING, columns VARIANT, output_table STRING, cron STRING, options VARIANT) | Keep a table enriched on a CRON schedule | app_admin |
list_schedules() | Schedules and their last run | app_public |
pause_schedule(name STRING) | Pause a schedule | app_admin |
resume_schedule(name STRING) | Restart a paused schedule | app_admin |
run_schedule(name STRING) | Run a schedule now | app_public |
drop_schedule(name STRING) | Delete a schedule (its table stays) | app_admin |
Utilities
| Procedure | What it does | Role |
|---|---|---|
status() | App version, connection approval, trial, daily limit | app_public |
list_tools() | Every tool with its inputs, options, credits and columns | app_public |
pricing() | Price per credit and credits per tool | app_public |
usage_summary(days INT DEFAULT 30) | Runs, credits and charges per day and tool | app_public |
get_settings() | Current settings | app_public |
set_setting(name STRING, value STRING) | Change a setting | app_admin |
clear_cache(tool STRING DEFAULT '') | Forget cached results for a tool ('' for all) | app_admin |
drop_result(output_table STRING) | Drop a result table | app_public |
reset_credentials() | Make the app reconnect to Tomba on its next lookup | app_admin |
Views: TOMBA.core.runs (every run) and TOMBA.core.usage_by_day. See Results and history.
Last modified on