Steve Jernigan • over 14 years ago
DOL iOS API problem?
Is anyone else having a problem with using iOS API to get data from the Statistics/CPS/LE_SERIES table?
NSString *method = @"Statistics/CPS/LE_SERIES";
NSDictionary *arguments = [NSDictionary dictionaryWithObjectsAndKeys:@"10", @"top",@"SERIES_ID", @"select",nil];
[dataRequest callAPIMethod:method withArguments:arguments];
gives the error:
{
"error": {
"code": "", "message": {
"lang": "en-US", "value": "An error occurred while processing this request."
}
}
}
Other tables such as LE_DATA_PUB is returning fine:
NSString *method = @"Statistics/CPS/LE_DATA_PUB";
NSDictionary *arguments = [NSDictionary dictionaryWithObjectsAndKeys:@"10", @"top",@"SERIES_ID", @"select",nil];
[dataRequest callAPIMethod:method withArguments:arguments];
{
"__metadata": {
"uri": "http://api.dol.gov/V1/Statistics/CPS/LE_DATA_PUB(PERIOD='A01',SERIES_ID='LEU0203126800',YEAR='2000')", "type": "CPSModel.LE_DATA_PUB"
}, "SERIES_ID": "LEU0203126800"
}, {
"__metadata": {
"uri": "http://api.dol.gov/V1/Statistics/CPS/LE_DATA_PUB(PERIOD='A01',SERIES_ID='LEU0203126800',YEAR='2001')", "type": "CPSModel.LE_DATA_PUB"
}, "SERIES_ID": "LEU0203126800"
},
etc. etc.
Has anyone got a query working off the LE_SERIES table?
Comments are closed.
8 comments
Mike Pulsifer Manager • over 14 years ago
Steve,
I've been able to duplicate your error. We're looking into it at the moment and I'll let you know when we get this resolved.
Steve Jernigan • over 14 years ago
How's the fix coming along? Any ETA yet?
Mike Pulsifer Manager • over 14 years ago
No ETA yet. We're still trying to track down the source of the issue with this one table. Have you tried a request of more than just the series ID?
Steve Jernigan • over 14 years ago
I've tried lots of different queries to try to get this to work. I chose the query above because it best demonstrates the issue. Do you have a different query that works against this table that I can try?
Mike Pulsifer Manager • over 14 years ago
After extensive digging, it looks like it might be a problem with the data. It's still preliminary, but signs are pointing in that direction. It could possibly be some problem characters that .Net is ignoring, but are causing problems for iOS and Android. We're going to continue trying to isolate the source of the problem and get it fixed ASAP.
Steve Jernigan • over 14 years ago
Thanks Mike. Please keep plugging away at it. My app isn't going to be very interesting without this data. I ran on Wednesday night and the API is still giving that error response.
Mike Pulsifer Manager • over 14 years ago
Steve,
I believe we have fixed the problem with the LE_DATA_PUB table. It's an issue found in all of the other BLS tables used in this challenge as well. We will continue rolling out fixes to those tables during the day today.
Steve Jernigan • over 14 years ago
Thanks Mike, that did the trick. Here's part of the response for evidence.
2012-02-28 19:48:53.436 GenderGap[15082:10103] {
"d" : [
{
"__metadata": {
"uri": "http://api.dol.gov/V1/Statistics/CPS/LE_SERIES('LES1252881500')", "type": "CPSModel.LE_SERIES"
}, "SERIES_ID": "LES1252881500"
}, {
"__metadata": {
"uri": "http://api.dol.gov/V1/Statistics/CPS/LE_SERIES('LES1252881600')", "type": "CPSModel.LE_SERIES"
}, "SERIES_ID": "LES1252881600"
}, {
"__metadata": {
"uri": "http://api.dol.gov/V1/Statistics/CPS/LE_SERIES('LES1252881800')", "type": "CPSModel.LE_SERIES"
}, "SERIES_ID": "LES1252881800"
}, {
"__metadata": {
"uri": "http://api.dol.gov/V1/Statistics/CPS/LE_SERIES('LES1252881900')", "type": "CPSModel.LE_SERIES"
}, "SERIES_ID": "LES1252881900"
}, {
You guys rock! Let the games begin...