Full Text Receive Date Field

[Farooq Khan]

Hi,

When I ran the 'core' query,  I would get the field fullTextReceivedDate.

However, I'm no longer getting that field. Has there been a change? How can I extract that field?

Best wishes,

Farooq

[Madhumiethaa Jayaprabha Palanisamy]

Hi Farooq,

We do have the fullTextReceivedDate field in our core response for full-text articles loaded in Europe PMC.

For example: https://www.ebi.ac.uk/europepmc/webservices/rest/article/MED/37278349?resultType=core

May l know for which article id you are expecting the fullTextReceivedDate?


Kind regards,
Madhu

[Farooq Khan]

Thanks Madhu, 

I'm running a query through Excel Power Query - submitting a list of DOIs to extract the metadata - request type is core.

Power Query: Web.Contents("https://www.ebi.ac.uk/europepmc/webservices/rest/search?query=doi:" & [DOI] & "&resulttype=core") 

I used to get the following fields:

May

1. version
2. hitCount
3. request.queryString
4. request.resultType
5. request.cursorMark
6. request.pageSize
7. request.sort
8. request.synonym
9. resultList.result.id
10. resultList.result.source
11. resultList.result.pmid
12. resultList.result.pmcid
13. resultList.result.fullTextIdList
14. resultList.result.doi
15. resultList.result.title
16. resultList.result.authorString
17. resultList.result.authorList
18. resultList.result.journalInfo
19. resultList.result.pubYear
20. resultList.result.pageInfo
21. resultList.result.abstractText
22. resultList.result.affiliation
23. resultList.result.publicationStatus
24. resultList.result.language
25. resultList.result.pubModel
26. resultList.result.pubTypeList
27. resultList.result.keywordList
28. resultList.result.fullTextUrlList
29. resultList.result.isOpenAccess
30. resultList.result.inEPMC
31. resultList.result.inPMC
32. resultList.result.hasPDF
33. resultList.result.hasBook
34. resultList.result.hasSuppl
35. resultList.result.citedByCount
36. resultList.result.hasData
37. resultList.result.hasReferences
38. resultList.result.hasTextMinedTerms
39. resultList.result.hasDbCrossReferences
40. resultList.result.hasLabsLinks
41. resultList.result.authMan
42. resultList.result.epmcAuthMan
43. resultList.result.nihAuthMan
44. resultList.result.hasTMAccessionNumbers
45. resultList.result.dateOfCreation
46. resultList.result.firstIndexDate
47. resultList.result.fullTextReceivedDate
48. resultList.result.dateOfRevision
49. resultList.result.firstPublicationDate
50. resultList.result.authorIdList
51. resultList.result.dataLinksTagsList
52. resultList.result.grantsList

But now I get these fields:

June

1. version
2. hitCount
3. request.queryString
4. request.resultType
5. request.cursorMark
6. request.pageSize
7. request.sort
8. request.synonym
9. resultList.result.id
10. resultList.result.source
11. resultList.result.pmid
12. resultList.result.doi
13. resultList.result.title
14. resultList.result.authorString
15. resultList.result.authorList
16. resultList.result.authorIdList
17. resultList.result.dataLinksTagsList
18. resultList.result.journalInfo
19. resultList.result.pubYear
20. resultList.result.pageInfo
21. resultList.result.publicationStatus
22. resultList.result.language
23. resultList.result.pubModel
24. resultList.result.pubTypeList
25. resultList.result.fullTextUrlList
26. resultList.result.isOpenAccess
27. resultList.result.inEPMC
28. resultList.result.inPMC
29. resultList.result.hasPDF
30. resultList.result.hasBook
31. resultList.result.hasSuppl
32. resultList.result.citedByCount
33. resultList.result.hasData
34. resultList.result.hasReferences
35. resultList.result.hasTextMinedTerms
36. resultList.result.hasDbCrossReferences
37. resultList.result.hasLabsLinks
38. resultList.result.authMan
39. resultList.result.epmcAuthMan
40. resultList.result.nihAuthMan
41. resultList.result.hasTMAccessionNumbers
42. resultList.result.dateOfCreation
43. resultList.result.firstIndexDate
44. resultList.result.dateOfRevision
45. resultList.result.firstPublicationDate
46. resultList.result.grantsList

There are fewer fields for some reason.

Best wishes, 

Farooq

[Madhumiethaa Jayaprabha Palanisamy]

Hi Farooq, 

Looks like some of the missing fields are specific to articles with full text loaded in EPMC (pmcid, fullTextIdList, fullTextReceivedDate). So of it's not a full text article, these fields won't be there ( You can Identify it by the field called "inPMC": "N")

For the rest of the missing fields (keywordList, affiliation, abstractText), could be the fact that there are no actual data for those fields wrt the article. May I know some of your doi's for which there are these missing fields?

king regards,

Made

[Farooq Khan]

Hi Madhu,

The problem is some of the fields I used to get no longer come up at all. For example, when I submitted this doi:10.1093/neuonc/noy129.009, I would get the full text receive date field, but now for the same DOI, that field no longer appears even though there is a text receive date. I've also run the queries through the R package but encountered the same issue.

Best wishes,

Farooq 

[Madhumiethaa Jayaprabha Palanisamy]

Hi Farooq,

I ran a query for the same and I am able to see the full text receive date field. 

https://www.ebi.ac.uk/europepmc/webservices/rest/search?query=doi%3A10.1093%2Fneuonc%2Fnoy129.009&resultType=core&cursorMark=*&pageSize=25

Could you please double check from your side?

kind regards,

Madhu

[Farooq Khan]

Thanks Madhu,

The issue is when the query is written to a CSV file or run through Excel Power Query:

1. when the query is run through Excel Power Query and results loaded not all the fields are showing
2. when the query is run through R and the results written to a CSV file not all the fields are showing

Best wishes, 

Farooq

[Madhumiethaa Jayaprabha Palanisamy]

Hi Farooq,

Okay, so it looks like something to be checked when loading the results. 

Please let us know if you have any further queries regarding the api.

Help pages:

https://europepmc.org/RestfulWebService

https://europepmc.org/SoapWebServices

Kind regards,

Madhu