[david.tauriello@xbrl.us]

Hi Arthur – we’re not a good resource for this data, which is created via a web form on the SEC’s site, and available as .xml

[Angelo Brizi]

1)
/api/v1/fact/search?concept.local-name=RevenueFromContractWithCustomerExcludingAssessedTax&period.fiscal-year=2019&period.fiscal-period=Y&entity.cik=0000909832&fact.ultimus=true&fact.has-dimensions=false&fields=fact.value

returns 152703000000

This is the 10-K filed on 2019-10-11 but the returned revenues are for the 12 months not the 3 months. The 10K reports 152703 (like the API) for the 12 months but only 34740 for the 3 months. How do I get the data for the 3 months (which should be 34740)?

2)
api/v1/fact/search?concept.local-name=RevenueFromContractWithCustomerExcludingAssessedTax&period.fiscal-year=2020&period.fiscal-period=1Q&entity.cik=0000909832&fact.ultimus=true&fact.has-dimensions=false&fields=fact.value

This correctly represents the Revenues for the filings 10Q on 2019-12-23. No issues here

3)
api/v1/fact/search?concept.local-name=RevenueFromContractWithCustomerExcludingAssessedTax&period.fiscal-year=2020&period.fiscal-period=2Q&entity.cik=0000909832&fact.ultimus=true&fact.has-dimensions=false&fields=fact.value

This is the 10Q filed on 2020-03-12 and it’s missing. Revenues should be 39072000000 but returned value is null

4)
api/v1/fact/search?concept.local-name=RevenueFromContractWithCustomerExcludingAssessedTax&period.fiscal-year=2020&period.fiscal-period=3Q&entity.cik=0000909832&fact.ultimus=true&fact.has-dimensions=false&fields=fact.value

This is the 10Q filed on 2020-06-04 and it’s missing. Revenues should be 37266000000 but returned value is null

Also data for 2019 2Q and 2019 3Q are missing.

[Arthur Olevskiy]

Hi Angelo,

I can help you with first issue. In your request, you specified “period.fiscal-period=Y” which is means 12 month. If you want get 3 quarters you can put following values: Y, 1Q, 2Q, 3Q, 4Q, 3QCUM, 1H, 2H. It depends on accounting data type if it is “duration” you need to put 3QCUM if data published “as for some date” you can put 3Q.

[Arthur Olevskiy]

As for me, it is better to get list of fact.id for specific filing and put it in request to get values.

[Arthur Olevskiy]

.

• This reply was modified 3 years, 8 months ago by Arthur Olevskiy.
• This reply was modified 3 years, 8 months ago by Arthur Olevskiy.

[Angelo Brizi]

Hi Arthur,
thanks a lot for your feedback. How do you get the list of fact.id for the specific filing?

For 2Q 2019, using either 2Q or 1H the query returns no data

api/v1/fact/search?concept.local-name=RevenueFromContractWithCustomerExcludingAssessedTax&period.fiscal-year=2019&period.fiscal-period=2Q,1H&entity.cik=0000909832&fact.ultimus=true&fact.has-dimensions=false&fields=fact.value

Same thing for 3Q 2019, using either 3Q or 3QCUM no data

api/v1/fact/search?concept.local-name=RevenueFromContractWithCustomerExcludingAssessedTax&period.fiscal-year=2019&period.fiscal-period=3Q,3QCUM&entity.cik=0000909832&fact.ultimus=true&fact.has-dimensions=false&fields=fact.value

or for 2Q 2020, using either 2Q or 1H still no data

api/v1/fact/search?concept.local-name=RevenueFromContractWithCustomerExcludingAssessedTax&period.fiscal-year=2020&period.fiscal-period=2Q,1H&entity.cik=0000909832&fact.ultimus=true&fact.has-dimensions=false&fields=fact.value

Thanks again.

[Arthur Olevskiy]

Hi Angelo,

I use this link
api/v1/relationship/tree/search?dts.id={dts_id}&network.link-name=calculationLink,presentationLink&format=flat&fields=relationship.target-datatype,relationship.target-concept-id,network.role-description.sort(ASC)

Also, you can play with requests in documentation (https://xbrlus.github.io/xbrl-api)

[Arthur Olevskiy]

Then, you can get relationship.target-concept-id value and make following request

https://api.xbrl.us/api/v1/fact/search?concept.id=&dimension.is-base=false&dts.id={dts_id}&fact.ultimus-index=1&period.fiscal-period=&period.fiscal-year=&fields=fact.value,fact.inline-display-value,concept.local-name

concept.id same as relationship.target-concept-id. I put list of ids, fiscal period and fiscal year period to request’s params

[Angelo Brizi]

Thanks a lot Arthur

[Hasnain jaffery]

Hello,
where can I find the exact label match for the number reported in 10-K or any field report. For example Apple 10-K year 2019 there are 29 entries marked as “MarketableSecuritiesCurrent” in fact table. I can match the numbers in 10-K as well but I am not able to locate the exact screen match label for these numbers anywhere. Can anyone help me on this…?

[david.tauriello@xbrl.us]

Hi Angelo – On your question about why you’re unable to return fact.value data for 2Q, 3Q or 3QCUM, it is because when we load the data, our process includes an algorithm to determine period.fiscal-period, based on a common reporting calendar framework with some flexibility for start/end dates and industry sector. Unfortunately, Costco’s timings don’t quite fit this expectation and as a result, we report the range as YYYY-MM-DD – YYYY-MM-DD.

api/v1/fact/search?concept.local-name=RevenueFromContractWithCustomerExcludingAssessedTax&entity.cik=0000909832&fact.ultimus=true&fact.has-dimensions=false&fields=fact.value,period.fiscal-period,entity.name,report.filing-date.sort(DESC)

I’ve raised this issue with the team and we’re looking at ways to address this as we process the data from the SEC. Check out this thread for a bit more discussion on fiscal v. calendar periods in the XBRL API: https://xbrl.us/forums/topic/reports-and-periods/#post-115421.

[Angelo Brizi]

Hi David, thanks a lot for your explanation. That was very helpful.

[david.tauriello@xbrl.us]

Hi Hasnain,

Pass the dts.id and concept.local-name for the fact to the /label endpoint to get the presentation-side text that corresponds to the value.

There’s a Google Sheet sample posted in this reply that might be helpful – https://xbrl.us/forums/topic/tackling-issues-with-operating-lease-data/#post-185320.

[morjanah]

I could not get to work on Firefox

[david.tauriello@xbrl.us]

Morjanah – please review the instructions at the top of this post, and try installing the add-on to your Google Account using the Chrome web browser first, before moving to Firefox.

[Author]

Posts