Hi, I am still learning node-red, I was able to complete one part of the project recently thanks to all of your help. I now have another part of the project I am stuck on. I have a XML file that I needed to parse data from. I will attach the XML file to the question. I was wondering if there was a …

Hi @KevinPamu - as Mark mentioned, the https://nodered.org/docs/user-guide/messages page in the docs tells you how you can use the Debug sidebar to identify the path to any element in the message - it can copy that path straight to your clipboard. Once you have that you could do something like: m…

Try the xml node that will convert from xml to a javascript object or the other way. Use xml and then link it to a debug node

Was just trying that node, how would I access the particular value from the JS object? maybe from a function?

you could use a function or a change node. But use a debug node to take a look at the object and look at the “working with messages” page in the docs to see how useful the debug panel can be.

[4] That did help it convert it into a JavaScript Object. I tried to put in a function node in between and maybe access some of the values in the object. How would you suggest I do that? Syntax wise in the function node. Thank you

Thank you for the reply @knolleary I tried doing that and receive this message, "TypeError: Cannot read property 'Transaction' of undefined". Will keep trying to work with it. However, I will receive more than one message like that and I was wondering if there would be a way I can have a set syntax …

Thank you for the solution @knolleary @ukmoose . I have a follow up question, do you think there is a way I can find out the length of the TenderSummary array from the XML file?

LMGTFY: https://www.w3schools.com/jsref/jsref_length_array.asp

Hello! I have a similar problem when i try to extract data from a specific object from a room scheduling server. "msg.payload.ArrayOfScreenOccasion.ScreenOccasion[0]" What I'm trying to do is that "ObjectName[0]" contains the name of the room which i will use to the filter the data "msg.payload.Ar…

So you have an array of bookings as it says "msg.payload.ArrayOfScreenOccasion" You could either use JSONata to filter the data or use an old fashioned function node and iterate through the array

OK. Do you have an example? The thing is that i have to publish the data to an another server which controls the panels outside the rooms via TCP/IP.

Node-RED

Node-RED Forum

Parse Data from XML

General

ukmoose 6 March 2019 13:57 15

i’m sure if you google jsonata you’ll find it

Topic		Replies	Views
Extarcting values from XML files General	7	4514	12 July 2019
XML decoding data from SONG (extracted from db) Dashboard	5	181	30 December 2022
Extract certain values from XML General function-node	3	225	7 September 2022
How can i read stream xml file using Node red General node-red-dashboard	6	765	21 May 2022
Parsing serial data General	2	1271	26 July 2019

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Parse Data from XML

Related topics