@Product I'm trying something new for a wrkflow to try and preserve the escaped quotes and newlines in a JSON item.
https://account.wrk.com/designer/?wrkflow_id=58237&client_id=5806
I divided the JSON array from Gemini and then used "Add a new field to a JSON" to add the information I needed to query from QBO.
It seems to work fine when there's an escaped quote or an escaped newline character as my output had one example of each. However, this one has both an escaped quote and newline character and it threw an ITC saying:
System Error: Add a new field to a JSON caused an error: The value you provided in “Original JSON” is not in JSON format. Please verify your entry and try again. JSON string is invalid. Error: Expecting property name enclosed in double quotes: line 1 column 187 (char 186)" "Error occurred at position 186. Failed character:
Substring around the error: ds", "Sal. Job ebcda724-7a37-471e-be35-09f30139e972
