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

Thal And Out Agency railway station See also References External links Navigation menuOfficial Web Site of Pakistan RailwaysArchivedOfficial Web Site of Pakistan Railwayseeexpanding ite

Understanding generators in Python2019 Community Moderator ElectionGenerator function not working pythonFor loop not executing two timesGenerators - Printing generated valuesWhy can a python generator only be used once?What exactly do generators do?What does the “yield” keyword do?What does “list comprehension” mean? How does it work and how can I use it?sklearn Kfold acces single fold instead of for loopIs a generator the callable? Which is the generator?Apply Border To Range Of Cells Using OpenpyxlCalling an external command in PythonWhat are metaclasses in Python?What is the difference between @staticmethod and @classmethod?Finding the index of an item given a list containing it in PythonDifference between append vs. extend list methods in PythonHow can I safely create a nested directory in Python?Does Python have a ternary conditional operator?Understanding slice notationUnderstanding Python super() with __init__() methodsDoes Python have a string 'contains' substring method?

How can I change the color of pagination dots of UIPageControl?How to change UIPageControl dotsIs there a way to change page indicator dots colorCustomize dot with image of UIPageControl at index 0 of UIPageControlNo visible @interface for 'NSObject<PageControlDelegate>' declares the selector 'pageControlPageDidChange:'How to change the color of pagination dots in UIPageControl with a different color per pagepagecontrol indicator custom image instead of DefaultChanging the colour of UIPageControl dots in MonoTouchpagecontrol selectable page visibility color?Alternative way to load ViewControllers on a UIPageControlHow to set only layer.border-color for UIpage control dots in swiftHow can I develop for iPhone using a Windows development machine?How to change the name of an iOS app?UITableView - change section header coloruipagecontrol indicator(dot)issueCustom UIPageControl dots color not changingchange the interspace between UIPageControl dotsHow to change Status Bar text color in iOSHow can I change image tintColor in iOS and WatchKitUIPageControl dots with larger space in between each dotsHow to change the color of pagination dots in UIPageControl with a different color per page