LiveCode Forums.

HI ppl,

I'm looking for to know if an equivalent operation as the "download" of an excell file could be done to instead "route" the file to another online/cloud folder (...so as to avoid a standard Download to folder X on PC Z...)

Any clue is that is in anyway possible..;and with what tool or method ?
*The idea behind being, you don't have to stand at your PC daily to retreive that data.
- As to why "download" an excell and not transfer or link the data to the target server by API or else...is that the DB provider is old tech and does not provide any other way than to retreive the data (from an aspx page ) using a push button to get your Excel file..
. (Welcome to Jurasic Park ! )

Any suggestion to "automate" this as far as possible...

Thanks

what's the code behind the pushbutton look like? Is there a direct link to the Excel file or is it doing some backend magic to download it?

I got some help from a friend and found out its using :
Handlerexec.asmx

Hi,

guess we'd need to know:

• What do you get with:

  Code: Select all

     get URL ("binfile:" & firstPartOfSourceURL & "Handlerexec.asmx")

  An excel file? This would be easy. Second question:
  .
• Where should this go to? Doesn't:

  Code: Select all

     put it into URL ("binfile:" & firstPartOfTargetURL & TargetFileName)

  do the job already?

Have fun!

Ok, I'm not an expert on that matter, but my friend could set some command running in the Terminal using "Curl".
including login to the website...then "activating" the download of the excell file...so actualy I didnt use LC during that first trial.
*Most Likely LC could send this command +variable but not sure if the use of "curl" along the way is needed or would using LC actualy makes it unecessary....
I would have to try now to mimic the Curl use with LC to reply to further questions...
I'll see whith a bit more time ahead.

Most likely I will try to grab the Excell file and send it to some Dropbox folder, that way I do not download it localy, never done that before
but my friend says its doable using the right commands/tool.
..so please, be patient for the answers I'm working on other part of the system right now...

thks for the still

Curl is a popular library to simplify using common Internet protocols like HTTP.

LiveCode has had built-in support for HTTP (and FTP) for decades in its libURL - see the get, post, and put commands.

More recently, proprietary editions of LiveCode even include curl itself, wrapped in an external called tsNet, providing a little more efficiency and some extra options useful in certain circumstances.

In short, working with server APIs can usually be done with LiveCode out of the box, no other extra components needed.