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!!!

Tags

Submitted by

Stage: Active

Feedback Score

1 vote
1 up votes
0 down votes
Idea#53

Idea Details

Vote Activity

  1. Upvoted

Similar Ideas [ 4 ]

Events

  1. The idea was posted

Comments

  1. Comment
    Phillip Thomas

    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.

  2. Comment
    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!

  3. Comment
    Lisa W
    ( Moderator )

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

    Comments on this comment

    1. Comment
      Jan Vink

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

  4. Comment
    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!!!

  5. Comment
    Phillip Thomas

    Our current limit per query has been expanded to 50 total variables.

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

Add your comment