davidrpugh / davidrpugh/pyBEA

Possibly inconsistent JSON formatting returned by API calls to the IIP data set

Open
#28 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
71
Forks
27
PR merge metrics
No merged PRs in 30d

Description

All other JSON output returned by the BEA API includes "DATA" as a key of the "RESULTS" JSON object. Here that doesn't seem to be the case.

```json
{"BEAAPI":{"Request":{"RequestParam":[{"ParameterName":"YEAR","ParameterValue":"ALL"},{"ParameterName":"FREQUENCY","ParameterValue":"A"},{"ParameterName":"COMPONENT","ParameterValue":"CHGPOSPRICE"},{"ParameterName":"DATASETNAME","ParameterValue":"IIP"},{"ParameterName":"RESULTFORMAT","ParameterValue":"JSON"},{"ParameterName":"METHOD","ParameterValue":"GETDATA"},{"ParameterName":"USERID","ParameterValue":"98A0A0A7-21DF-4B75-96DE-1410D47AB280"},{"ParameterName":"TYPEOFINVESTMENT","ParameterValue":"FINASSETSEXCLFINDERIV"}]},"Results":{"Dimensions":[{"Ordinal":"1","Name":"TypeOfInvestment","DataType":"string","IsValue":"0"},{"Ordinal":"2","Name":"Component","DataType":"string","IsValue":"0"},{"Ordinal":"4","Name":"Frequency","DataType":"string","IsValue":"0"},{"Ordinal":"5","Name":"Year","DataType":"string","IsValue":"0"},{"Ordinal":"6","Name":"TimeSeriesId","DataType":"string","IsValue":"0"},{"Ordinal":"7","Name":"TimeSeriesDescription","DataType":"string","IsValue":"0"},{"Ordinal":"8","Name":"TimePeriod","DataType":"string","IsValue":"0"},{"Ordinal":"9","Name":"CL_UNIT","DataType":"string","IsValue":"0"},{"Ordinal":"10","Name":"UNIT_MULT","DataType":"string","IsValue":"0"},{"Ordinal":"11","Name":"DataValue","DataType":"numeric","IsValue":"1"}]},"Data":[{"TypeOfInvestment":"FinAssetsExclFinDeriv","Component":"ChgPosPrice","Frequency":"A","Year":"2003","TimeSeriesId":"TSI_IipFinAssetsExclFinDerivChgPosPrice_A","TimeSeriesDescription":"U.S. assets excluding financial derivatives (Change in position attributable to price changes); annual","TimePeriod":"2003","CL_UNIT":"USD","UNIT_MULT":"6","DataValue":"767451","NoteRef":""},{"TypeOfInvestment":"FinAssetsExclFinDeriv","Component":"ChgPosPrice","Frequency":"A","Year":"2004","TimeSeriesId":"TSI_IipFinAssetsExclFinDerivChgPosPrice_A","TimeSeriesDescription":"U.S. assets excluding financial derivatives (Change in position attributable to price changes); annual","TimePeriod":"2004","CL_UNIT":"USD","UNIT_MULT":"6","DataValue":"468623","NoteRef":""},{"TypeOfInvestment":"FinAssetsExclFinDeriv","Component":"ChgPosPrice","Frequency":"A","Year":"2005","TimeSeriesId":"TSI_IipFinAssetsExclFinDerivChgPosPrice_A","TimeSeriesDescription":"U.S. assets excluding financial derivatives (Change in position attributable to price changes); annual","TimePeriod":"2005","CL_UNIT":"USD","UNIT_MULT":"6","DataValue":"1079110","NoteRef":""},{"TypeOfInvestment":"FinAssetsExclFinDeriv","Component":"ChgPosPrice","Frequency":"A","Year":"2006","TimeSeriesId":"TSI_IipFinAssetsExclFinDerivChgPosPrice_A","TimeSeriesDescription":"U.S. assets excluding financial derivatives (Change in position attributable to price changes); annual","TimePeriod":"2006","CL_UNIT":"USD","UNIT_MULT":"6","DataValue":"1111577","NoteRef":""},{"TypeOfInvestment":"FinAssetsExclFinDeriv","Component":"ChgPosPrice","Frequency":"A","Year":"2007","TimeSeriesId":"TSI_IipFinAssetsExclFinDerivChgPosPrice_A","TimeSeriesDescription":"U.S. assets excluding financial derivatives (Change in position attributable to price changes); annual","TimePeriod":"2007","CL_UNIT":"USD","UNIT_MULT":"6","DataValue":"559376","NoteRef":""},{"TypeOfInvestment":"FinAssetsExclFinDeriv","Component":"ChgPosPrice","Frequency":"A","Year":"2008","TimeSeriesId":"TSI_IipFinAssetsExclFinDerivChgPosPrice_A","TimeSeriesDescription":"U.S. assets excluding financial derivatives (Change in position attributable to price changes); annual","TimePeriod":"2008","CL_UNIT":"USD","UNIT_MULT":"6","DataValue":"-4329718","NoteRef":""},{"TypeOfInvestment":"FinAssetsExclFinDeriv","Component":"ChgPosPrice","Frequency":"A","Year":"2009","TimeSeriesId":"TSI_IipFinAssetsExclFinDerivChgPosPrice_A","TimeSeriesDescription":"U.S. assets excluding financial derivatives (Change in position attributable to price changes); annual","TimePeriod":"2009","CL_UNIT":"USD","UNIT_MULT":"6","DataValue":"1869617","NoteRef":""},{"TypeOfInvestment":"FinAssetsExclFinDeriv","Component":"ChgPosPrice","Frequency":"A","Year":"2010","TimeSeriesId":"TSI_IipFinAssetsExclFinDerivChgPosPrice_A","TimeSeriesDescription":"U.S. assets excluding financial derivatives (Change in position attributable to price changes); annual","TimePeriod":"2010","CL_UNIT":"USD","UNIT_MULT":"6","DataValue":"891472","NoteRef":""},{"TypeOfInvestment":"FinAssetsExclFinDeriv","Component":"ChgPosPrice","Frequency":"A","Year":"2011","TimeSeriesId":"TSI_IipFinAssetsExclFinDerivChgPosPrice_A","TimeSeriesDescription":"U.S. assets excluding financial derivatives (Change in position attributable to price changes); annual","TimePeriod":"2011","CL_UNIT":"USD","UNIT_MULT":"6","DataValue":"-1259746","NoteRef":""},{"TypeOfInvestment":"FinAssetsExclFinDeriv","Component":"ChgPosPrice","Frequency":"A","Year":"2012","TimeSeriesId":"TSI_IipFinAssetsExclFinDerivChgPosPrice_A","TimeSeriesDescription":"U.S. assets excluding financial derivatives (Change in position attributable to price changes); annual","TimePeriod":"2012","CL_UNIT":"USD","UNIT_MULT":"6","DataValue":"1176447","NoteRef":""},{"TypeOfInvestment":"FinAssetsExclFinDeriv","Component":"ChgPosPrice","Frequency":"A","Year":"2013","TimeSeriesId":"TSI_IipFinAssetsExclFinDerivChgPosPrice_A","TimeSeriesDescription":"U.S. assets excluding financial derivatives (Change in position attributable to price changes); annual","TimePeriod":"2013","CL_UNIT":"USD","UNIT_MULT":"6","DataValue":"1694780","NoteRef":""},{"TypeOfInvestment":"FinAssetsExclFinDeriv","Component":"ChgPosPrice","Frequency":"A","Year":"2014","TimeSeriesId":"TSI_IipFinAssetsExclFinDerivChgPosPrice_A","TimeSeriesDescription":"U.S. assets excluding financial derivatives (Change in position attributable to price changes); annual","TimePeriod":"2014","CL_UNIT":"USD","UNIT_MULT":"6","DataValue":"654662","NoteRef":""},{"TypeOfInvestment":"FinAssetsExclFinDeriv","Component":"ChgPosPrice","Frequency":"A","Year":"2015","TimeSeriesId":"TSI_IipFinAssetsExclFinDerivChgPosPrice_A","TimeSeriesDescription":"U.S. assets excluding financial derivatives (Change in position attributable to price changes); annual","TimePeriod":"2015","CL_UNIT":"USD","UNIT_MULT":"6","DataValue":"193414","NoteRef":""},{"TypeOfInvestment":"FinAssetsExclFinDeriv","Component":"ChgPosPrice","Frequency":"A","Year":"2016","TimeSeriesId":"TSI_IipFinAssetsExclFinDerivChgPosPrice_A","TimeSeriesDescription":"U.S. assets excluding financial derivatives (Change in position attributable to price changes); annual","TimePeriod":"2016","CL_UNIT":"USD","UNIT_MULT":"6","DataValue":"833675","NoteRef":""}]}}
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.