Home Forums The XBRL API Query Using report.event-items Field for 8-K’s

Viewing 1 reply thread
  • Author
    Posts
    • #197519
      PX NY
      Participant

      During an XBRL.us API webinar hosted summer 2021, the report.event-items field was showcased for querying 8-K’s and their categorized items.

      I’ve used in Excel the sample query from the webinar:

      =XBRL.showData("https://api.xbrl.us/api/v1/fact/search?<strong>report.event-items=5.02</strong>&fields=report.entity-name,report.event-items,report.filing-date,report.sec-url,report.limit(15)")

      It returns a #VALUE error, even with just one field to report.

      Is the report.event-items query field currently activated for searches via Excel or Google Sheets?

      Thanks.

    • #197973
      David Tauriello
      Keymaster

      Hi PX NY – sorry for the delay in responding; report.event-items works with searches on the /report endpoint:

      /report/search?entity.cik=0000037996&report.document-type=8-K, 8-K/A&fields=report.document-type,report.entity-name,report.event-items,report.sec-url

      One change from the webinar is that you cannot query for a specific event type – you’ll need to use entity, or SIC Code or other report filter parameter.

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