Thursday, November 1, 2018 at 3:48 PM #114886
There is a possibility to know how much property my request has
I want to import all
concept.local-namebut there are more than 100
I think the
offsetdoes not work well if I understand correctly what it is supposed to do
Friday, November 2, 2018 at 11:40 AM #115006
ENDPOINT.offset(INTEGER)as part of fields returns additional records not displayed by in the initial set (see 7 Handling Paging in the XBRL API Documentation for complete details).
- Company and Institutional Members, as well as Sole Practitioner and Power User Individual Members can return unlimited results with 2,000 records per paged request.
- Basic Individual Members can return a maximum of 2,000 records with 500 records per page (4 pages).
- non-Members can return 1,000 records with 100 records per page (10 pages)
See https://xbrl.us/benefits for details and let me know if you have questions about XBRL US Membership.
Saturday, November 3, 2018 at 1:06 PM #115155
Funny but if you use this way
It does not work well with
But use the way
But how can I know how much fields or offset There is in my request
I’m working on Add on
And I do not really know if the user has a Member or not
But I do need to know how I bring him all the information he can get
I do not want to use the
And check when I stop getting results In order to should know this is the end
It’s less Api friendly
Sorry for my English
Tuesday, November 6, 2018 at 4:49 PM #115682
Thanks for your feedback on counts – I’ve noted this as a feature request. As you’ve discovered, sorting on
concept.balance-typeis likely not reliable because the return will either be debit or credit. Using the sort switch on a field that will always have unique values for each row returned ensures the
ENDPOINT.offset()works as expected.
Anyone using the XBRL API to return records from our Database of Public Filings will need to be authenticated (either through XBRL US or with a Google Account) – we use this to set maximums per page and for all pages returned to a user. See https://xbrl.us/benefits for details and let me know if you have questions about XBRL US Membership.
Tuesday, November 6, 2018 at 5:42 PM #115701
Ok I just let the user enter their password and username and Api codes
But I still do not understand how I can know how much fields or offset There in the request
If the user is not a member
So he can only see 100 fields
But can be for example 231 fields How can I know how many there are?
For example type of command
Then I can know how many requests I have to make
To import all information
Tuesday, November 6, 2018 at 6:47 PM #115716
I realized there was no way right now
And that you write it down for future development
This is really important for the development of external applications
You must be logged in to reply to this topic.
XBRL API Resources
- The XBRL API
- XBRL Data Community
- XBRL API Documentation (PDF)
- Get Data with Google Sheets
- Sample Queries (Insomina REST client) - requires account provision
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