Tuesday, February 5, 2019 at 7:59 AM #122489
I use the XBRL API to download data. Usually, I can only download about 500 lines for 1 or 2 concepts then Google locks me out with this message “Service invoked too many times for one day: properties get.” I don’t do any mass emailing or downloading anything else. The only emailing thing that I do is to forward my personal gmail to my Outlook inbox (I get about 20-30 emails a day).
David Tauriello was kind enough to send me this link that describes the limits of Google, however, not being a technical person, I couldn’t understand how I can have hit the limits with only about 500-600 lines of download using the XBRL API.
Do any of you experience or have knowledge about this issue? Please help. For now, I can’t use XBRL API because of this limitation.
Tuesday, February 5, 2019 at 10:22 AM #122506
Tim – try these steps to resolve the issue:
- log out from the add-on’s authentication menu,
- log out from your Google account,
- clear the browser’s cache,
- close the browser and
- restart the computer.
Tuesday, February 5, 2019 at 10:55 AM #122512
It works, David. I did exactly as you instructed and the API downloads normally.
Thank you again for your help!
You must be logged in to reply to this topic.
Why does XBRL return differing values for same concept and how to address it 2 days, 3 hours ago
Why does XBRL return differing values for same concept and how to address it 2 days, 4 hours ago
Why does XBRL return differing values for same concept and how to address it 2 days, 20 hours ago
Why does XBRL return differing values for same concept and how to address it 2 days, 21 hours ago
Code for publicly traded companies 2 weeks, 6 days ago
XBRL API Resources
- Create a Google Account (without Gmail)
- Install XBRL API Access (Google Sheet Add-on)
- Make a Copy of Google Sheet Templates:
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