Using GraphQL to find 10-K Filings

ETLBATeam

ETLBATeam Newcomer

August 2023 in Refinitiv Data Platform

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

}

}

}

Tagged:

0

Best Answer

Jirapongse ✭✭✭✭✭

August 2023 Answer ✓

@ETLBATeam
Thank you for reaching out to us.
I think that you need to run it on the Graphiql tab.

0

Answers

ETLBATeam Newcomer

August 2023

https://community.developers.refinitiv.com/discussion/comment/108186#Comment_108186

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

0

Jirapongse

Jirapongse ✭✭✭✭✭

August 2023

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:

0

ETLBATeam Newcomer

August 2023

https://community.developers.refinitiv.com/discussion/comment/108225#Comment_108225

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

0
Jirapongse ✭✭✭✭✭

August 2023

https://community.developers.refinitiv.com/discussion/comment/108226#Comment_108226

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

0
ETLBATeam Newcomer

August 2023

https://community.developers.refinitiv.com/discussion/comment/108227#Comment_108227
@Jirapongse Thank you! It worked.

0

Categories