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

Visit Redwood Community
NXSD define trailing optional columns — 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

NXSD define trailing optional columns

Received Response
1
Views
2
Comments

I am trying to read a csv file in Oracle Integration Cloud (OIC). OIC accepts an xsd file to define the format for the inbound csv file. The issue I'm having is that the csv file can have optional columns, and I can't figure out how to define this in NXSD.

I can define an xsd to say the csv to have 5 cols or 3 cols. But how do I provide a single xsd to say the first 3 cols are to be expected (mandatory) and cols 4 & 5 may or may not be available?

I am also told that SOA Suite has a "Native Format Builder Wizard" that can do this, but I do not have access to this. Can someone please help?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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