uktrade / public-data-api

The source for the Department for International Trade's Public Data API
https://data.api.trade.gov.uk/
MIT License
5 stars 1 forks source link

Bad gateway querying newer datasets using S3 query #197

Open bencarr1337 opened 9 months ago

bencarr1337 commented 9 months ago

Using a S3 query like below results in a Gateway timeout...

url --get https://data.api.trade.gov.uk/v1/datasets/uk-tariff-2021-01-01/versions/v4.0.30/data \ --data-urlencode "format=json" \ --data-urlencode "query-s3-select= SELECT c.commoditycode, c.commoditysuffix, c.commoditydescription FROM S3Object[].commodities[] c WHERE c.commoditycode = '0101210000' LIMIT 1 "

SteveCN7 commented 8 months ago

Hi @bencarr1337

Sorry for the delay in the response, our notifications on this repo haven't been directing properly.

Can you advise if you're still encountering this problem and I can escalate with the team to look at?

Many Thanks