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