Skip to main content
A JSON Table is a collection of tabular data structured into one or more pages of JSON arrays, imported into the MindBridge platform. Each array consists of objects, where for each object, the keys represent column headers and their associated values represent the data for that column. Data must be uploaded sequentially, one page at a time, as concurrent page uploads are not supported. Once all data has been appended to the JSON Table, a file manager file can be created using the file manager’s Import From JSON Table endpoint, which merges all the parts into a concatenated CSV file. The headers in the resulting file are based on those specified in the JSON Table, and the order of the headers will correspond to the sequence in which each unique header appears in the source data. For example, given the following two pages of JSON Table data: 
[
  {
    "Account": "First Account",
    "Amount": "10.11$",
    "Date": "2020-01-01"
  },
  {
    "Account": "Second Account",
    "Amount": "89.99$",
    "Date": "2020-01-02"
  }
]

[
  {
    "Account": "Third Account",
    "Amount": "33.31$",
    "Date": "2020-01-03"
  },
  {
    "Account": "Fourth Account",
    "Amount": "10.11$",
    "Memo": "My Memo"
  }
]
The resulting CSV file would be the following: 
"Account","Amount","Date","Memo"
"First Account","10.11$","2020-01-01",""
"Second Account","89.99$","2020-01-02",""
"Third Account","33.31$","2020-01-03",""
"Fourth Account","10.11$","","My Memo"

​
JSON Table entities cleanup

JSON Table entities that are more than 7 days old will be deleted. To avoid data loss, ensure that all JSON Table entries are imported as file manager files once all the data has been imported.