There’s a small mistake in the terminology which may make it harder for folks to understand your goal.
To get information “from a URL” means to extract data from the location. For example, we could get the value “23” from the URL http://example.com?value=23.
Based on your more extended explanation, though, it’s clear that you actually want to get data from a resource–a web page in this case. That’s the “R” in “URL”, and it’s a little trickier than the “L”.
Scripts in the Scripting Block run in the browser. The web’s default security protections disallow you from doing this directly from a browser, though. There are a few ways to work around this:
- The page may be served in a way that relaxes the security restrictions. You can read about Cross-Origin Resource Sharing (CORS) to learn more. This needs to be enabled by the web server, and it’s usually not enabled by default. If the resources aren’t already being served in this way, you may be able to contact the administrator and request a change.
- You can write a command-line program that retrieves the data and uses the Airtable HTTP API. The API is documented here: https://airtable.com/api
- You may be able to use an integration service like Zapier or Integromat to perform the data retrieval task on your behalf. I’ve never worked with those services, but they seem to be very popular among Airtable users