Subscribe Bookmark RSS Feed

Import (open) data from websites

samir

Community Trekker

Joined:

May 20, 2016

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.

1 ACCEPTED SOLUTION

Accepted Solutions
melaniedrake

Staff

Joined:

May 30, 2014

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.

4 REPLIES
ian_jmp

Staff

Joined:

Jun 23, 2011

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.

samir

Community Trekker

Joined:

May 20, 2016

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 ?

ian_jmp

Staff

Joined:

Jun 23, 2011

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

melaniedrake

Staff

Joined:

May 30, 2014

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.