Home › Forums › The XBRL API › Is there a way to achieve logical text filters such as "contains"?
Tagged: template
- This topic has 1 reply, 2 voices, and was last updated 2 years, 3 months ago by
David Tauriello.
-
AuthorPosts
-
-
Thursday, September 27, 2018 at 12:59 AM #111972
Revathy Ramanan
ParticipantIs 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” -
Monday, October 1, 2018 at 10:52 AM #112159
David Tauriello
KeymasterHi 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)
-
-
AuthorPosts
- You must be logged in to reply to this topic.
Search Forums
Recent Topics
Recent Replies
-
Get Balance Sheet with single API call 3 days, 10 hours ago
-
oauth2 Not Giving Access Token 3 days, 21 hours ago
-
Missing Data – Costco Wholesale Corp 2 weeks, 3 days ago
-
Missing Data – Costco Wholesale Corp 2 weeks, 6 days ago
-
Tackling issues with operating lease data 1 month ago
XBRL API Resources
- The XBRL API
- XBRL Data Community
- XBRL API Interactive Documentation
- XBRL API Documentation (PDF)
- Get Started with Google Sheets
- Create a Google Account (without Gmail)
- Install XBRL API Access (Google Sheet Add-on) (troubleshooting access)
- Make a Copy... of Google Sheet Templates
- OR get access to data for your own app and/or our API Tools
Who's using this free data?
API Use 2020 || API Use 2019
API Use 2018
Join XBRL US
- Individual Options - Basic, Power User & Sole Practitioner
- For Your Team - Startup, Non-Profit, Academic & Corporate options
- Member Benefits Comparison Table
Using the XBRL API with the Public Filings Database
Unless otherwise agreed to in writing, any and all use of the XBRL API to authenticate and retrieve data from the XBRL US Database of Public Filings implies user consent and agreement with the XBRL US API Agreement. If you are unable to agree to these terms, do not use the XBRL API.
Your account needs to be provisioned before you can login and generate client ID/secret pairs.
Login or register for a free account.
XBRL Data Events
In the Last Year:
Upcoming XBRL US Events




Comment
You must be logged in to post a comment.