cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
Ole
Ole
Level III

Executing file from Office sharepoint directly

Hi,

 

I am in progress of transferring my scripts to the companies new office 365 account. I would like to be able to access and execute the jsl's (and csv's, html,s) directly from sharepoint with a link like

include("https://company.sharepoint.com/sites/Site_Name/Shared%20Documents/General/Data_Center/01_scripts/01_...");

so that all jmp users can run the same script pressing a button from a journal I created.

I get an error message failed because of: Internet error 403 ...

 

If I try to open the link directly from JMP I get the following error message:

Ole_0-1616266865780.png

 

Is there a way to run the jsl from this link (and similarly open, save and close excel and html's)?

 

Thanks

Ole

1 ACCEPTED SOLUTION

Accepted Solutions
ih
Super User (Alumni) ih
Super User (Alumni)

Re: Executing file from Office sharepoint directly

Hi @Ole,

 

One option is to open the page in a JMP web browser window first.  Have a look at these threads:

 

Open microsoft office 365 cloud-based excel from JMP/JSL? 

How to extract data from an Excel file on Sharepoint? 

View solution in original post

2 REPLIES 2
ih
Super User (Alumni) ih
Super User (Alumni)

Re: Executing file from Office sharepoint directly

Hi @Ole,

 

One option is to open the page in a JMP web browser window first.  Have a look at these threads:

 

Open microsoft office 365 cloud-based excel from JMP/JSL? 

How to extract data from an Excel file on Sharepoint? 

Ole
Ole
Level III

Re: Executing file from Office sharepoint directly

Hi, 

 

Sorry for the late reply. I changed company and as I now came into the same situation again I had to retry the fix you proposed. It took me some time but eventually got it to work. The one thing that threw me off was that I didn't run the command below first. It has only to be run one time. After that the connection between JMP and Office is established:

 

Web( "https://company.sharepoint.com/:x:/r/sites/Folder/filename.xlsx", JMP window );

 

The command 

Web( "https://teams.microsoft.com", JMP window );

that was used in the embedded links doesn't work with the newest version of Office.