Import (open) data from websites

[#1]

Hello,

I am trying to import data from a web page, but it fails although I use the exact syntax mentioned in the documentation.

Here is the code I use:

My_URL=https://www.jetairfly.com/fr/last-minute/charleroi/bejaia;

ObjectName = Open(My_URL, HTML Table(1));

Here is the error message I get:

Unable to read data from "https://www.jetairfly.com/fr/last-minute/charleroi/bejaia" in access or evaluation of 'Open' , Open( My_URL, HTML Table( 1 ) )

In the following script, error marked by /*###*/

ObjectName = Open/*###*/(My_URL, HTML Table( 1 ))

Could someone help ?

Thanks.

[#2]

I had JMP generate the scripts below for by (by using 'File > Internet Open' and copying the 'Source' script it puts in the table):

Open(

"https://www.jetairfly.com/fr/last-minute/charleroi/bejaia",

HTML Table( 1, Column Names( 1 ), Data Starts( 2 ) )

);

Open(

"https://www.jetairfly.com/fr/last-minute/charleroi/bejaia",

HTML Table( 2, Column Names( 1 ), Data Starts( 2 ) )

);

Please try these.

[#3]

No it does not work, does if for you ?

I get the same error.

Strange enough, when I used 'File > Internet Open', I got a different source code...

I am using JMP11, could this be the reason ?

[#4]

I'm using JMP 12 (on a Mac) and, yes, it worked for me.

[#5 · Accepted solution]

Internet Open support for HTTPS sites was added in JMP 12, so you won't be able to open this URL in JMP 11.