QuickBase API Cookbook v3 - Recipe #96
Exchange messages automatically between QuickBase and Twitter
twitter message automatic
You want to connect QuickBase and Twitter so that messages are automatically sent between the two applications, you want to send automated replies from QuickBase to Twitter, and you want to perform simple QuickBase queries from Twitter.
 
require 'QuickBaseTwitterConnector'

QuickBase::TwitterConnector.new

=begin

This is a example of what you will see.
The Twitter Connector will run in a loop, checking for new information every few minutes.
Probably the most useful feature of this Connector is the ability to send two types of
automated response, static text and the results from simple REST queries. 
Remember that Twitter only accepts the first 140 characters of text.

The Connector automatically creates a QuickBase application using your QuickBase
username and your Twitter username.

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

Please enter the Quickbase username to use for this session: fred_flintstone@internet.com
Please enter the Quickbase password to use for this session: wilma
Please enter the Twitter username to use for this session: fred_flintstone
Please enter the Twitter password to use for this session: wilma


Please enter a number to select the connection type:

1 - Send Twitter messages to QuickBase.
2 - Send QuickBase messages to Twitter.
3 - Exchange messages between QuickBase and Twitter.
4 - Send automated replies from QuickBase to Twitter.
5 - All the above.

5


Getting 'friends' Twitter Status since Fri, 28 Mar 2008 13:47:24 -0700.
Getting Direct Messages from Twitter since Fri, 28 Mar 2008 13:47:24 -0700.
Sending messages from QuickBase to Twitter added since Fri, 28 Mar 2008 13:47:24 -0700.
Getting Direct Messages from Twitter since Fri, 28 Mar 2008 13:47:24 -0700.
Automated Direct Message sent to wilma_flintstone: what's for dinner?: rex ribs

=end
The best way to understand how the TwitterConnector works is by reading the source code of the QuickBaseTwitterConnector.rb file which is part of the Ruby wrapper.
runQuickBaseTwitterConnector.rb
One-Click Ruby Installer for Windows Ruby wrapper for QuickBase HTTP API
Created on March 28, 2008 at  2:24 PM (PDT). Owned by Quick Base.
Quick Base
Show fields from Show fields from Show fields from a related table
Report Name *
Description
Reports and Charts Panel
Each table has a panel listing its reports and charts, organized in groups.
Please wait while your new report is saved...
Field label
Column heading override
Justification
What does auto mean?
Fields in:

Fields to Extract:

Name for the new table:
Items in the new table are called:

When you bring additional fields into a conversion, Quickbase often finds inconsistencies. For example, say you're converting your Companies column into its own table. One company, Acme Corporation, has offices in New York, Dallas and Portland. So, when you add the City column to the conversion, Quickbase finds three different locations for Acme. A single value in the column you're converting can only match one value in any additional field. Quickbase needs you to clean up the extra cities before it can create your new table. To do so, you have one of two choices:

  • If you want to create three separate Acme records (Acme-New York, Acme-Dallas and Acme-Portland) click the Conform link at the top of the column.
  • If the dissimilar entries are mistakes (say Acme only has one office in New York and the other locations are data-entry errors) go back into your table and correct the inconsistencies—in this case, changing all locations to New York. Then try the conversion again.

Read more about converting a column into a table.

We're glad you're interested in doing more with Quickbase!

Now we need to make you official before you share apps or manage your account.

Verifying your email lets you share Quickbase with others in your company.

Your work email
Your company