Long Text field (XML) to JSON string

(Joe Hatch) #1

We’re taking an XML webhook from FLG, transforming the data into JSON and parsing it into our HubSpot CRM.

The issue we’re having is with Long String inputs in FLG not parsing into JSON due to not escaping line breaks - do you have a way to format the string so that it doesn’t trigger a 400 JSON error:

“companyMessage”: “Invalid input JSON on line 29, column 85: Illegal unquoted character ((CTRL-CHAR, code 13)): has to be escaped using backslash to be included in string value”

(Kellsey Shaw) #2

Hi Joe,

Can you email me a screenshot of the logs showing the expanded task that you are trying to use the data from so I can see what the data looks like that you are parse?

(Joe Hatch) #3

Hi Kellsey - will email this to you as contains sensitive data.

Thanks