Get the text from a RSS Resource

[DickLiu]

Is there a any better and shorter programming to get the text what we need?

Thanks for help!!

[ChrisWard]

Hello DickLiu

Instead of an image, please upload the RSS data as a text file.

Question: Is the text you need always in the lines as marked up? (lines 4, 8 and 14)

[DickLiu]

RSS Data：https://invoice.etax.nat.gov.tw/invoice.xml

In this moment I just need the text of lines 4, 8 and 14.

Thanks!

[ABG]

There is a very powerful dictionary block that accepts a path and dictionary or list, to dive deep into a structure like yours:

Here is what your data structure looks like, tidied up:

XML_to_dict.aia (5.2 KB)

I leave it to you to experiment, since it's your elegance/effort tradeoff.

[Juan_Antonio]

@DickLu

I have added the XmlToJson block (which converts an XML string to another JSON string) to my extension and I am testing it with your example.

Extension. JSON Decode. JsonPATH. Get the value easily. Convert XML <> JSON

Hello friends, with this extension we can obtain the values ​​of a JSON text, writing its path. We can also convert string XML to JSON and from JSON to XML. JSON: https://www.json.org/json-es.html In JSON we can find: Object, the elements is in {brace}, for example: {"age": 25, "name": "Juan Antonio", "value": true} Array, the elements is in [square bracket], for example: ["24", "Pedro Luis", false] In Array the elements are numbered: store.book [1] 1.- JSON Examples: https://jso…

This XmlToJson block has some problems with XML CDATA codes, but it works.

XmlToJson.aia (608.5 KB)

[DickLiu]

Thanks! I would try it!

[DickLiu]

Thanks for your reply!!

[Juan_Antonio]

Fixed "problems with XML CDATA codes"

Get_XML_JSON.aia (582.7 KB)

Updated KIO4_DecoJson.aix extension.
Now XmlToJson and JsonToXml

Extension. JSON Decode. JsonPATH. Get the value easily. Convert XML <> JSON

Hello friends, with this extension we can obtain the values ​​of a JSON text, writing its path. We can also convert string XML to JSON and from JSON to XML. JSON: https://www.json.org/json-es.html In JSON we can find: Object, the elements is in {brace}, for example: {"age": 25, "name": "Juan Antonio", "value": true} Array, the elements is in [square bracket], for example: ["24", "Pedro Luis", false] In Array the elements are numbered: store.book [1] 1.- JSON Examples: https://jso…

[DickLiu]

Thank you so much!!