Filing API returns null content

Zeshi_Yang123

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.

Jirapongse

@Zeshi_Yang123

Thank you for reaching out to us.

Could you run the Financial Filing 1 example on the API Playground?

If you get NULL on the resposne, it should be the problem on your acccount. Please contact your LSEG account team or Sales team directly to verify the permission.