Convert Elasticsearch response data in json format to Table in PyQT5How 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 do I POST JSON data with Curl from a 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

Aragorn's "guise" in the Orthanc Stone

How should I respond when I lied about my education and the company finds out through background check?

How to explain what's wrong with this application of the chain rule?

Pre-mixing cryogenic fuels and using only one fuel tank

Are paving bricks differently sized for sand bedding vs mortar bedding?

Non-trope happy ending?

Is it improper etiquette to ask your opponent what his/her rating is before the game?

Why does the Sun have different day lengths, but not the gas giants?

Multiplicative persistence

Is it possible to have a strip of cold climate in the middle of a planet?

Should I outline or discovery write my stories?

Creepy dinosaur pc game identification

copy and scale one figure (wheel)

How much character growth crosses the line into breaking the character

Start making guitar arrangements

Can I sign legal documents with a smiley face?

How to indicate a cut out for a product window

How do you respond to a colleague from another team when they're wrongly expecting that you'll help them?

GraphicsGrid with a Label for each Column and Row

Why did the Mercure fail?

Delivering sarcasm

What does chmod -u do?

Must Legal Documents Be Siged In Standard Pen Colors?

How to bake one texture for one mesh with multiple textures blender 2.8



Convert Elasticsearch response data in json format to Table in PyQT5


How 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 do I POST JSON data with Curl from a 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
























  • @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
























  • @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












  • @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

















@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

AWS Lex not identifying response if by a variable The 2019 Stack Overflow Developer Survey Results Are In Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) The Ask Question Wizard is Live! Data science time! April 2019 and salary with experienceEnforcing custom enumeration in AWS LEX for slot valuesHow to give response based on user response in Amazon Lex?Intercepting AWS Lambda Response to a AWS Lex QueryLex chat bot error: Reached second execution of fulfillment lambda on the same utteranceamazon lex showing invalid responseLambda response send back to Lex slot?Response card in Amazon lexAmazon Lex - Lambda response return HTML to botHow can I solve 424 (Failed Dependency) (python) obtained from Amazon lex?

Алба-Юлія

Захаров Федір Захарович