Question & Answer
Question
I have a simple orchestration pulling data from a SalesForce object. The column that I am pulling is a numeric data type defined in SFDC as Number (18,0). One record has a value in it of 10,000,000 (10 Million). When the data is exported, it returns 1.0E7 (Scientific notation for 10 million). Causing data issues in the destination system as it is expecting the data to be 10,000,000.
Why is this happening?
Why is this happening?
[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS3LC4","label":"App Connect Professional"},"ARM Category":[{"code":"a8m50000000CkmOAAS","label":"ACP-\u003EConnectors-\u003ESalesforce"}],"ARM Case Number":"TS006949553","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.4"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
28 April 2025
UID
ibm16525232