Help Desk

Submit a ticket My Tickets
Welcome
Login

How to convert CSV to JSON and keep the value as numeric?

Hi,


How to convert a CSV with numeric value into JSON without a double quotation in the result JSON?

The result JSON will be used as payload to do update in Dynamics CRM. Due to the double quotation in JSON,  the update Dynamics CRM command failed with updating a numeric data field with text value.  


Source CSV:


Col_A, Col_B

John, 10.5


JSON Result:


By Using "CSV to JSON"

{"Col_A":"John", "Col_B":"10.5"} (this one failed when updating Dynamics CRM)



Dynamics CRM is expecting the below JSON:

{"Col_A":"John", "Col_B":10.5}



Thanks,

Ivan






  • Hi Ivan,


    The BizApp by default will wrap all key/value pairs in quotes.  The solution will be to use the Find/Replace command with a RegEx Expression.  You will want to use the find/replace under the "File Utilities".


    Thank you,

    Wayne Paffhausen

    Director, Customer Success

Login to post a comment