#!/usr/bin/perl
require 'c:/quickbase.pm';#REF Perl SDK
use LWP;
my $url = "http://somesite.com/forcast.txt";
my $ua = LWP::UserAgent->new();
$ua->proxy(['http'],'http://ourproxy.oursite.com:80');
$ua->credentials($netloc, $realm, $uname, $pass);
my $response = $ua->get($url);
open (FILE, ">C:\\snow.txt") || die "Can't open Snow.txt $!\n";
print FILE $response->content;
close(FILE);
open (FILE, "<C:\\snow.txt") || die "Can't open Snow.txt $!\n";
my $column=0;
while ($line = <FILE>){
	chomp($line);
	push @data, [split /\t/,$line];
	}
close(FILE);
@column = map {$$_[0]} @data;
shift(@column);
$stores =  join( ' OR ',@column); 
my $qdb = HTTP::QuickBase->new();
$qdb->proxy('http://ourproxy.oursite.com:80');
$qdb->url_prefix("https://www.quickbase.com/db");
$qdb->authenticate("MyUserName","MyPass");
$qdb->apptoken('bj6azdybdeg8akbcu5ggabfdedsi');
my $recid=$qdb->gen_results_table("babvce7n4",{query=>"{'6'.EX.$stores}",clist=>"3",options=>"csv"});
my @recids = split /\n|\r\n/,$recid;
my $i = 0;
@data = map{unshift(@{$_},$recids[$i++]);$_} @data;
$a =  join( "\n", map {join(',',@{$_})} @data);
my $import = $qdb->import_from_csv("bhabcde7f",$a,"6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25","1");