Here: https://bit.ly/3KuXgpE
--
On my local machine
url <- "https://esastar-emr.sso.esa.int/PublicEntityDir/PublicEntityDirGridSme?term=&isForRegister=False&isForEmits=True&grid-page=3"
jsonlite::fromJSON(url)
#> Error in open.connection(con, "rb"): SSL certificate problem: unable to get local issuer certificate
On Docker
url <- "https://esastar-emr.sso.esa.int/PublicEntityDir/PublicEntityDirGridSme?term=&isForRegister=False&isForEmits=True&grid-page=3"
jsonlite::fromJSON(url)
#> Error in open.connection(con, "rb"): SSL certificate problem: unable to get local issuer certificate
On rstudio.cloud
url <- "https://esastar-emr.sso.esa.int/PublicEntityDir/PublicEntityDirGridSme?term=&isForRegister=False&isForEmits=True&grid-page=3"
jsonlite::fromJSON(url)
#> Error in open.connection(con, "rb"): server certificate verification failed. CAfile: none CRLfile: none
I tried this workaround but it made no difference to me:
git config --global http.sslVerify false
Thanks CJ
url <- "http://esastar-emr.sso.esa.int/PublicEntityDir/PublicEntityDirGridSme?term=&isForRegister=False&isForEmits=True&grid-page=3"
tmp <- tempfile()
h <- curl::new_handle(ssl_verifypeer= 0)
curl::curl_download(url, destfile = tmp, handle = h)
jsonlite::fromJSON(tmp)
#> $html
#> [1] "\r\n\r\n <div class=\"grid-mvc\" data-lang=\"en\" data-gridname=\"\" data-selectable=\"true\" data-multiplefilters =\"false\">\r\n <div class=\"grid-wrap\">\r\n <table class=\"table table-striped grid-table\">\r\n \r\n <thead>\r\n <tr>\r\n<th class=\"grid-header\"><div class=\"grid-filter\" data-filterdata=\"[]\" data-name=\"Name\" data-type=\"System.String\" data-url=\"?term=&isForRegister=False&isForEmits=True\" data-widgetdata=\"null\"><span class=\"grid-filter-btn\" title=\"Filter this column\"></span></div><div class=\"grid-header-title\"><a href=\"?term=&isForRegister=False&isForEmits=True&grid-column=Name&grid-dir=0\">Name</a></div></th><th class=\"grid-header\"><div class=\"grid-filter\" data-filterdata=\"[]\" data-name=\"NationalityDesc\" data-type=\"System.String\" data-url=\"?term=&isForRegister=False&isForEmits=True\" data-widgetdata=\"null\"><span class=\"grid-filter-btn\" title=\"Filter this column\"></span></div><div class=\"grid-header-title\"><a href=\"?term=&isForRegister=False&isForEmits=True&grid-column=NationalityDesc&grid-dir=0\">Country of Registration</a></div></th><th class=\"grid-header\"><div class=\"grid-filter\" data-filterdata=\"[]\" data-name=\"EntityTypeDesc\" data-type=\"System.String\" data-url=\"?term=&isForRegister=False&isForEmits=True\" data-widgetdata=\"null\"><span class=\"grid-filter-btn\" title=\"Filter this column\"></span></div><div class=\"grid-header-title\"><a href=\"?term=&isForRegister=False&isForEmits=True&grid-column=EntityTypeDesc&grid-dir=0\">Entity Type</a></div></th><th class=\"grid-header\"><div class=\"grid-filter\" data-filterdata=\"[]\" data-name=\"EntitySizeDesc\" data-type=\"System.String\" data-url=\"?term=&isForRegister=False&isForEmits=True\" data-widgetdata=\"null\"><span class=\"grid-filter-btn\" title=\"Filter this column\"></span></div><div class=\"grid-header-title\"><a href=\"?term=&isForRegister=False&isForEmits=True&grid-column=EntitySizeDesc&grid-dir=0\">Entity Size</a></div></th><th class=\"grid-header\"><div class=\"grid-filter\" data-filterdata=\"[]\" data-name=\"EntitySMEStatus\" data-type=\"System.String\" data-url=\"?term=&isForRegister=False&isForEmits=True\" data-widgetdata=\"null\"><span class=\"grid-filter-btn\" title=\"Filter this column\"></span></div><div class=\"grid-header-title\"><a href=\"?term=&isForRegister=False&isForEmits=True&grid-column=EntitySMEStatus&grid-dir=0\">SME Status</a></div></th><th class=\"grid-header\"><div class=\"grid-header-title\"><a href=\"?term=&isForRegister=False&isForEmits=True&grid-column=EntityId&grid-dir=0\">Details</a></div></th> </tr>\r\n\r\n </thead>\r\n <tbody>\r\n <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">AALTA LAB D.O.O.</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">SI-Slovenia</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/58027\" title=\"View details\"> </a></td> </tr>\r\n <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">AATC Analog Astronaut Training Center</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">PL-Poland</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/97207\" title=\"View details\"> </a></td> </tr>\r\n <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">AB5 CONSULTING</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">GB-United Kingdom</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/58835\" title=\"View details\"> </a></td> </tr>\r\n <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">Abaco Digital s.l.</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">ES-Spain</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/97153\" title=\"View details\"> </a></td> </tr>\r\n <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">ABACONS SRL</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">IT-Italy</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/83782\" title=\"View details\"> </a></td> </tr>\r\n <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">Abaqo Ingenieria Iberia</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">ES-Spain</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/83249\" title=\"View details\"> </a></td> </tr>\r\n <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">AB-ARCHIVIBIBLIOTECHE SRL</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">IT-Italy</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/86608\" title=\"View details\"> </a></td> </tr>\r\n <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">abaut GmbH</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">DE-Germany</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/72724\" title=\"View details\"> </a></td> </tr>\r\n <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">ABELIUM D.O.O.</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">SI-Slovenia</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/59501\" title=\"View details\"> </a></td> </tr>\r\n <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">Abiogenesis Computer Systems Lab AB</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">SE-Sweden</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/69364\" title=\"View details\"> </a></td> </tr>\r\n <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">ABmerit</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">SK-Slovakia</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/69956\" title=\"View details\"> </a></td> </tr>\r\n <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">ABOA SPACE RESEARCH OY - ASRO</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">FI-Finland</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/61897\" title=\"View details\"> </a></td> </tr>\r\n <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">AboveRF BV</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">BE-Belgium</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/128887\" title=\"View details\"> </a></td> </tr>\r\n <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">ABSOLUT-SYSTEM</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">FR-France</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/51969\" title=\"View details\"> </a></td> </tr>\r\n <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">ABSPACECONSULTING</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">FR-France</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/128794\" title=\"View details\"> </a></td> </tr>\r\n <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">AC Satcom</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">DK-Denmark</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/71811\" title=\"View details\"> </a></td> </tr>\r\n <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">Access Earth LTD</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">IE-Ireland</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/71409\" title=\"View details\"> </a></td> </tr>\r\n <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">ACM Coatings GmbH (subsidiary of Acktar Ltd.)</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">DE-Germany</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/66568\" title=\"View details\"> </a></td> </tr>\r\n <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">ACM Energy Limited</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">IE-Ireland</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/86755\" title=\"View details\"> </a></td> </tr>\r\n <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">ACORDE TECHNOLOGIES SA</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">ES-Spain</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/51949\" title=\"View details\"> </a></td> </tr>\r\n\r\n </tbody>\r\n </table>\r\n <div class=\"grid-footer\">\r\n <div class=\"grid-pager\">\r\n <ul class=\"pagination\">\r\n <li>\r\n <a href=\"?term=&isForRegister=False&isForEmits=True&grid-page=2\">«</a>\r\n </li>\r\n\r\n <li><a href=\"?term=&isForRegister=False&isForEmits=True&grid-page=1\">1</a></li>\r\n <li><a href=\"?term=&isForRegister=False&isForEmits=True&grid-page=2\">2</a></li>\r\n <li class=\"active\"><span>3</span></li>\r\n <li><a href=\"?term=&isForRegister=False&isForEmits=True&grid-page=4\">4</a></li>\r\n <li><a href=\"?term=&isForRegister=False&isForEmits=True&grid-page=5\">5</a></li>\r\n <li><a href=\"?term=&isForRegister=False&isForEmits=True&grid-page=6\">...</a></li>\r\n <li><a href=\"?term=&isForRegister=False&isForEmits=True&grid-page=146\">146</a></li>\r\n <li><a href=\"?term=&isForRegister=False&isForEmits=True&grid-page=4\">»</a></li>\r\n </ul>\r\n</div>\r\n\r\n </div>\r\n\r\n </div>\r\n </div>\r\n\r\n\r\n<script>\r\n $(function () {\r\n //details button: shows details popup\r\n $(\".gridDetails\").click(function (event) {\r\n event.preventDefault();\r\n event.stopPropagation();\r\n\r\n OpenPopupDialog(event.target, 'Entity Details', false, null);\r\n\r\n });\r\n });\r\n</script>"
#>
#> $Success
#> [1] TRUE
Created on 2022-01-20 by the reprex package (v2.0.1)