Filing API returns null content

Zeshi_Yang123
Zeshi_Yang123 Newcomer
edited February 11 in Refinitiv Data Platform

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.

Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @Zeshi_Yang123

    Thank you for reaching out to us.

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

    image.png

    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.

    image.png