Is there a way to get data from a specific URL responding with JSON data as accessing the URL actually runs a php-script and returns JSON data.
If the endpoint returns JSON, then you should be able to use the REST data integration (via Data tab from the global toolbar at the top), regardless of how the backend itself is implemented. Did you try to do it that way yet+
There is also the advanced HTTP request flow function, but in most cases, the REST data resource integration should be enough and is the preferred one, since it has e.g. schema auto-detection etc.
Yes, I got it to work. Just needed to use “Get One”, not “Get All”.