Yes, you can do this, but you will need to use expressions to accomplish it. You can set numerical values in your data, then map that data to a dynamic text layer in your project. Then, you can use a parseInt() expression to parse the value of the sourceText of the layer into a number that can be used in any numerical value such as position, scale, rotation, etc. See referencing dynamic text layers section.
You have the ability to write a shell script on the “Pre-Data” event. See event [ 2a ] in our table of events that Templater broadcasts. In that script, you can run any commands needed to retrieve an API access token. Does this help?
For remote URL data sources, Templater supports Basic Authentication at the moment. How are you expecting to use the API access token once you retrieve it? Are you wanting to send it with request Templater makes? If so, I’m not sure that’s possible out of the box even with scripting. However, you should be able to get the API token via a shell script by registering it to the “Pre-Data” event.
Also, don’t forget that you may need to enable the “Tab delimited file exported from Excel or Numbers” checkbox within the Templater Preferences dialog to work with TSV data exported or saved from Microsoft Excel.