In reply to Suren.

Yes, you can use graphql. I've done this with some projects, such as to get GitHub project vulnerability data.

filename in "&authpath./github_vuln_graphql2.json";
proc http
url="https://api.github.com/graphql"
method="POST"
in=in
out=resp
;
headers
"Authorization" = "token &AUTH."
;
run;

Where the JSON file I pass in is something like:

{"query":"{organization(login:\"my-org-name\") {repositories(first:100){edges{node{owner {id} name vulnerabilityAlerts(first:100){edges{node{ dismissReason dismissedAt securityVulnerability { package {name ecosystem } advisory { identifiers {type value}} severity} vulnerableManifestFilename }}}}}}}}"}

The JSON that comes back isn't exactly neat data sets, so I usually end up using DATA step to pull from the ALLDATA member of the JSON library.