Is there a way to achieve logical text filters such as "contains"?

[Revathy Ramanan]

Is there an alternative way to write API queries which in turn uses the following conditions

concept.local-name contains “FairValue”
dimension.namespace is not equal to “http://xbrl.ifrs.org/taxonomy/2017-03-09/ifrs-full”

[David Tauriello]

Hi Revathy – this is a great question. The API itself won’t do this (right now?), but if you retrieve data into a Google Sheet, you can apply a filter over the return and use the spreadsheet filtering (see the BScompare tab of the XBRL Spreadsheet for an example of this at cells F23:J23)

[Author]

Posts