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

      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.

Upcoming XBRL US Events

Domain Steering Committee Meeting
Tuesday, June 18, 2024

Communications & Services Steering Committee Meeting
Tuesday, June 18, 2024

Center for Data Quality Committee Meeting
Thursday, June 27, 2024

GovFin 2024: Municipal Reporting Workshop
Tuesday, July 30, 2024