{"id":238,"date":"2013-08-27T16:20:02","date_gmt":"2013-08-27T16:20:02","guid":{"rendered":"http:\/\/www.datadocs.org\/beta\/?p=238"},"modified":"2013-08-27T16:20:02","modified_gmt":"2013-08-27T16:20:02","slug":"freds-new-data-format-friend-json","status":"publish","type":"post","link":"http:\/\/www.datadocs.org\/beta\/freds-new-data-format-friend-json\/","title":{"rendered":"FRED’s new (data-format) friend, JSON"},"content":{"rendered":"

It’s probably clear by now that we here at Data Docs have a lot of love for AL\/FRED<\/a>, the vast web-<\/a> and API-accessible<\/a> economic data repository run by the St. Louis Fed<\/a>. <\/p>\n

It is fair to say, though, that we never loved all parts of AL\/FRED equally; while the thoroughness, timeliness, and accuracy of its data have always been outstanding, the XML format in which that data was delivered was better suited suited to an earlier, less JavaScript-driven internet. It was a relatively small price to pay, but accessing AL\/FRED API data in a JavaScript application meant always having to write the descriptive but tiresome (and verbose) getElementsByTagName()<\/span> commands in your code in order to use the AL\/FRED data. Always, that is, until a week ago Monday<\/a>.
\nData Docs is proud to be an early user of the AL\/FRED API’s JSON format, which can be accessed by simply adding file_type=json<\/span> to any API call. <\/p>\n

Introducing JSON<\/h4>\n

So let’s say your original API call looks something like the below (for a complete guide to AL\/FRED, see our previous blog post<\/a>):
\n<\/p>\n

http:\/\/api.stlouisfed.org\/fred\/series\/observations?series_id=PAYEMS\r\n&observation_start=2013-01-01&units=chg&api_key=xxxxxxxxxxxxxxxxxx<\/pre>\n
Without the new file_type<\/span> parameter, the above query will return the monthly non-farm payrolls figures from January, 2013 until the present in an XML format, with the first element describing the data you’ve asked for, and each of the next containing one month’s reading, like so:
\n<\/p>\n
<?xml version="1.0" encoding="utf-8" ?>\r\n<observations realtime_start="2013-08-27" realtime_end="2013-08-27" \r\nobservation_start="2013-01-01" observation_end="9999-12-31" units="chg"\r\noutput_type="1" file_type="xml"<\/span>\r\norder_by="observation_date" sort_order="asc"count="7" offset="0" limit="100000">\r\n\r\n<observation realtime_start="2013-08-27" realtime_end="2013-08-27" \r\ndate="2013-01-01" value="148"\/>\r\n.\r\n.\r\n.\r\n<observation realtime_start="2013-08-27" realtime_end="2013-08-27"\r\ndate="2013-07-01" value="162"\/>\r\n\r\n<\/observations><\/pre>\n
\nJust by adding the new file_type=json<\/span> parameter and value anywhere in the original query, however, we get essentially the same data structure in a handy JSON format. So the query becomes:
\n<\/p>\n
http:\/\/api.stlouisfed.org\/fred\/series\/observations?series_id=PAYEMS\r\n&observation_start=2013-01-01&units=chg&file_type=json<\/span>&api_key=xxxxxxxxxxxxxxxxxx<\/pre>\n
\nAnd the result becomes:<\/p>\n
\r\n{\r\n    \"realtime_start\": \"2013-08-27\",\r\n    \"realtime_end\": \"2013-08-27\",\r\n    \"observation_start\": \"2013-01-01\",\r\n    \"observation_end\": \"9999-12-31\",\r\n    \"units\": \"chg\",\r\n    \"output_type\": 1,\r\n    \"file_type\": \"json\",<\/span>\r\n    \"order_by\": \"observation_date\",\r\n    \"sort_order\": \"asc\",\r\n    \"count\": 7,\r\n    \"offset\": 0,\r\n    \"limit\": 100000,\r\n    \"observations\": [\r\n        {\r\n            \"realtime_start\": \"2013-08-27\",\r\n            \"realtime_end\": \"2013-08-27\",\r\n            \"date\": \"2013-01-01\",\r\n            \"value\": \"148\"\r\n        },\r\n.\r\n.\r\n.\r\n        {\r\n            \"realtime_start\": \"2013-08-27\",\r\n            \"realtime_end\": \"2013-08-27\",\r\n            \"date\": \"2013-07-01\",\r\n            \"value\": \"162\"\r\n        }\r\n    ]\r\n}\r\n<\/pre>\n
<\/p>\n
Curly Braces instead of Carrots – So What?<\/h4>\n
If you’re not a JavaScript developer, the difference between the two result sets above probably doesn’t seem that thrilling. Thanks to good formatting (hat tip to the essential  JSON validation-and-reformat site, jsonlint.org<\/a>), you might possibly have found the second result set a bit easier to read. <\/p>\n
The big deal is that JSON (which not-coincidentally stands for J<\/span>avaS<\/span>cript O<\/span>bject N<\/span>otation) is infinitely<\/em> easier for JavaScript<\/em> to read, too, meaning programmers have to write less code in order to use data in this format. <\/p>\n
So, for example, while using the observations from the XML-formatted results would mean writing out data.getElementsByTagName(“observations”)<\/span>, the same information can be accessed from the JSON format simply by writing data.observations<\/span>. And as anyone who’s every texted “Trying 2 reach u” knows, saving even a handful of characters can really add up.<\/p>\n","protected":false},"excerpt":{"rendered":"
It’s probably clear by now that we here at Data Docs have a lot of love for AL\/FRED, the vast web- and API-accessible economic data repository run by the St. Louis Fed. It is fair to say, though, that we never loved all parts of AL\/FRED equally; while the thoroughness, timeliness, and accuracy of its […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/www.datadocs.org\/beta\/wp-json\/wp\/v2\/posts\/238"}],"collection":[{"href":"http:\/\/www.datadocs.org\/beta\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.datadocs.org\/beta\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.datadocs.org\/beta\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.datadocs.org\/beta\/wp-json\/wp\/v2\/comments?post=238"}],"version-history":[{"count":10,"href":"http:\/\/www.datadocs.org\/beta\/wp-json\/wp\/v2\/posts\/238\/revisions"}],"predecessor-version":[{"id":262,"href":"http:\/\/www.datadocs.org\/beta\/wp-json\/wp\/v2\/posts\/238\/revisions\/262"}],"wp:attachment":[{"href":"http:\/\/www.datadocs.org\/beta\/wp-json\/wp\/v2\/media?parent=238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.datadocs.org\/beta\/wp-json\/wp\/v2\/categories?post=238"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.datadocs.org\/beta\/wp-json\/wp\/v2\/tags?post=238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}