Choose Language Hide Translation Bar
samir
Community Trekker

Import (open) data from websites

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.

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Import (open) data from websites

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

View solution in original post

4 REPLIES 4
ian_jmp
Staff

Re: Import (open) data from websites

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.

0 Kudos
samir
Community Trekker

Re: Import (open) data from websites

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 ?

0 Kudos
ian_jmp
Staff

Re: Import (open) data from websites

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

0 Kudos

Re: Import (open) data from websites

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

View solution in original post