xsl stylesheet that will transform this XML into JSON and then use different means of being able to address the information inside it.Ī little searching and I came across this excellent xml-to-json.xsl file that does the trick. I thought to myself, “Self… you should be able to find an. That’s when I remembered the xmlTransform() function. Here’s what I was using: variables.dateOfBirth = xmlSearch(thisSubject,"//*").xmlText Īnd it just seemed kludgey and wrong.
Here’s where ColdFusion comes in.Īt first, I was going to try and use xmlParse() and xmlSearch() to be able to extrapolate the data from the resulting XML document. Ugly, right? It would be much better to represent that data via JSON. The XML is coming from TransUnion (one of the “big three” credit companies in the United States) and it’s a representation of a credit report on a consumer.įor sake of understanding my pain, here’s the XML. That being said, I’m working on a project that requires that I pull a data feed of a big, ugly XML document that’s complex and cumbersome to utilize. I’m much more familiar with JSON and using ColdFusion structures and arrays. I know very little about XML other than it’s a pain in the to parse, search, and use.
0 kommentar(er)
