Cloud Live Weather Append

This browser-based tool enables you to append live weather data to zip codes from database tables on 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 Zip Column Name is the column for which the appended data will be applied. You can generate reports with the appended data in comma-delimited form, generate SQL Insert scripts, or write results to new tables in the source database through the connection. A free usage tier is available.

Report Setup:

*Interzoid API License Key: Login or register to obtain

*Database Connection Type (Select):

*Database Connection String (use full URL if CSV, such as "https://dl.interzoid.com/csv/zips.csv"): Sample connection strings

*Table Name ("CSV" if CSV):

*Zip Code Column Name (Column # if CSV, first column = 1):

Optional Reference Column Name (to include on report):

New Table Name (only if writing results back to database):

Select Report Type:

Weather by Zip Code Report (most users)

Generate Insert SQL Script for All Records (advanced)

Create New Table in Source Database (advanced)

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.

API used for Weather by Zip

            
        Weather by Zip Sample:

        95476,Sonoma,CA,29.0,-1.7,Fair,...
        59937,Whitefish,MT,41.0,5.0,Mostly Cloudy,...
        96805,Honolulu,HI,76.0,24.4,Party Cloudy,...
        74003,Bartlesville,OK,45.0,7.2,Fair,...
        28801,Asheville,NC,50.0,10.0,Rain Fog/Mist,...

Return to Platform Home