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










0















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



enter image description here



User should be able to edit the data in all the rows in the application , which will then update the data in the ElasticSearch










share|improve this question



















  • 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
















0















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



enter image description here



User should be able to edit the data in all the rows in the application , which will then update the data in the ElasticSearch










share|improve this question



















  • 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














0












0








0








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



enter image description here



User should be able to edit the data in all the rows in the application , which will then update the data in the ElasticSearch










share|improve this question
















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



enter image description here



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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








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













  • 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













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
);



);













draft saved

draft discarded


















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















draft saved

draft discarded
















































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.




draft saved


draft discarded














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





















































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







Popular posts from this blog

How to get text form Clipboard with JavaScript in Firefox 56?How to validate an email address in JavaScript?How do JavaScript closures work?How do I remove a property from a JavaScript object?How do you get a timestamp in JavaScript?How do I copy to the clipboard in JavaScript?How do I include a JavaScript file in another JavaScript file?Get the current URL with JavaScript?How to replace all occurrences of a string in JavaScriptHow to check whether a string contains a substring in JavaScript?How do I remove a particular element from an array in JavaScript?

Can't initialize raids on a new ASUS Prime B360M-A motherboard2019 Community Moderator ElectionSimilar to RAID config yet more like mirroring solution?Can't get motherboard serial numberWhy does the BIOS entry point start with a WBINVD instruction?UEFI performance Asus Maximus V Extreme

List of MPs elected to the English parliament in 1640 (April) Contents List of constituencies and members See also Notes References Navigation menueNational Archives – The Glynde Place ArchivesCobbett's Parliamentary history of England, from the Norman Conquest in 1066 to the year 1803'Aldermen in Parliament', The Aldermen of the City of London: Temp. Henry III – 1912onepage&q&f&#61, false 229