Home Forums The XBRL API Get recents fact values

Viewing 1 reply thread
  • Author
    Posts
    • #192506
      Arthur Olevskiy
      Participant

      Hi David,

      Thank you for your assistance here. It really helps to move forward in building the app.

      So, I came with question. How to get most recent fat value? I’m trying to use ultimus and ultimus-index, but sometimes I still getting not recent value of report facts.

      Here is my path to get fact values.
      1. Firstly, of all I’m collecting reports for specific CIK.
      2. Secondly, using report.id and api /api/v1/report/{report.id}/fact/search I’m collecting facts of report. Here is my query, I will skip fields part:
      10-Q https://api.xbrl.us/api/v1/report/333770/fact/search?fact.ultimus=true
      10-K https://api.xbrl.us/api/v1/report/323207/fact/search?fact.ultimus=true
      In these two examples I’m using ultimus, however I’m still getting not recent values and those values also has ultimus-index = 1

      Is there a better way to get recent fact values for specific report?
      How can I get fiscal year for report object, so I can compare report fiscal year and fact fiscal year)

      Thanks in advance for all answers.
      Arthur

    • #197963
      David Tauriello
      Keymaster

      Hi Arthur – first, apologies for the delay in responding – this post was flagged in our system (probably because it includes ‘https://’

      The fact.ultimus parameter is used on the /fact endpoint. When you specify a /report, you will return all facts in the report without regard to fact.ultimus.

      Use your /report query to return the dts.id value for the report, then use a separate /fact query to show fact.ultimus-index detail.

      /fact/search?dts.id=428275&fact.ultimus=false&fact.has-dimensions=false&fields=entity.id,report.id,concept.local-name,fact.value,fact.ultimus-index,period.fiscal-period,period.fiscal-year.sort(DESC)

      In the query above, IntangibleAssetsNetExcludingGoodwill for the year 2020 was reported several more times:

      /fact/search?entity.id=6252&concept.local-name=IntangibleAssetsNetExcludingGoodwill&fact.has-dimensions=false&period.fiscal-period=Y&period.fiscal-year=2020&fields=concept.local-name,fact.numerical-value,fact.ultimus-index.sort(DESC),report.id,period.fiscal-period,period.fiscal-year

      Let me know if you have additional questions about this.

Viewing 1 reply thread
  • You must be logged in to reply to this topic.

Comment

Upcoming XBRL US Events

Center for Data Quality Committee Meeting
Wednesday, June 29, 2022

Domain Steering Committee Meeting
Tuesday, July 19, 2022

Communications & Services Steering Committee Meeting
Tuesday, July 19, 2022

Dive into Debt Securities – Illustrations of the FASB Implementation Guide
Wednesday, July 20, 2022

Public Review: Annual Comprehensive Financial Report Taxonomy
Monday, August 15, 2022