URL formula -API_RunImport

Question

I would like to create a URL formula button -- that when clicked it will run a table to table import --- this is what I have created (did not work)

var text URLONE = URLRoot() & "db/" & [Table ID] & "?act=API_RunImport&ID="&[TableImportID]&"";

$URLONE

MarkShnierYou · Accepted Answer

The advanced settings for your application there is a place to indicate whether or not you want to use application tokens. The extra level of security is up to you but for most of my clients I do not enable them unless there is some private healthcare data that they are concerned about. But if you do want to use application tokens then you need to create one and then use the syntax

var text URLONE = URLRoot() & "db/" & [Table ID]

& "?act=API_RunImport&ID=" & [TableImportID]

& "&apptoken=xxxxxxxxxxxxx";

MarkShnierYou · Answer

Lee once you run a API call you need to learn the user on a page or a record or a report. Here is an example which will simply refresh the page that they user is on after the API call.

var text URLONE = URLRoot() & "db/" & [Table ID] & "?act=API_RunImport&ID=" & [TableImportID];

var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();

$URLONE
& "&rdr=" & URLEncode($RefreshPage)

Sign up

Login to the community