Thursday, December 20, 2018 at 10:31 AM #118958Peter GuldbergParticipant
It used to be possible to sort on a field that was not returned, for example like this:
but that no longer seems to be working. If I move the report.id into the fields list it works fine, but then it also gets returned in the query.
Thursday, December 20, 2018 at 12:05 PM #118963David TaurielloKeymaster
I checked with team and there haven’t been any changes that would impact
.sort, which is applied on returned fields per the documentation:
Any value returned can be sorted in ascending or descending order, by adding an additional property to a field value.
Maybe the sort is on one of the
periodfields in the query you posted – ? the BS Compare template uses this:
Thursday, December 20, 2018 at 4:59 PM #118982Peter GuldbergParticipant
All right – maybe it was never meant to work. Basically, the query I posted definitely used to work, but now it doesn’t. However, it’s entirely possible that it was never meant to work.
I think my question here really is: Is there a way to sort the returned fields on a field that is not itself returned?
I agree that the documentation would seem to indicate that you can only sort on fields that are actually returned.
- You must be logged in to reply to this topic.
XBRL API Resources
- The XBRL API
- XBRL Data Community
- XBRL API Interactive Documentation
- XBRL API Documentation (PDF)
- Get Started with Google Sheets
- OR request account provisioning to use Client ID and secret pairs in your app and:
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.
Ready to work with the API in Excel's Power Query, or with your own system or app?
Contact us at firstname.lastname@example.org to have your existing XBRL US Web account provisioned to generate client ID/Secret pairs to work with the XBRL API in a REST client or other application, including Excel's Power Query.
NOTE: You do not need to generate client ID/Secret pairs if you use the Google Add-on and Google Sheet exclusively to access data - the XBRL API Authentication Add-on handles this automatically.
Your account needs to be provisioned before you can login and generate client ID/secret pairs.
Login or register for a free account.
Join XBRL US
- Individual Options - Basic, Power User & Sole Practitioner
- For Your Team - Startup, Non-Profit, Academic & Corporate options
- Member Benefits Comparison Table