You can use the rest connector to do that.
As an example, i'm using the
https://jsonplaceholder.typicode.com link that has some rest functionalities.
Using the wizard, it gives the code:
CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=
https://jsonplaceholder.typicode.com/posts;timeout=30;method=GET;sendExpect100Continue=True;autoDete...;";
RestConnectorMasterTable:
SQL SELECT
"userId",
"id",
"title",
"body"
FROM JSON (wrap on) "root";
[root]:
LOAD [userId],
[id],
[title],
[body]
RESIDENT RestConnectorMasterTable;
DROP TABLE RestConnectorMasterTable;
Which loads the data from :
https://jsonplaceholder.typicode.com/posts