Python - insert json file into elasticsearch

Question

I have this Json in a file:

{
   "name": "Huntington Beach",
   "beach": "50 N of Santa Ana River",
   "SampleDate": "02/01/18",
   "ParameterCode": "Enterococcus",
   "Qualifier": "=",
   "Result": "8",
   "Units": "CFU/100ml"
 },

I wrote this script which should print all of the json text:

from pprint import pprint
import requests
import urllib
import json
from elasticsearch import Elasticsearch
from elasticsearch import helpers
from elasticsearch.serializer import JSONSerializer
import os,sys

directory = '/home/Documents/folder/myfile.json'

es = Elasticsearch([{'host': '', 'port': }])

with open(directory, 'r', encoding='utf-8') as f:
    data=json.loads(f.read())
pprint(data)

es.index(index='my_index', doc_type='doc', body=data)

It doesn't work, can you help me? This is what happens:

raise JSONDecodeError("Extra data", s, end)

json.decoder.JSONDecodeError: Extra data:

You have a trailing comma in your JSON, it's not valid.

dwjv
– dwjv

2018-10-17 15:58:16 +00:00
Commented Oct 17, 2018 at 15:58 — dwjv
– dwjv, Commented Oct 17, 2018 at 15:58

Lafa · Accepted Answer · 2018-10-18 16:10:07Z

1

As stated by @dwjv, your json file is not valid:

{
   "name": "Huntington Beach",
   "beach": "50 N of Santa Ana River",
   "SampleDate": "02/01/18",
   "ParameterCode": "Enterococcus",
   "Qualifier": "=",
   "Result": "8",
   "Units": "CFU/100ml"
 }, <---trailing comma

Just remove it and you should be good to go.

answered Oct 18, 2018 at 16:10

Lafa

4611 gold badge5 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python - insert json file into elasticsearch

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related