Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

There is an update set and a scheduled job.

  1. Download and install the update set (see the relevant wiki article)
  2. Download and install the scheduled job (see the relevant wiki article)

At this point you should do a cursory verification of the installation:

  1. reload Reload the application navigator and look for "QuickBase Resources."
  2. look Look at the Data Source form and check that there is now a "QuickBase" file retrieval type in the dropdown.
  3. ensure Ensure there is a new Scheduled Job with "QuickBase" in the name.

...at this point, you are ready to create/modify a data source to pull data from the QB API.

...

Warning

Any data source must use XML and an appropriate XPath row marker. The QuickBase module changes to the data source form don't enforce this, so if your settings are wrong your import may not work

  1. obtain Obtain your QuickBase credentials, app token, and target DBID for the table you want to import.
  2. in In the application navigator, go to "QuickBase Resources" and create and save a new record.
  3. click Click the "Refresh Authentication Ticket" UI Action to get a ticket and build a valid URL.
  4. in your Data Source:
    • select Select "QuickBase" as the file retrieval method.
    • select Select "XML" as the data type.
    • input Input an appropriate XPath for the row marker element in the target XML (e.g. "//row").
    • select Select the appropriate QuickBase Data Source to use.
    • Save and Stay.

Creating QuickBase Resource:

Configuring a Data Source:

Ready to Load:

...

Script Include

  • QuickBaseAuth object: originally, just implemented implements a method for retrieving a new ticket from a set of credentials and a named target instance
    Code Block
    /**
     * returns an array containing the ticket (index 0) and any error messages (index 1)
     * prototype => getTicket: function(instance, username, password)
     */
    
    // example:
    var qa = new QuickBaseAuth();
    
    var result = qa.getTicket('mydomain.quickbase.com', 'myusername', 'mypassword');
    ticket = result[0];
    error = result[1];
    

...