Applescript to get Dropbox file direct/share link
To generate a shared link from a private folder you must make a request to Dropbox's servers using authentication with the Dropbox API. See the docs here.
I am not sure you can do that from an applescript, maybe you can use curl. But if you want this in an Alfred workflow you can always use another scripting language like php or python, which are more suitable.