Query Using report.event-items Field for 8-K’s

[PX NY]

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.

[David Tauriello]

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.

[Author]

Posts