how to open/save a data file on sharepoint in JSL?

[#1]

I tried to use 

dt = Open("https://company.sharepoint.com/.../myfile.jmp");

got error: Internet Error: 403 in access or evaluation of "open".

Any idea?

Thanks.

John

[#2]

Hi, John, try this:

dlg = New Window(<<Modal, "Click OK when logged in", V List Box(Web Browser Box("https://company.sharepoint.com/", JMP Window), Text Box("Click OK when logged into Sharepoint")));

dt = Open("https://company.sharepoint.com/.../myfile.jmp");

The web browser box allows your system to handshake with SP and provide credentials to JMP.

[#3]

Hi,

I have the same problem, getting the 403 error when trying to download excel file from sharepoint. My script seems to work with files for which I have editing rights. The file I am trying to download I have only read-only access, can this be the problem?

[#4]

Very interesting! We use Box, and naturally I've repurposed your code snippet. The handshake and login work. Opening the file doesn't. Thanks for the tip :)