Vote up to Idea more than four variables? Vote down to Idea more than four variables?

Rank94

Idea#53

This idea is active.
Bugs / Problems »

more than four variables?

I can't seem to get more than four variables to return.

When I run this query:

http://api.census.gov/data/2010/acs5?key={key}&get=B08101_017E,B08101_017M,B08101_025E,B08101_025M,B08101_033E,B08101_033M,B08101_041E,B08101_041M&for=tract:*&in=state:41+county:005

I get an error like this:

error: error: unknown variable 'B08101_033E,B08101_033M,B08101_041E,B08101_041M'

When I run the query with only the first four variables (B08101_017E,B08101_017M,B08101_025E,B08101_025M) it works!

When I run the query with the LAST four variables (B08101_033E,B08101_033M,B08101_041E,B08101_041M) it works.

If I switch the order of the variables, it always errors out with the last four variables being "unknown"

Is this a known problem? I saw somewhere else on the discussion board where someone mentioned using nine variables...

Thanks! Looking forward to using the API to update our database with the new ACS data on Dec 6th!!!

Comment

Submitted by percyd 1 year ago

Comments (6)

  1. I recall there being another post on this, there is a 4(5?) variable limit imposed on all queries made to the API. We are working on enabling more variables, however there are performance issues when attempting to pull back more than 4 variables that we need to minimize/mitigate.

    1 year ago
  2. percyd Idea Submitter

    Perhaps you could at least change the error message so that it more accurately reflects the situation so that developers don't spend a *bunch* of time trying to figure out why their query is failing!

    Thanks!

    1 year ago
  3. Moderator

    We just released an update to the API to allow more variables per call. Please give it a try.

    1 year ago
    1. Thanks for doing this. Is there a new maximum of variables?

      1 year ago
  4. percyd Idea Submitter

    awesome! my original query with eight variables works!

    WooHoo!!!

    Now, like Jan asked, is there an upper limit on how many variables I can request? And does it matter if they come from different tables?

    Thanks!!!

    1 year ago
  5. Our current limit per query has been expanded to 50 total variables.

    The limit counts all variables, so cross-table queries are still enabled.

    1 year ago

Vote Activity Show

Events

  1. The idea was posted
    1 year ago