URL formula -API_RunImport
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] ...
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";
