I’m assuming the url is https://example.com/myfile.json
Yeah, you can for example, in a server side action (but first test it in your local node environment), fetch() that URL, the response will be the JSON content, just look into the Understanding context.async thread and you’ll know how to use fetch.
Then JSON.parse that into an object, then process that object to extract the values you want into an array, return to Bubble that array (or as many arrays you want) as a list (or as many lists you want) of texts (or number, or dates, whatever it is).