Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Converting CSV file to XML or JSON — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Converting CSV file to XML or JSON

Accepted answer
142
Views
2
Comments
edited Jan 22, 2019 11:51PM in Integration 2 comments

Summary

I need to convert a CSV file to XML or JSON object

Content

Hello All!

I apologize if this question has been asked already and/or is a simple one but I couldn't find a post for a solution. I just started my career path in PaaS and am in need of assistance.

The scenario:

this is being done in the OIC.

I'm getting invoice data in the form of CSV where each row can have repeating invoice numbers. I need to compare the total invoice amount to whatever breakdown I get. If the sub amounts do not add up to the grand total I want to skip(not process) that subset.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!