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.
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 namedThe issue: my url doesn't have a
queryparameter - it is a SELECT with a WHERE clause - butread.socratathows aqueryerror.