Remove quotes from field value in json, convert string to number

David Moran Strategic Partner NetSuite Integration Whiz Salesforce Integration Whiz

• April 05, 2022 17:44

I have a field in the JSON that's pulled as string and I need to have it showing as a number in the JSON.

Original:

      "productId": "1378427812",

Desired: 

      "productId": 1378427812,

During the mapping, when I change the Field Type to Number, it returns a cero in the value field.

0

• 

  Gil Querubin

  • June 07, 2022 20:14

  

  any update on this?

   

  0
• 

  David Moran Strategic Partner NetSuite Integration Whiz Salesforce Integration Whiz

  • June 07, 2022 20:19

  

  

  

  This is not needed anymore, I've accomplish this with a script, but couldn't find a way to do it using the mapping settings

  0

Please sign in to leave a comment.