topic Open jmp file from Teams/Sharepoint on publicly used script in Discussions

Open jmp file from Teams/Sharepoint on publicly used script

mtrensch — Thu, 25 Jul 2024 15:15:38 GMT

Opening a jmp file from Microsoft Teams/Sharepoint is simple enough if I'm the only one using the script. I just go into Teams and click "Add Shortcut to OneDrive" and then am able to map to the file as shown below.

dt = Open("C:\Users\{username}\OneDrive - {company}\Data\Table.jmp");

The problem I'm having is that I want this script to be usable by others in the company. I could make {username} a variable, but then it would still rely on others having the same shortcut added to their OneDrive. I've also tried copying the link to the file from Teams, but JMP isn't able to open that (e.g. https://{company}.sharepoint.com/:u:/s/{department}/Ed7cb_0X97BFtr4z-xh9mw0BBurcocxxsg91yyz9hHVUjg?e=y ). Even if that did work, I would have to know the exact path for each file when I would very much prefer to just use folder structure naming.

Is there a way to open Teams/Sharepoint files that will consistently work with multiple people using the script?

Re: Open jmp file from Teams/Sharepoint on publicly used script

jthi — Thu, 25 Jul 2024 15:29:10 GMT

Maybe one of these from would work?

"Few older posts (open JMP's web browser, authenticate there and then open the file)

There could be also an option to authenticate using HTTP Request, but I'm not familiar how that can be done with sharepoint."

Re: Open jmp file from Teams/Sharepoint on publicly used script

bryan_boone — Mon, 29 Jul 2024 21:48:36 GMT

I have the beginnings of a JSL/HTTP Request/New OAuth2 script that uses the MS Graph API.
It doesn't access files (yet).
The biggest hurdle is registering in your company's Azure/Entra portal.
Depending on your admin rights it can be super easy/barely an inconvenience or you may have to go through some hoops.
However, once authenticated, it's fairly easy to step through OneDrive/Sharepoint with MS graph.
Most of the data is JSON (which I just think of as JSL Associative Arrays)
when you get to a file item, there's a url where you can actually retrieve the file.

I can post what I have (or email me) if you're interested.