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

      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

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