X

The Integration blog covers the latest in product updates, best practices, customer stories, and more.

  • July 25, 2019

Support for zip/json/xml based schema in Stage File action

Namratha Narayan
Project Lead, SOA

The Stage File action can read, write, zip, unzip and list files in a staged location known to Oracle Integration. 

Before, only a CSV file could be used to describe the structure of the file in Stage File action.

Now, XML or JSON document can also be used to describe the structure of the file contents in Stage File action. Zip File containing multiple schemas can also be uploaded.

 

The Schema Options page is displayed if you selected a read or write stage file operation.

Before, this is how the Stage File action Schema options page would look like:

Schema options page would have following schema options:

  • Create a new schema from a CSV file/
  • Select an existing schema from the file system

 

Nowthis is how the Stage File action Schema options page will look like for:

  • Read Entire File and Write File operation

Schema options page will have following choices:

  • Sample delimited document (e. CSV)
  • XML schema (XSD) document
  • Sample XML document (Single or No NameSpace)
  • Sample JSON document

 

  • Read File in Segments operation

Schema options page will have following choices:

  • Sample delimited document (e. CSV)
  • XML schema (XSD) document
  • Sample XML document (Single or No NameSpace)

 

Based on your selection on the Schema Options page, the Format Definition page enables you to select the file for describing the structure.

This is how the Stage File action Format Definition page will look like for:

  • Sample delimited document (e. CSV) choice

 

  • XML schema (XSD) document choice

 

In case of Read Entire File and Write File operation

You can upload a ZIP file that includes multiple schemas in which one schema has a reference to the other schema file (for example, schema A imports schema B).

 

In case of Read File in Segments operation

You cannot upload a ZIP file that includes multiple schemas in which one schema has a reference to the other schema file (for example, schema A imports schema B). Read File in Segments option does not work when it reads the element that belongs to schema B.

 

New field 'Select Repeating Batch Element' to select the repeating element when Stage Read is configured with Segmentation will be available

 

  • Sample XML document (Single or No NameSpace) choice

 

  • Sample JSON document choice (This choice is not available in case of Read File in Segments operation)

 

This is how you can upload schema in Stage File action using not only CSV file but also XML, XSD or JSON file.

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.