Is there a way to handle fields with only spaces using ODI?

Question

I have a json file with the following snippet

{
    "brandName": "b1Name",
    "brandDesc": "b1Desc",
    "brandId": "75",
    "storeName": " "
},
{
    "brandName": "b2Name",
    "brandDesc": "b2Desc",       
    "brandId": "81",
    "storeName": null
},

And for mapping purposes, the following XSD file is created

<?xml version = '1.0' encoding = 'UTF-8'?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
            xmlns="http://TargetNamespace.com/BrandListReference_getBrands_response"
            targetNamespace="http://TargetNamespace.com/BrandListReference_getBrands_response"
            elementFormDefault="qualified" xmlns:nxsd="http://xmlns.oracle.com/pcbpel/nxsd" nxsd:version="JSON"
            nxsd:jsonTopLevelArray="true" nxsd:encoding="UTF-8">
  <xsd:element name="brands">
    <xsd:complexType>
      <xsd:sequence>
        <xsd:element name="brand" minOccurs="0" maxOccurs="unbounded">
          <xsd:complexType>
            <xsd:sequence>
              <xsd:element name="brandName" type="xsd:string"/>
              <xsd:element name="brandDesc" type="xsd:string"/>
              <xsd:element name="brandId" type="xsd:integer"/>
              <xsd:element name="storeName" type="xsd:string"/>
            </xsd:sequence>
          </xsd:complexType>
        </xsd:element>
      </xsd:sequence>
    </xsd:complexType>
  </xsd:element>
  <xsd:annotation xmlns="">
    <xsd:appinfo>NXSDSAMPLE=</xsd:appinfo>
    <xsd:appinfo>USEHEADER=false</xsd:appinfo>
  </xsd:annotation>
</xsd:schema>

Translation Failure. Failed to translate JSON to XML. cannot normalize! The incoming data does not conform to the NXSD schema. Please correct the problem.

After checking the JSON and nulling storeName in the first element transformation works fine. Is there a way to handle spaces only string values? As I have no control over the data provided in the JSON file.

VietnamDataEngineer · Accepted Answer · 2022-03-11 07:48:36Z

0

Befor insert to target table in Mapping(Interface), you use Component Split to split data to 2 target. If trim(col) is null data go to error_table If trim(col) is not null data go to target_table

answered Mar 11, 2022 at 7:48

VietnamDataEngineer

1714 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

akhamees Over a year ago

The part I'm trying to figure out is how the XSD could handle this, is there a special attribute or way to define the element to handle only space fields?

Collectives™ on Stack Overflow

Is there a way to handle fields with only spaces using ODI?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related