JSON (JavaScript Object Notation) is our most commonly used format. JSON is a text-based open standard derived from the format used to represent simple data structures in JavaScript. Although it is rooted in JavaScript, it is language-agnostic and parsers exist for all popular (and many unpopular) languages.
When JSON is specified as the format, the response will be a JSON array, where each element in the array is a result. The key will be the column’s field name
and the value will be the result. Fields with null
values are omitted. For example:
[ {
"position" : "Member",
"agency_website" : "SSAB (https://www.ssab.gov)",
"name" : "Aaron, Henry Jacob",
"nomination_date" : "2011-02-14T00:00:00.000",
"agency_name" : "Social Security Advisory Board"
}, {
"position" : "Member",
"confirmed" : true,
"agency_website" : "EOP-CEA (https://www.whitehouse.gov/administration/eop/cea)",
"name" : "Abraham, Katharine",
"confirmation_vote" : "2011-04-14T00:00:00.000",
"nomination_date" : "2011-01-26T00:00:00.000",
"agency_name" : "Council of Economic Advisers"
} ]
The format is designed to be easily human-readable, and should also be immediately parsable by all common JSON parsers.
Details on how data is encoded are described in the documentation for each datatype.