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.

Upcoming XBRL US Events

FDTA: Entity and Security Identifiers
Thursday, March 28, 2024

Domain Steering Committee Meeting
Tuesday, April 16, 2024

Communications & Services Steering Committee Meeting
Tuesday, April 16, 2024

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