Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

URL contianing SELECT and WHERE clause throws "query" error #194

Open
jbrnbrg opened this issue Jun 29, 2021 · 0 comments
Open

URL contianing SELECT and WHERE clause throws "query" error #194

jbrnbrg opened this issue Jun 29, 2021 · 0 comments

Comments

@jbrnbrg
Copy link

jbrnbrg commented Jun 29, 2021

Given the URL:
url <- "https://data.cityofnewyork.us/resource/qiz3-axqb.json?&$select=crash_date%20as%20date,%20borough,%20zip_code,%20latitude,%20longitude&$where=zip_code%20like%20'%2510040%25'"

If pasted into the address bar of a browser or pulled directly via the following:

df <- jsonlite::fromJSON(url)

the request works. However, if I try:

RSocrata::read.socrata(url, app_token = MYAPPTOKEN)

I get:

Error: All components of query must be named

The issue: my url doesn't have a query parameter - it is a SELECT with a WHERE clause - but read.socrata thows a query error.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant