Hi,
I have a SOA 12c service which integrates with Salesforce (SF). I am doing upsert operation and during the updates, some of the date fields do not have data and so we need to pass null data. I had used transformation and extracted the null fields and loaded in the "fieldsToNull" element of SF schema. However the upsert operation returns errors of invalid date format. Any help is appreciated, thanks.
\<tns:externalIDFieldName>
\<xsl:value-of select='"External\_Id\_\_c"'/>
\</tns:externalIDFieldName>
\<xsl:for-each select="/ns0:newDBOutputCollection/ns0:newDBOutput">
\<tns:Account>
\<xsl:for-each select="/ns0:newDBOutputCollection/ns0:newDBOutput/\*\[@xsi:nil = 'true'\]">
\<ns2:fieldsToNull>
\<xsl:value-of select="local-name(.)"/>
\</ns2:fieldsToNull>
\</xsl:for-each>
\<ns2:Id/>
\<ns2:AccountNumber>
\<xsl:value-of select="ns0:Customer\_Id\_11i\_\_c"/>
\</ns2:AccountNumber>
\<ns2:Account\_Closed\_Date\_\_c>
\<xsl:value-of select='xp20:format-dateTime (ns0:Account\_Closed\_Date\_\_c, "\[Y0001\]-\[M01\]-\[D01\]" )'/>
\</ns2:Account\_Closed\_Date\_\_c>
\<ns2:Account\_Opened\_Date\_\_c>
\<xsl:value-of select='xp20:format-dateTime (ns0:Account\_Opened\_Date\_\_c, "\[Y0001\]-\[M01\]-\[D01\]" )'/>
\</ns2:Account\_Opened\_Date\_\_c>
\<ns2:Last\_Credit\_Review\_Date\_\_c>
\<xsl:value-of select='xp20:format-dateTime (ns0:Last\_Credit\_Review\_Date\_\_c, "\[Y0001\]-\[M01\]-\[D01\]" )'/>
\</ns2:Last\_Credit\_Review\_Date\_\_c>
\<ns2:Payment\_Grace\_Days\_\_c>
\<xsl:value-of select="ns0:Payment\_Grace\_Days\_\_c"/>
\</ns2:Payment\_Grace\_Days\_\_c>
\<ns2:Apparel\_Level\_\_c>
\<xsl:value-of select='"Y"'/>
\</ns2:Apparel\_Level\_\_c>
\<ns2:Bg\_Data\_Discount\_\_c>
\<xsl:value-of select="ns0:Bg\_Data\_Discount\_\_c"/>
\</ns2:Bg\_Data\_Discount\_\_c>
Error:
Thanks,
Sudheer