Home Forums The XBRL API Questions – 12/12/18 webinar

Viewing 2 reply threads
  • Author
    Posts
    • #118639
      David Tauriello
      Keymaster

      There were several questions we didn’t answer completely from this week’s webinar:

    • #118640
      David Tauriello
      Keymaster

      Do you provide any historical trace for deprecated concepts? Could we trace the lineage of a concept between taxonomies using the API?

      You could use the dts for approved base taxonomies (US GAAP, IFRS) to query concepts and look for ‘Deprecated’ in the label … something like:

      /concept/search?dts.id=257581,257584,257585,257586,257587,257588,257589,257590,292503&concept.local-name=ResaleAgreementsMaturities&fields=dts.id.sort(ASC),concept.local-name,concept.namespace,label.*

      If you do this for the example, you’ll see the element was deprcated as of 2016 US GAAP. This is not particularly effective, though, and in addition, FASB has moved the notation for deprecated concepts from the label to a reference, so the detail exists in two places.

      We’ve got plans to implement string search in a couple of areas and these will be included (thanks for a great suggestion), so a query on ‘deprecat’ will pull only those values.

    • #118962
      David Tauriello
      Keymaster

      Is there a way to go back from the data received through the API to the actual human-readable SEC filings where the data come from, to quickly double check the data for example?

      On the webinar, we mentioned that you can use report.sec-url from the report endpoint to return the URL to the SEC index page for the filing. You can also use report.entry-url for the location of the instance (facts) for the filing.

      Further – if you combine the report.entry-url with the fact.xml-id you have a citation to the location of the fact within the instance (NOTE: not all facts have a corresponding xml id in EDGAR).

      https://api.xbrl.us/api/v1/fact/search?entity.cik=0000320193&period.fiscal-year=2018&concept.local-name=AccumulatedOtherComprehensiveIncomeLossNetOfTax&report.type=10-K&fact.has-dimensions=false&concept.is-monetary=true&fields=report.entry-url,fact.xml-id,fact.value,concept.local-name.sort(ASC)

      If you open the report.entry-url in a browser and use ‘find in page’ to search on the fact.xml-id value, it will bring you to the AOCI value.

Viewing 2 reply threads
  • You must be logged in to reply to this topic.

Upcoming XBRL US Events

Domain Steering Committee Meeting
Tuesday, April 16, 2024

Communications & Services Steering Committee Meeting
Tuesday, April 16, 2024

Webinar: SEC Rule – Tailored Shareholder Reports for Mutual Funds and ETFs
Wednesday, May 15, 2024