Tagged: Limit Exceeded
Saturday, December 22, 2018 at 5:34 PM #119077
Is there any way to increase the limit of the length on the code?
When I try to standardize a concept that is composed of more than 4 other concepts, I get an error “Limit Exceeded: URLFetch URL Length. (line 106)”
For example, if I want to have a standardized Selling, Gen & Admin Expenses (SGA_Tot) from these concepts below, I receive an error:
Saturday, December 22, 2018 at 5:55 PM #119078
So far to get around the RL Length, I break the code into 2 and do the summation in Excel.
SGA2: GeneralAndAdministrativeExpenseAndOtherOperatingExpenses, OtherSellingGeneralAndAdministrativeExpense, SellingAndMarketingExpense
My question: is there a way to add the results of 2 or more concepts within an API code? This would help to reduce the number of calls.
Monday, December 24, 2018 at 7:29 AM #119121
Tim – thanks for posting back with your solution to the issue in the initial post.
The message ‘Limit Exceeded: URLFetch URL Length.’ is a Google Services error (https://developers.google.com/apps-script/guides/services/quotas). According to the page, there’s a 2kB limit (about 2,000 characters).
Some things to try:
- restructure the query to eliminate any unnecessary filters/screens and/or fields returned (maybe there’s a more efficient way to call for the data you need)
- try a URL shortener (bit.ly is one such service) – I don’t have any experience with this, but it may be worthwhile if it works
You must be logged in to reply to this topic.
CIK and Ticker 1 week, 6 days ago
Extracting Data From A Particular Financial Statement 2 weeks, 3 days ago
Missing years 1 month ago
Period details for facts 1 month, 3 weeks ago
Extracting Data From A Particular Financial Statement 1 month, 3 weeks ago
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 email@example.com 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