XBRL.showData(url, type, fieldname, showheaders)

In addition to the required url parameter, the custom function =XBRL.showData() includes three optional parameters to display facets of the information queried:

XBRL.showData(url, type, fieldname, showheaders)

  • url [required string]: The url of the api call that's to be called
  • type [optional string] (blank|fields|name): Determines how the information will be returned
       blank: 'data' without the metadata,
       fields: a tree of the fields in the data array,
       name: with a 'fieldname' to filter on information for the specified field
  • fieldname [optional string]: with name as above - different levels are separated by a '/'
  • showheaders [optional boolean]: toggle column header display for the output