Iam also looking for similar thing for different json file.

So, I am trying to exclude the IP ranges present in the JSON link. To do that, I need to project all the data in the JSON. I tried writing the below code, but it threw an error: "There was a problem running the query. Try again later." Could anyone help me build the query?

let jsonData = externaldata(
syncToken: string,
createDate: string,
["prefixes"]: dynamic
)
[
h@"https://ip-ranges.amazonaws.com/ip-ranges.json"
]
with (format="multijson");
jsonData
| limit 10