EQUIVALENCES OF VARIOUS XML FILES FOR PARSE JSON

(0) Share

Report

Posted on by fgonzalez515

296

Hello Community,

I have several XML files, but there are files that have one item and others have 5 or more items.

When using PARSE JSON, it works in some files but in another it gives me an error.

How can I do PARSE JSON equivalence for all my XML files?

I attach two files, the 714 file works fine for me, but the 951 gives me an error.

I leave images of the flow

FILES.zip

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @fgonzalez515

Parse JSON is used for parsing JSON string ,It is not recommended for XML format data.

for XML, use xml function on the xml text content and then you will get the xml structured data.

See below

I used xml function like below by pasisng file content inside xml function.

I am also wondering how parse json worked on some files, will try that as well and let you know !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Nived_Nambiar

That's how I did it from the beginning.
How can I solve the Scheme thing?

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @fgonzalez515

Now got it. So the reason is schema validation

Did you check both files has same schema ?

I see the process failed for file 951 not for file 714 . So did you created that schema using file 714 ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Nived_Nambiar

Thanks for you answer.
I was able to find solution.

Was this reply helpful? Yes No