Home Forums The XBRL API Repeating facts from different documents

Viewing 3 reply threads
  • Author
    • #201030
      Timur Mirzaev

      Some facts are repeating when extracting several documents in a single call. I can see the reason (tag/concept change), but don’t know the solution. Is there any way to remove those duplicating values, but keep the two tags/concepts in a query?

      Here is my API call with row 2 and 3 being similar:


    • #201041
      Timur Mirzaev

      Just a little update: Missed part of my query that refers to a named range “CIK”.
      In this very case it should stand for “0000789019” (for MSFT).

    • #201056
      David Tauriello

      Hi Timur – thanks for writing. I’m not sure what additional parameter you’re using from C6 on the Legend worksheet (?). If I remove that and update ‘fiscal’ to be the parameter ‘period.fiscal-period’ I don’t see any duplication:


      Drop the query in A1, and use =XBRL.showData(A1,””,””,”1″) in A2

      Let me know if there’s something else I’m missing.

    • #201080
      Timur Mirzaev

      Hi, David!

      Thank you very much for your reply. I forgot to fully correct my query for named ranges, hence the error.
      But your correction is exactly what my query should have looked like. I have done exactly what you showed above and I DO get duplicating values – see D4 and D5 of the output (if xbrl.showData is in A2), which is $17,236,000,000 for 3Q of FY’2021.

      So my question here is whether it is possible to introduce any parameter that would remove those duplicates (sort of a “unique” function maybe, but on the query level so that the per query limit is not effected that much).


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

Upcoming XBRL US Events

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

Domain Steering Committee Meeting
Tuesday, May 21, 2024

Communications & Services Steering Committee Meeting
Tuesday, May 21, 2024

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