# I have a column of Mid, and I want to extract the File:URL…
**URL:** https://forum.openrefine.org/t/i-have-a-column-of-mid-and-i-want-to-extract-the-file-url/1533
**Category:** Support and Helpdesk
**Tags:** wikimedia-commons
**Created:** [May 17, 2024, 6:26pm UTC](https://forum.openrefine.org/t/i-have-a-column-of-mid-and-i-want-to-extract-the-file-url/1533 "2024-05-17T18:26:27Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@Antoine2711](https://forum.openrefine.org/u/Antoine2711)
#### Post date: [May 17, 2024, 6:26pm UTC](https://forum.openrefine.org/t/i-have-a-column-of-mid-and-i-want-to-extract-the-file-url/1533/1 "2024-05-17T18:26:27Z")
I have a column with a lot of Mid (ex. [M141414969](https://commons.wikimedia.org/entity/M141414969)).
How can I get the File URL (i.e.: [https://commons.wikimedia.org/wiki/File:MdM\_Micheline\_Legendre\_en\_1975.jpg](https://commons.wikimedia.org/wiki/File:MdM_Micheline_Legendre_en_1975.jpg)) of that image?
Regards, Antoine
---
### Author:  [@Gnoeee](https://forum.openrefine.org/u/Gnoeee)
#### Post date: [May 18, 2024, 5:58am UTC](https://forum.openrefine.org/t/i-have-a-column-of-mid-and-i-want-to-extract-the-file-url/1533/2 "2024-05-18T05:58:07Z")
Right now I'm not sure if there is a direct way in OR similar to getting captions, labels, descriptions and properties from Wikibase. But one way can be fetching the URL (ex: [https://commons.wikimedia.org/entity/M141414969](https://commons.wikimedia.org/entity/M141414969)) and we will get the data which includes the title of the file. So we can construct the File URL from that.
---
### Author:  [@Antoine2711](https://forum.openrefine.org/u/Antoine2711)
#### Post date: [May 21, 2024, 3:18am UTC](https://forum.openrefine.org/t/i-have-a-column-of-mid-and-i-want-to-extract-the-file-url/1533/3 "2024-05-21T03:18:20Z")
I will get a redirect (HTTP 301 or 302), but not sure how I can extract that in OR…
Regards, Antoine
---
### Author:  [@ostephens](https://forum.openrefine.org/u/ostephens)
#### Post date: [May 21, 2024, 6:36pm UTC](https://forum.openrefine.org/t/i-have-a-column-of-mid-and-i-want-to-extract-the-file-url/1533/4 "2024-05-21T18:36:26Z")
I think if you set the HTTP "Accept' Header to be `application/json` I think it will return the JSON rather than redirect:
Then maybe something like
`value.parseJson().entities.get(cells["Img_WCID"].value).title`
to extract the file name?
---
### Author:  [@tfmorris](https://forum.openrefine.org/u/tfmorris)
#### Post date: [May 21, 2024, 8:59pm UTC](https://forum.openrefine.org/t/i-have-a-column-of-mid-and-i-want-to-extract-the-file-url/1533/5 "2024-05-21T20:59:05Z")
Instead of using content negotiation headers, you can also just modify the URL:
[https://commons.wikimedia.org/wiki/Special:EntityData/M141414969.json](https://commons.wikimedia.org/wiki/Special:EntityData/M141414969.json)
although "title" seems like a very odd place to store the file name and I'm not sure how reliable it is.
Perhaps a better approach would be to look at the RDF/XML or Turtle
[https://commons.wikimedia.org/wiki/Special:EntityData/M141414969.ttl](https://commons.wikimedia.org/wiki/Special:EntityData/M141414969.ttl)
[https://commons.wikimedia.org/wiki/Special:EntityData/M141414969.rdf](https://commons.wikimedia.org/wiki/Special:EntityData/M141414969.rdf)
which has (in Turtle) all the attributes of the image object:
sdc:M141414969 a schema:MediaObject,
schema:ImageObject ;
schema:encodingFormat "image/jpeg" ;
schema:contentUrl \<[https://upload.wikimedia.org/wikipedia/commons/2/2c/MdM\_Micheline\_Legendre\_en\_1975.jpg](https://upload.wikimedia.org/wikipedia/commons/2/2c/MdM_Micheline_Legendre_en_1975.jpg)\> ;
schema:url \<[http://commons.wikimedia.org/wiki/Special:FilePath/MdM%20Micheline%20Legendre%20en%201975.jpg](http://commons.wikimedia.org/wiki/Special:FilePath/MdM%20Micheline%20Legendre%20en%201975.jpg)\> ;
schema:contentSize "18217"^^xsd:integer ;
schema:height "140"^^xsd:integer ;
schema:width "234"^^xsd:integer .
---
### Author:  [@Andre\_Costa](https://forum.openrefine.org/u/Andre_Costa)
#### Post date: [May 22, 2024, 2:11pm UTC](https://forum.openrefine.org/t/i-have-a-column-of-mid-and-i-want-to-extract-the-file-url/1533/6 "2024-05-22T14:11:34Z")
"title" in the EntityData should be fairly reliable for getting the image page associated with an Mid.
Since the Mid is generated from the pageId you could also just shave of the `M` and query [https://commons.wikimedia.org/w/api.php?action=query&format=json&pageids=141414969](https://commons.wikimedia.org/w/api.php?action=query&format=json&pageids=141414969) to get title value that way.
---
### Author:  [@Antoine2711](https://forum.openrefine.org/u/Antoine2711)
#### Post date: [May 23, 2024, 4:33am UTC](https://forum.openrefine.org/t/i-have-a-column-of-mid-and-i-want-to-extract-the-file-url/1533/7 "2024-05-23T04:33:40Z")
@Andre_Costa: This seems fast. Do you know if I can query many on the same call?
This: [https://commons.wikimedia.org/w/api.php?action=query&format=json&pageids=141414969,141414970,141414968](https://commons.wikimedia.org/w/api.php?action=query&format=json&pageids=141414969,141414970,141414968)
Is not working.
Regards, Antoine
---
### Author:  [@Antoine2711](https://forum.openrefine.org/u/Antoine2711)
#### Post date: [May 23, 2024, 4:34am UTC](https://forum.openrefine.org/t/i-have-a-column-of-mid-and-i-want-to-extract-the-file-url/1533/8 "2024-05-23T04:34:31Z")
@Gnoeee: I dismissed your answer too fast. It was working, but it’s slow. Thanks.
Regards, Antoine
---
### Author:  [@Antoine2711](https://forum.openrefine.org/u/Antoine2711)
#### Post date: [May 23, 2024, 4:38am UTC](https://forum.openrefine.org/t/i-have-a-column-of-mid-and-i-want-to-extract-the-file-url/1533/9 "2024-05-23T04:38:18Z")
@tfmorris: the Json seems easier to parse. It’s just slow.
Thanks for the alternative solutions.
Regards, Antoine
---
### Author:  [@Andre\_Costa](https://forum.openrefine.org/u/Andre_Costa)
#### Post date: [May 23, 2024, 10:48am UTC](https://forum.openrefine.org/t/i-have-a-column-of-mid-and-i-want-to-extract-the-file-url/1533/10 "2024-05-23T10:48:47Z")
The separation is done using either the pipe-character
e.g. [https://commons.wikimedia.org/w/api.php?action=query&format=json&pageids=141414969|141414970|141414968](https://commons.wikimedia.org/w/api.php?action=query&format=json&pageids=141414969%7C141414970%7C141414968)
You are allowed max 50 at a go (unless you are logged in with special permissions)