data engineering apis

Find Data Not in Specified Numeric Range

This browser-based tool enables you to determine if data values are in a specified numeric range from database tables existing in the Cloud on the major Cloud Data Platforms (or any other database that you can access via the Internet). Simply provide the connection string from your data source's database, table name, and column name(s). The Analyze Column Name is the column for which analysis will occur, identifying any values that are not in the specified numeric range. This is an easy step to take in improving the usability and value of your important data assets.

For instructions on how to include range tests of a dataset in workflow, including scheduled runs, ongoing processing, or part of a data pipeline, see the Range Test Workflow Guide.


Run Here - Report Setup:


Login or register to obtain
Sample connection strings

Select Report Type:


* Note: Use connection type = "CSV File", connection string = "https://dl.interzoid.com/csv/range.csv", table name = "CSV", and column name = "1" for a demo that does not use credits from your account.


Additional Information:


Login to www.interzoid.com to obtain your API Key. It is how we track usage. If you do not yet have one, register for a free trial at www.interzoid.com/register-api-account.

Sample SQL Scripts in case you need sample/test data for a test drive.

How to use CSV files for data processing within Interzoid Cloud Data Connect.


            
        Data out of Range Report Sample (Must be: >= 5.5 and <= 300):
3.25 -6 b7 424 904.88

Run scheduled or as part of a batch script? Embed in workflow or within a data pipeline? Execute programmatically? You can run this entire process with a single API call. Example:

            
        https://connect.interzoid.com/run?function=notinrange&apikey=use-your-own-api-key-here&source=CSV&connection=https://dl.interzoid.com/csv/range.csv&table=CSV&column=1&minimum=1&maximum=10
            


Full Dataset Processing API Documentation

Return to Platform Home


All content (c) 2018-2023 Interzoid Incorporated. Questions? Contact support@interzoid.com

201 Spear Street, Suite 1100, San Francisco, CA 94105-6164

Interested in Data Cleansing Services?

Start Here
Terms of Service
Privacy Policy

Use the Interzoid Cloud Connect Data Platform and Start to Supercharge your Cloud Data Now: connect.interzoid.com
API Integration Code Examples and SDKs: github.com/interzoid
Documentation and Overview: Docs site
Interzoid Product and Technology Newsletter: Subscribe