For some reason, my query, which used to work just fine (arguably, before the recent add-in update), now shows the “Calc!” error. What is even more unusual is that in a split of a second I can actually see the data appearing before being superseded by this very error.
Apparently, this error can be replicated by having the full code written as a formula [ with references to other cells having, say, ‘fact endpoint’ and ‘textjoin(“,”, TRUE, concept name) formula for concept unification], while the XBRL.showData () is used separately to refer to that formula.
Interestingly, if one “kills” the formula, so that the code is just a plain text, the error is gone, and data is extracted.
I would very much appreciate any help around this issue.
Using the XBRL API with the Public Filings Database
Unless otherwise agreed to in writing, any and all use of the XBRL API to authenticate and retrieve data from the XBRL US Database of Public Filings implies user consent and agreement with the XBRL US API Agreement. If you are unable to agree to these terms, do not use the XBRL API.
To use the XBRL API outside of Google Sheets, your account needs to be provisioned for OAuth2 access.
The national consortium for the business reporting standard
XBRL US is a not-for-profit organization supporting the implementation of digital business reporting standards through the development of taxonomies for use by U.S. public and private sectors, with a goal of interoperability between sectors, and by promoting XBRL adoption through marketplace collaboration.