remove header from the reult of a solr query

Question

my code looks like this

username = 'user'
password = 'user'
url = 'http://di4301sw:8081/solr/metadone/select?fl=file.contenu&q=patient.ipp:3456&rows=14'
r = requests.get(url, auth=(username, password)) 
data = r.json()
with open('data.json', 'w') as f:
    json.dump(data, f)

and my result looks like this

{"responseHeader": {"status": 0, "QTime": 0, "params": {"q": "patient.ipp:3456", "fl": "file.contenu", "rows": "14"}}, "response": {"numFound": 14, "start": 0, "docs": [{"file.contenu": "Biochimie d'urgence Dr F. Beyerle, Dr L. Chardon, A. Varennes Tel Secr\u00e9tariat

i want the result to start from "file.contenu" i.e. i dont want the header Thanks in anticipation

i wanted to calculate the tfidf of the result, so it is not seeing it as a json file unless i manually delete the header then it works — Adebayo Salaudeen, Mar 19 '19 at 10:23
i want a way of removing it automatically to prevent the manual removal, thanks — Adebayo Salaudeen, Mar 19 '19 at 10:34
Possible duplicate of [Solr - How to get search result in specific format](https://stackoverflow.com/questions/18307246/solr-how-to-get-search-result-in-specific-format) — The Bndr, Mar 19 '19 at 10:50
You can use requests Event Hooks -http://docs.python-requests.org/en/master/user/advanced/#event-hooks and manipulate the response content — balderman, Mar 19 '19 at 12:03
Thanks so much i will check the two links and get back to you — Adebayo Salaudeen, Mar 19 '19 at 15:00
the links sent couldnt solve my problem but i learnt a lot from them. Really appreciate you guys — Adebayo Salaudeen, Mar 20 '19 at 15:03
@MatsLindh thanks so much, it did removed some parts of the header, the result looks like this now {"response": {"numFound": 831, "start": 0, "docs": [{ "file.contenu": .... i dont know if there is a way i can delete everything before the square bracket because it didnt fit into my tfidf algo unless i delete everything before the square bracket. Thank you once again — Adebayo Salaudeen, Mar 20 '19 at 15:18
I'd just reassign that part in your python part before sending it to your tfidf algo. — MatsLindh, Mar 20 '19 at 22:15
@MatsLindh you mean like you did for the omitHeader, right?. I did that already but did not remove the rest but its ok thanks once again — Adebayo Salaudeen, Mar 22 '19 at 07:16

score 1 · Answer 1 · answered Feb 16 '20 at 14:30

1

you should parse the response in order to get the desired result:

data_to_dump=data['response']['docs'][0]

hope this helps

answered Feb 16 '20 at 14:30

Tarique

1,273
9
15

score 1 · Answer 2 · answered Jan 04 '22 at 21:13

1

There is a URL parameter for this, called omitHeader.

From the documentation:

If set to true, this parameter excludes the header from the returned results.

answered Jan 04 '22 at 21:13

stalskal

1,181
1
8
16

Unfortunately the JSON object returned will sill have `{ "response":{"numFound":1,"start":0,"numFoundExact":true,"docs":[` to start with this parameter. Gets the OP closer but not exactly what they want. – nosvalds Feb 24 '22 at 11:24

remove header from the reult of a solr query

2 Answers2