Icon

03_​XML_​meets_​JSON

Will they blend? XML meets JSON
The challenge here is to blend together data in XML format with data in JSON format. JSON Parsing XML Parsing extract "title" element to multiple rowsungroup collection rowto multiple rowsextract "title" element to collection rowappendflow var topicappendflow var topicall headlineswith duplicateskeep only column "title"common headlineskeep only column "title"news aboutMichelle Obamain JSON formatnews aboutBarack Obamain XML format XPath Ungroup JSON Path ConstantValue Column ConstantValue Column Concatenate Column Filter ReferenceRow Filter Column Filter JSON Reader XML Reader The challenge here is to blend together data in XML format with data in JSON format. JSON Parsing XML Parsing extract "title" element to multiple rowsungroup collection rowto multiple rowsextract "title" element to collection rowappendflow var topicappendflow var topicall headlineswith duplicateskeep only column "title"common headlineskeep only column "title"news aboutMichelle Obamain JSON formatnews aboutBarack Obamain XML format XPath Ungroup JSON Path ConstantValue Column ConstantValue Column Concatenate Column Filter ReferenceRow Filter Column Filter JSON Reader XML Reader

Nodes

Extensions

Links