Hi,
When I tried to get filing data with Python these days. It will only return the organisation name and the count of metadata. The rest of the other fields are all null.
I tried with both the filing method in the content layer package and the API method with token. The results are the same. I also tried to generate a response via the API playground with the sample Financial Fillings 1. However, the results are still the same.
Python code
query = '{ FinancialFiling(filter: {AND: [{FilingDocument: {DocumentSummary: {FeedName: {EQ: "Edgar"}}}}, {FilingDocument: {DocumentSummary: {FormType: {EQ: "10-K"}}}}, {FilingDocument: {DocumentSummary: {FilingDate: {BETWN: {FROM: "2020-01-01T00:00:00Z", TO: "2023-12-31T00:00:00Z"}}}}}]}, sort: {FilingDocument: {DocumentSummary: {FilingDate: DESC}}}, limit: 10) { _metadata { totalCount } FilingDocument { Identifiers { Dcn } DocId FinancialFilingId DocumentSummary { DocumentTitle FilingDate FormType HighLevelCategory MidLevelCategory FeedName SecAccessionNumber SizeInBytes } FilesMetaData { FileName MimeType}}}}'definition = filings.search.Definition(query=query)response = definition.get_data()
Code results
DocumentTitle
| Filename | MimeType | Dcn | DocId | FinancialFilingId |
|---|
0 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
|---|
1 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
|---|
2 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
|---|
3 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
|---|
4 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
|---|
5 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
|---|
6 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
|---|
7 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
|---|
8 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
|---|
9 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
|---|
10 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
|---|
11 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
|---|
12 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
|---|
13 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
|---|
14 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
|---|
15 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
|---|
16 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
|---|
The query in api playground
{ "query": "query FinancialFiling($FeedName: String!, $FormType: String!, $FilingDateFrom: DateTime!, $FilingDateTo: DateTime!, $LanguageId: Long) {\n FinancialFiling(filter: {AND: [{FilingDocument: {DocumentSummary: {FeedName: {EQ: $FeedName}}}}, {FilingDocument: {DocumentSummary: {FormType: {EQ: $FormType}}}}, {FilingDocument: {DocumentSummary: {FilingDate: {BETWN: {FROM: $FilingDateFrom, TO: $FilingDateTo}}}}}]}, sort: {FilingDocument: {DocumentSummary: {FilingDate: DESC}}}, limit: 10) {\n _metadata {\n totalCount\n }\n FilingOrganization {\n Names {\n Name {\n OrganizationName(filter: {AND: [{LanguageId: {EQ: $LanguageId}}, {NameTypeCode: {EQ: \"LNG\"}}]}) {\n Name\n }\n }\n }\n }\n FilingDocument {\n Identifiers {\n Dcn\n }\n DocId\n FinancialFilingId\n DocumentSummary {\n DocumentTitle\n FeedName\n FormType\n HighLevelCategory\n MidLevelCategory\n FilingDate\n SecAccessionNumber\n SizeInBytes\n }\n FilesMetaData {\n FileName\n MimeType\n }\n }\n }\n}\n", "variables": { "FeedName": "Edgar", "FormType": "10-Q", "FilingDateFrom": "2020-01-01T00:00:00Z", "FilingDateTo": "2020-12-31T00:00:00Z", "LanguageId": "505062" }}
Below is the head of the response
{ "data": { "FinancialFiling": [ { "_metadata": { "totalCount": 17464 }, "FilingOrganization": { "Names": { "Name": { "OrganizationName": [ { "Name": "Mirage Energy Corporation" } ] } } }, "FilingDocument": { "Identifiers": [ { "Dcn": null } ], "DocId": null, "FinancialFilingId": null, "DocumentSummary": { "DocumentTitle": null, "FeedName": null, "FormType": null, "HighLevelCategory": null, "MidLevelCategory": null, "FilingDate": null, "SecAccessionNumber": null, "SizeInBytes": null }, "FilesMetaData": [ { "FileName": null, "MimeType": null }, { "FileName": null, "MimeType": null }, { "FileName": null, "MimeType": null } ] } },
….
Please let me know how I can fix the problem. Thank you.
