Using GraphQL to find 10-K Filings

ETLBATeam

GraphQL in API Playground gives error when attempting to post query filter to 10-K taken from "Cheat Sheet"

{

FinancialFiling(filter: {AND: [{FilingDocument: {DocumentSummary: {FormType: {EQ: "10-K"}}}}, {FilingDocument: {DocumentSummary: {FilingDate: {BETWN: {FROM: "2020-01-01T00:00:00Z", TO: "2020-12-31T00:00:00Z"}}}}}]}, sort: {FilingDocument: {DocumentSummary: {FilingDate: DESC}}}, limit: 10) {

_metadata {

totalCount

}

FilingDocument {

Identifiers {

Dcn

}

DocId

FinancialFilingId

DocumentSummary {

DocumentTitle

FeedName

FormType

HighLevelCategory

MidLevelCategory

FilingDate

SecAccessionNumber

SizeInBytes

}

FilesMetaData {

MimeType

}

DocumentText

}

}

}

Jirapongse

@ETLBATeam

Thank you for reaching out to us.

I think that you need to run it on the Graphiql tab.

ETLBATeam

Thanks that helped.... The next question how to modify the query so it returns link to pdf, instead of Document text?

{

FinancialFiling(filter: {AND: [

{FilingDocument:

{DocumentSummary: {FormType: {EQ: "10-K"}}}},

{FilingDocument: {Identifiers: {OrganizationId: {EQ: "4295907168"}}}},

{FilingDocument:

{DocumentSummary: {

FilingDate: {BETWN: {FROM: "2022-01-01T00:00:00Z", TO: "2022-12-31T00:00:00Z"}

}

}}}]},

sort: {FilingDocument: {DocumentSummary: {FilingDate: DESC}}}, limit: 10) {

_metadata {

totalCount

}

FilingDocument {

Identifiers {

Dcn

}

DocId

FinancialFilingId

DocumentSummary {

DocumentTitle

FeedName

FormType

HighLevelCategory

MidLevelCategory

FilingDate

SecAccessionNumber

SizeInBytes

}

FilesMetaData {

MimeType

}

DocumentText

}

}

}

See Query return with only Docuement.txt in GraphQL.txt

Jirapongse

@ETLBATeam

You can try this one:

{
  FinancialFiling(filter: {AND: [{FilingDocument: {DocumentSummary: {FormType: {EQ: "10-K"}}}}, {FilingDocument: {Identifiers: {OrganizationId: {EQ: "4295907168"}}}}, {FilingDocument: {DocumentSummary: {FilingDate: {BETWN: {FROM: "2022-01-01T00:00:00Z", TO: "2022-12-31T00:00:00Z"}}}}}]}, sort: {FilingDocument: {DocumentSummary: {FilingDate: DESC}}}, limit: 10) {
    _metadata {
      totalCount
    }
    FilingDocument {
      Identifiers {
        Dcn
      }
      DocId
      FinancialFilingId
      DocumentSummary {
        DocumentTitle
        FeedName
        FormType
        HighLevelCategory
        MidLevelCategory
        FilingDate
        SecAccessionNumber
        SizeInBytes
      }
      FilesMetaData {
   FileLink
        FileName
        MimeType
      }
      DocumentText
    }
  }
}

The output is:

ETLBATeam

OK. Great. I am able to get the link. Can you please advise which API to call to download the file.

https://api.refinitiv.com/data-store/document/v1/FinancialFiling/FilingDocument/97673606782/20220728_4295907168_97673606782_1_1_10-K_raw.pdf

Jirapongse

@ETLBATeam

You can use this endpoint: /data-store/document/v1/FinancialFiling/FilingDocument/{id}/{filename}.

ETLBATeam

@Jirapongse Thank you! It worked.