Forum Replies Created
I am trying to create/generate the auth token, but I am getting the following error from the https://api.xbrl.us/oauth2/token end point
“error_description”: “Bad Client”
I checked the client ID and secret multiple times.
The following is the raw body (masked client id and secret):
Any assistance would be much appreciated.
Hi Ajit – what are you using to POST – ? – Insomnia, Postman or another testing client, or are you writing code in a language – ?
There are instructions for Insomnia posted at the end of the PDF documentation.
If you’re working in a language, check out the resources for PHP, Python and R linked in the list of free resources on the XBRL Data Community. Briefly, you need to POST body, and encoding to the token URL, then use the access_token as “Bearer $token” with your query.
If you’re still having an issue, post back and share the code you have and language you’re using.
DavidWednesday, September 23, 2020 at 2:47 PM in reply to: Getting started with the XBRL Google Sheet and add-on #186140J CParticipant
Note that this is the same for Safari. If you open it in a new tab, you can authenticate and refreshing the sheet should populate the data.Teji AbrahamParticipant
I have noticed cases where multiple label texts are returned for e.g. if call xbrl api with dts.id=390342 and concept.local-name=OperatingLeaseLiability, two data points are returned for label.text.
How should we handle such cases.
Thanks again, Teji
Thanks David. It works now. The issue was with the username and password
I am trying to obtain the list of Subsidiaries for a company from its 10K filing.
For example, Apples 2019 10K filing is at
And from there, you can navigate to the “Subsidiaries of the Registrant” – which is Exhibit 21.1
Any help on what the API query would be to get this info would be great!
AjTuesday, September 29, 2020 at 9:40 AM in reply to: How to get list of Subsidiaries for a company in a filing #186226
Hi Ajit – we’re finalizing a /document endpoint with text search capability for XBRL US Members that will allow you to get details like this, which are outside of the XBRL facts for the filing.
Once its ready, we’ll be holding a web meeting to cover the basics of search – wildcard options, etc. – as well as show some other tools for data access.Friday, October 2, 2020 at 12:51 PM in reply to: How to get list of Subsidiaries for a company in a filing #186293
Thanks David. Do you have an ETA on when this API would be ready?Tuesday, October 6, 2020 at 10:12 AM in reply to: How to get list of Subsidiaries for a company in a filing #186352
Ajit – it’s in production now – see the document endpoint here for documentation: https://xbrlus.github.io/xbrl-api and note that we’re making some modifications to the query parameters.
Teji – my apologies for the slow reply. The
/relationshipendpoint can help where an element may be used for several facts in a company dts. This endpoint has details related to structuring the facts in the report.
If you return
relationship.preferred-labelfor the concept as ‘relationship.target-name’, you can compare this parameter with
See row 10 of the updated Google SheetArthur OlevskiyParticipant
How can I get data which is not in sec xml files such as risk factors, MD&A and other items with useful textual data?
Wednesday, October 14, 2020 at 9:23 AM in reply to: Risk factors and other items from 10-Q&10-K filings #186478
- This topic was modified 1 week, 3 days ago by Arthur Olevskiy.