Home › Forums › The XBRL API › FERC Data
- This topic has 9 replies, 4 voices, and was last updated 2 years, 6 months ago by David Tauriello.
-
AuthorPosts
-
-
Tuesday, February 1, 2022 at 3:51 PM #197486Trevor CarleyParticipant
When is FERC Form 1 and 3 data expected in the API?
-
Thursday, February 17, 2022 at 2:25 PM #197904David TaurielloKeymaster
Hi Trevor – thanks for writing and apologies for the delay in responding. We’re nearly complete in our testing and expect to start loading this data set in our database in the coming weeks.
-
Tuesday, April 26, 2022 at 6:22 PM #200379Dorin IACOBParticipant
Hi David,
Do you have an update on the FERC database? Trying the FERC API on xbrlus.github.io/ferc-api gives a “failed to fetch”
Auth Error
. Also, is data from the Form №714 available, too?Thanks!
- This reply was modified 2 years, 6 months ago by Dorin IACOB. Reason: changed data to database
-
Wednesday, April 27, 2022 at 4:26 PM #200412Dorin IACOBParticipant
I think the reason for my authentication failure stems from the fact that the GitHub code is running on the
uast.eForms.FERC.gov
server. However, using xBRL US’ domainAPI.xBRL.us
in theR
code from the XBRL Data Community presents no such problems and responds to queries for data. This answers my questions.Best!
-
Wednesday, May 4, 2022 at 3:41 PM #200557Patrick BaryenbruchParticipant
Hi David,
I am unable to retrieve data using the simple-statement-disclosure template. Here are the steps I took:
1.Successfully logged in.
2.Selected “fact” as the function
3.Selected an entity and its form 60 (e.g., 464990)
4.Put that number in cell J3 of the template and selected a schedule from the pull down menu in cell N3 (e.g., 017 – Schedule – Analysis of Billing – Associated Cos.)
5.Hit Query Worksheet
6.No data appears and the error message says “ERROR: Change N3 value or reload the XBRL Filed Data task pane”On another matter, 2021 Form 1 and Form 60 files are available on FERC’s website in the XBRL (and HTML) format. Is there a way to simply read these files into the template to make the process easier? Perhaps Arelle can do this. I do not need the absolutely latest/updated version of the Forms–I just need to get the data at a point in time.
Thank you.
-
Wednesday, May 4, 2022 at 4:01 PM #200559David TaurielloKeymaster
Hi Patrick –
Please make sure you’ve un-checked the ‘Show all SEC Statements’ checkbox on the template – this is just below the N3 dropdown. This template is optimized for the extensibility of SEC filings – it will not show an entire Form 1.
I sent you a separate (simpler) template yesterday afternoon for Form 1 Balance Sheet. It can be updated to pull entire reports if that’s needed – let me know.
-
Wednesday, May 4, 2022 at 4:30 PM #200562Patrick BaryenbruchParticipant
David,
Thank you for BS template–I did not notice it in your previous email. This is a useful format. I need data from a few Form 1 and Form 60 schedules for a single year. Your template seems to just pull the BS. Is there a way to expand the template so specific Form 1 and Form 60 schedules can be selected?
Thank you.
-
Wednesday, May 4, 2022 at 4:41 PM #200563Patrick BaryenbruchParticipant
David,
I see the query is built by populating the Fields to Return box. If you have a definition of the elements that can be selected for the query, I think I can build my own templates. Would you send me the definitions if you have them?
Thank you.
-
-
Wednesday, May 4, 2022 at 4:01 PM #200560Patrick BaryenbruchParticipant
David,
Just figured out the issue described in my previous post. I needed to uncheck the box for “Show All SEC Statements”. The template then returned data. Unfortunately, the data is not the complete values for some schedules. For instance, 017 – Schedule- Analysis of Billing – Assoc Cos. is supposed to show charges by the Form 60 service company to each affiliate legal entity. The data that is returned is only the total without a breakout by affiliate.
Any thoughts on this issue? Thank you.
-
Wednesday, May 4, 2022 at 6:30 PM #200564David TaurielloKeymaster
Hi Patrick – please check your email.
-
-
-
AuthorPosts
- You must be logged in to reply to this topic.
Search Forums
Recent Topics
Recent Replies
-
Spreadsheet Commands: Query Worksheet and Query Workbook Query Workbook 2 weeks, 3 days ago
-
Query for multiple dimensions 2 months, 2 weeks ago
-
Query for multiple dimensions 2 months, 2 weeks ago
-
Showdata function 5 months ago
-
Showdata function 5 months, 1 week ago
Documentation & Discussion
- Get started with Google Sheets OR
- Get started with Microsoft Excel OR
- Get access to as-filed data from us for other tools or your own app
- XBRL API Interactive Documentation
- Ten Tips & Techniques
- The XBRL API
- XBRL Data Community
- 2024 US GAAP Taxonomy Viewer
- Live support - Monday, 3:30 - 4:30 PM ET
Who's using this free data?
API Use 2024 || API Use 2023 || API Use 2022 || API Use 2021 || API Use 2020 || API Use 2019 || API Use 2018
Join XBRL US
- Individual Options - Basic, Power User & Sole Practitioner
- For Your Team - Startup, Non-Profit, Academic & Corporate options
- Member Benefits Comparison Table
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.
To use the XBRL API outside of Google Sheets, your account needs to be provisioned for OAuth2 access.