API_RunImport Help

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
I'm able to do a successful import of data by a button click from one app to another using a saved Import.
After the button is clicked, the results are displayed in an XML format (shown below)


This XML file does not appear to have any style information associated with it. The document tree is shown below.
<errtext>No error</errtext>
<import_status>1 new record was created.</import_status>


How to display the message in a friendly format....like display the results in a form which shows the user how many records have been imported.

Any help appreciated.

Photo of QuickbaseUser


  • 494 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
no problem.

Create a report of records created today by the current user.  (ie a report with two filters)  if you want to work harder you can make a report of records created by the current user in the last hour.

Then make this formula URL button.

var text URLONE = urlroot() & "db/" & [_DBID_Table name goes here] & "?act=API_RunImport&ID=xx";  // fill in the import ID number you see in the url when you edit the saved import.  Typically the first one will be 10.

var text URLTWO = urlroot() & "db/"  & "?a=q&qid=xx"; // fill in your report ID#

"&rdr=" & urlencode($URLTWO)