topic Re: Import (open) data from websites in Discussions

Import (open) data from websites

samir — Wed, 25 May 2016 12:26:57 GMT

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:

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.

ian_jmp — Wed, 25 May 2016 12:44:40 GMT

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(

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

);

Open(

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

);

Please try these.

samir — Wed, 25 May 2016 13:02:48 GMT

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 — Wed, 25 May 2016 13:49:36 GMT

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

Melanie_J_Drake — Wed, 25 May 2016 18:30:59 GMT

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