Convert Elasticsearch response data in json format to Table in PyQT52019 Community Moderator ElectionHow do I format a Microsoft JSON date?Convert form data to JavaScript object with jQueryWhy does Google prepend while(1); to their JSON responses?Convert JS object to JSON stringHow to POST JSON data with Curl from Terminal/Commandline to Test Spring REST?The “right” JSON date formatHow do I write JSON data to a file?Standard JSON API response format?rails : type search with data address use elasticsearch chewy gemImporting big JSON into ElasticSearch gives no response
Rejected in 4th interview round citing insufficient years of experience
How did Alan Turing break the enigma code using the hint given by the lady in the bar?
Fourth person (in Slavey language)
Built-In Shelves/Bookcases - IKEA vs Built
MTG: Can I kill an opponent in response to lethal activated abilities, and not take the damage?
Is having access to past exams cheating and, if yes, could it be proven just by a good grade?
Unreachable code, but reachable with exception
What are some noteworthy "mic-drop" moments in math?
Who deserves to be first and second author? PhD student who collected data, research associate who wrote the paper or supervisor?
How strictly should I take "Candidates must be local"?
Latest web browser compatible with Windows 98
What to do when during a meeting client people start to fight (even physically) with each others?
Peter's Strange Word
Logic. Truth of a negation
Is there an elementary proof that there are infinitely many primes that are *not* completely split in an abelian extension?
Things to avoid when using voltage regulators?
Why doesn't this Google Translate ad use the word "Translation" instead of "Translate"?
Is there a window switcher for GNOME that shows the actual window?
Do f-stop and exposure time perfectly cancel?
Does "variables should live in the smallest scope as possible" include the case "variables should not exist if possible"?
Replacing Windows 7 security updates with anti-virus?
Low budget alien movie about the Earth being cooked
Virginia employer terminated employee and wants signing bonus returned
Why the color red for the Republican Party
Convert Elasticsearch response data in json format to Table in PyQT5
2019 Community Moderator ElectionHow do I format a Microsoft JSON date?Convert form data to JavaScript object with jQueryWhy does Google prepend while(1); to their JSON responses?Convert JS object to JSON stringHow to POST JSON data with Curl from Terminal/Commandline to Test Spring REST?The “right” JSON date formatHow do I write JSON data to a file?Standard JSON API response format?rails : type search with data address use elasticsearch chewy gemImporting big JSON into ElasticSearch gives no response
I am new to Using Pyqt5. I have response data from Elasticsearch which is in JSON format( Sample given below ). I need to display the response received from elasticsearch as a table using Pyqt5. Along with that, I should be able to Display only the required fields data from JSON and not the entire JSON response from elasticsearch (Table image provided below). With the ability to edit and update those fields.
Can any help with this?
Sample JSON response from elasticsearch is as follows :
"took": 2,
"timed_out": false,
"_shards":
"total": 5,
"successful": 5,
"skipped": 0,
"failed": 0
,
"hits":
"total": 230,
"max_score": 3.9777644,
"hits": [
"_index": "data1",
"_type": "doc",
"_id": "sdhniusbfjvbdnfb134u23",
"_score": 3.9777644,
"_source":
"Pdf_URL": null,
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message1",
"Details": "Details1",
"@timestamp": "2019-02-26T10:54:43.733Z",
"Date": "02-05-2012",
"Time": "09:34:49",
"Announcement": "Announcement1",
"@version": "1"
,
"_index": "data1",
"_type": "d1",
"_id": "uV9xKWkBn8v9OsZrV8Ca",
"_score": 3.9609475,
"_source":
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message2",
"@timestamp": "2019-02-26T10:54:43.768Z",
"Announcement": "Announcement2",
"@version": "1"
,
"_index": "data1",
"_type": "doc",
"_id": "erhsdfhsdhrsth35y4",
"_score": 3.9609475,
"_source":
"Pdf_URL": null,
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message3",
"Details": "Details3",
"@timestamp": "2019-02-26T10:54:43.727Z",
"Date": "02-11-2012",
"Time": "09:52:57",
"Announcement": "Announcement3",
"@version": "1"
,
"_index": "data1",
"_type": "doc",
"_id": "asdviyqwbigbqrugvne",
"_score": 3.6811633,
"_source":
"Pdf_URL": null,
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message4",
"Details": "Details4",
"@timestamp": "2019-02-26T10:54:43.734Z",
"Date": "02-12-2011",
"Time": "09:26:05",
"Announcement": "Announcement4",
"@version": "1"
,
"_index": "data1",
"_type": "doc",
"_id": "g3rewrgewrgserg",
"_score": 3.5482104,
"_source":
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message5",
"@timestamp": "2019-02-26T10:54:43.770Z",
"Announcement": "Announcement5",
"@version": "1"
,
"_index": "data1",
"_type": "doc",
"_id": "iuabdviusbiovjbsod134",
"_score": 3.5482104,
"_source":
"Pdf_URL": null,
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message6",
"Details": "Details6",
"@timestamp": "2019-02-26T10:54:43.726Z",
"Date": "02-01-2013",
"Time": "10:05:18",
"Announcement": "Announcement6",
"@version": "1"
,
"_index": "data1",
"_type": "d1",
"_id": "pIVxKWkBs1ExbNgWXw1q",
"_score": 3.5482104,
"_source":
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message7",
"@timestamp": "2019-02-26T10:54:43.765Z",
"Announcement": "Announcement7",
"@version": "1"
]
And I need this data to be displayed as

User should be able to edit the data in all the rows in the application , which will then update the data in the ElasticSearch
python json python-3.x elasticsearch pyqt5
add a comment |
I am new to Using Pyqt5. I have response data from Elasticsearch which is in JSON format( Sample given below ). I need to display the response received from elasticsearch as a table using Pyqt5. Along with that, I should be able to Display only the required fields data from JSON and not the entire JSON response from elasticsearch (Table image provided below). With the ability to edit and update those fields.
Can any help with this?
Sample JSON response from elasticsearch is as follows :
"took": 2,
"timed_out": false,
"_shards":
"total": 5,
"successful": 5,
"skipped": 0,
"failed": 0
,
"hits":
"total": 230,
"max_score": 3.9777644,
"hits": [
"_index": "data1",
"_type": "doc",
"_id": "sdhniusbfjvbdnfb134u23",
"_score": 3.9777644,
"_source":
"Pdf_URL": null,
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message1",
"Details": "Details1",
"@timestamp": "2019-02-26T10:54:43.733Z",
"Date": "02-05-2012",
"Time": "09:34:49",
"Announcement": "Announcement1",
"@version": "1"
,
"_index": "data1",
"_type": "d1",
"_id": "uV9xKWkBn8v9OsZrV8Ca",
"_score": 3.9609475,
"_source":
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message2",
"@timestamp": "2019-02-26T10:54:43.768Z",
"Announcement": "Announcement2",
"@version": "1"
,
"_index": "data1",
"_type": "doc",
"_id": "erhsdfhsdhrsth35y4",
"_score": 3.9609475,
"_source":
"Pdf_URL": null,
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message3",
"Details": "Details3",
"@timestamp": "2019-02-26T10:54:43.727Z",
"Date": "02-11-2012",
"Time": "09:52:57",
"Announcement": "Announcement3",
"@version": "1"
,
"_index": "data1",
"_type": "doc",
"_id": "asdviyqwbigbqrugvne",
"_score": 3.6811633,
"_source":
"Pdf_URL": null,
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message4",
"Details": "Details4",
"@timestamp": "2019-02-26T10:54:43.734Z",
"Date": "02-12-2011",
"Time": "09:26:05",
"Announcement": "Announcement4",
"@version": "1"
,
"_index": "data1",
"_type": "doc",
"_id": "g3rewrgewrgserg",
"_score": 3.5482104,
"_source":
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message5",
"@timestamp": "2019-02-26T10:54:43.770Z",
"Announcement": "Announcement5",
"@version": "1"
,
"_index": "data1",
"_type": "doc",
"_id": "iuabdviusbiovjbsod134",
"_score": 3.5482104,
"_source":
"Pdf_URL": null,
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message6",
"Details": "Details6",
"@timestamp": "2019-02-26T10:54:43.726Z",
"Date": "02-01-2013",
"Time": "10:05:18",
"Announcement": "Announcement6",
"@version": "1"
,
"_index": "data1",
"_type": "d1",
"_id": "pIVxKWkBs1ExbNgWXw1q",
"_score": 3.5482104,
"_source":
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message7",
"@timestamp": "2019-02-26T10:54:43.765Z",
"Announcement": "Announcement7",
"@version": "1"
]
And I need this data to be displayed as

User should be able to edit the data in all the rows in the application , which will then update the data in the ElasticSearch
python json python-3.x elasticsearch pyqt5
1
provide a Minimal, Complete, and Verifiable example
– eyllanesc
Mar 7 at 7:54
@eyllanesc Plz check the updated post.. I have provided the details. Let me know if you need anything more.
– suyash999
Mar 7 at 9:42
add a comment |
I am new to Using Pyqt5. I have response data from Elasticsearch which is in JSON format( Sample given below ). I need to display the response received from elasticsearch as a table using Pyqt5. Along with that, I should be able to Display only the required fields data from JSON and not the entire JSON response from elasticsearch (Table image provided below). With the ability to edit and update those fields.
Can any help with this?
Sample JSON response from elasticsearch is as follows :
"took": 2,
"timed_out": false,
"_shards":
"total": 5,
"successful": 5,
"skipped": 0,
"failed": 0
,
"hits":
"total": 230,
"max_score": 3.9777644,
"hits": [
"_index": "data1",
"_type": "doc",
"_id": "sdhniusbfjvbdnfb134u23",
"_score": 3.9777644,
"_source":
"Pdf_URL": null,
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message1",
"Details": "Details1",
"@timestamp": "2019-02-26T10:54:43.733Z",
"Date": "02-05-2012",
"Time": "09:34:49",
"Announcement": "Announcement1",
"@version": "1"
,
"_index": "data1",
"_type": "d1",
"_id": "uV9xKWkBn8v9OsZrV8Ca",
"_score": 3.9609475,
"_source":
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message2",
"@timestamp": "2019-02-26T10:54:43.768Z",
"Announcement": "Announcement2",
"@version": "1"
,
"_index": "data1",
"_type": "doc",
"_id": "erhsdfhsdhrsth35y4",
"_score": 3.9609475,
"_source":
"Pdf_URL": null,
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message3",
"Details": "Details3",
"@timestamp": "2019-02-26T10:54:43.727Z",
"Date": "02-11-2012",
"Time": "09:52:57",
"Announcement": "Announcement3",
"@version": "1"
,
"_index": "data1",
"_type": "doc",
"_id": "asdviyqwbigbqrugvne",
"_score": 3.6811633,
"_source":
"Pdf_URL": null,
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message4",
"Details": "Details4",
"@timestamp": "2019-02-26T10:54:43.734Z",
"Date": "02-12-2011",
"Time": "09:26:05",
"Announcement": "Announcement4",
"@version": "1"
,
"_index": "data1",
"_type": "doc",
"_id": "g3rewrgewrgserg",
"_score": 3.5482104,
"_source":
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message5",
"@timestamp": "2019-02-26T10:54:43.770Z",
"Announcement": "Announcement5",
"@version": "1"
,
"_index": "data1",
"_type": "doc",
"_id": "iuabdviusbiovjbsod134",
"_score": 3.5482104,
"_source":
"Pdf_URL": null,
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message6",
"Details": "Details6",
"@timestamp": "2019-02-26T10:54:43.726Z",
"Date": "02-01-2013",
"Time": "10:05:18",
"Announcement": "Announcement6",
"@version": "1"
,
"_index": "data1",
"_type": "d1",
"_id": "pIVxKWkBs1ExbNgWXw1q",
"_score": 3.5482104,
"_source":
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message7",
"@timestamp": "2019-02-26T10:54:43.765Z",
"Announcement": "Announcement7",
"@version": "1"
]
And I need this data to be displayed as

User should be able to edit the data in all the rows in the application , which will then update the data in the ElasticSearch
python json python-3.x elasticsearch pyqt5
I am new to Using Pyqt5. I have response data from Elasticsearch which is in JSON format( Sample given below ). I need to display the response received from elasticsearch as a table using Pyqt5. Along with that, I should be able to Display only the required fields data from JSON and not the entire JSON response from elasticsearch (Table image provided below). With the ability to edit and update those fields.
Can any help with this?
Sample JSON response from elasticsearch is as follows :
"took": 2,
"timed_out": false,
"_shards":
"total": 5,
"successful": 5,
"skipped": 0,
"failed": 0
,
"hits":
"total": 230,
"max_score": 3.9777644,
"hits": [
"_index": "data1",
"_type": "doc",
"_id": "sdhniusbfjvbdnfb134u23",
"_score": 3.9777644,
"_source":
"Pdf_URL": null,
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message1",
"Details": "Details1",
"@timestamp": "2019-02-26T10:54:43.733Z",
"Date": "02-05-2012",
"Time": "09:34:49",
"Announcement": "Announcement1",
"@version": "1"
,
"_index": "data1",
"_type": "d1",
"_id": "uV9xKWkBn8v9OsZrV8Ca",
"_score": 3.9609475,
"_source":
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message2",
"@timestamp": "2019-02-26T10:54:43.768Z",
"Announcement": "Announcement2",
"@version": "1"
,
"_index": "data1",
"_type": "doc",
"_id": "erhsdfhsdhrsth35y4",
"_score": 3.9609475,
"_source":
"Pdf_URL": null,
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message3",
"Details": "Details3",
"@timestamp": "2019-02-26T10:54:43.727Z",
"Date": "02-11-2012",
"Time": "09:52:57",
"Announcement": "Announcement3",
"@version": "1"
,
"_index": "data1",
"_type": "doc",
"_id": "asdviyqwbigbqrugvne",
"_score": 3.6811633,
"_source":
"Pdf_URL": null,
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message4",
"Details": "Details4",
"@timestamp": "2019-02-26T10:54:43.734Z",
"Date": "02-12-2011",
"Time": "09:26:05",
"Announcement": "Announcement4",
"@version": "1"
,
"_index": "data1",
"_type": "doc",
"_id": "g3rewrgewrgserg",
"_score": 3.5482104,
"_source":
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message5",
"@timestamp": "2019-02-26T10:54:43.770Z",
"Announcement": "Announcement5",
"@version": "1"
,
"_index": "data1",
"_type": "doc",
"_id": "iuabdviusbiovjbsod134",
"_score": 3.5482104,
"_source":
"Pdf_URL": null,
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message6",
"Details": "Details6",
"@timestamp": "2019-02-26T10:54:43.726Z",
"Date": "02-01-2013",
"Time": "10:05:18",
"Announcement": "Announcement6",
"@version": "1"
,
"_index": "data1",
"_type": "d1",
"_id": "pIVxKWkBs1ExbNgWXw1q",
"_score": 3.5482104,
"_source":
"path": "Whatever/Local/Path",
"host": "suyash",
"message": "Message7",
"@timestamp": "2019-02-26T10:54:43.765Z",
"Announcement": "Announcement7",
"@version": "1"
]
And I need this data to be displayed as

User should be able to edit the data in all the rows in the application , which will then update the data in the ElasticSearch
python json python-3.x elasticsearch pyqt5
python json python-3.x elasticsearch pyqt5
edited Mar 7 at 9:40
suyash999
asked Mar 7 at 7:40
suyash999suyash999
217
217
1
provide a Minimal, Complete, and Verifiable example
– eyllanesc
Mar 7 at 7:54
@eyllanesc Plz check the updated post.. I have provided the details. Let me know if you need anything more.
– suyash999
Mar 7 at 9:42
add a comment |
1
provide a Minimal, Complete, and Verifiable example
– eyllanesc
Mar 7 at 7:54
@eyllanesc Plz check the updated post.. I have provided the details. Let me know if you need anything more.
– suyash999
Mar 7 at 9:42
1
1
provide a Minimal, Complete, and Verifiable example
– eyllanesc
Mar 7 at 7:54
provide a Minimal, Complete, and Verifiable example
– eyllanesc
Mar 7 at 7:54
@eyllanesc Plz check the updated post.. I have provided the details. Let me know if you need anything more.
– suyash999
Mar 7 at 9:42
@eyllanesc Plz check the updated post.. I have provided the details. Let me know if you need anything more.
– suyash999
Mar 7 at 9:42
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55038453%2fconvert-elasticsearch-response-data-in-json-format-to-table-in-pyqt5%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55038453%2fconvert-elasticsearch-response-data-in-json-format-to-table-in-pyqt5%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
provide a Minimal, Complete, and Verifiable example
– eyllanesc
Mar 7 at 7:54
@eyllanesc Plz check the updated post.. I have provided the details. Let me know if you need anything more.
– suyash999
Mar 7 at 9:42