topic Re: how to open/save a data file on sharepoint in JSL? in Discussions

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

zxu11 — Fri, 09 Jun 2023 18:03:31 GMT

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

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

Michael_MXAK — Fri, 22 Oct 2021 18:52:43 GMT

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.

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

IloinenHamsteri — Wed, 27 Mar 2024 07:08:59 GMT

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?

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

Ressel — Wed, 27 Mar 2024 19:56:10 GMT

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 :)