How to re-access a file on SharePoint?

ControlModes159 — Mon, 17 Jun 2024 11:28:46 GMT

Some time ago I created a script that gets data from a file on SharePoint. Everything worked smoothly. One day I started receiving an access error. I have attached the code but I have removed the exact link.
How to fix it and where is the cause of the problem?

//JMP16
dt = Open("https://link?download=1",
	Worksheets( "Sheet name" ), //Sheet selection
	Use for all sheets( 1 ),
	Concatenate Worksheets( 0 ),
	Create Concatenation Column( 0 ),
	Worksheet Settings(
		1,
		Has Column Headers( 1 ),
		Number of Rows in Headers( 1 ),
		Headers Start on Row( 1 ),
		Data Starts on Row( 41 ),
		Data Starts on Column( 1 ),
		Data Ends on Row( 56 ),
		Data Ends on Column( 0 ),
		Replicated Spanned Rows( 1 ),
		Replicated Spanned Headers( 0 ),
		Suppress Hidden Rows( 1 ),
		Suppress Hidden Columns( 1 ),
		Suppress Empty Columns( 1 ),
		Treat as Hierarchy( 1 ),
		Multiple Series Stack( 0 ),
		Import Cell Colors( 0 ),
		Limit Column Detect( 0 ),
		Column Separator String( "-" )
	)
);

Re: How to re-access a file on SharePoint?

jthi — Tue, 18 Jun 2024 04:48:53 GMT

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.

topic Re: How to re-access a file on SharePoint? in Discussions

How to re-access a file on SharePoint?

Re: How to re-access a file on SharePoint?