@MattWho Thank you for your help, This is all my flow: I send a JSON like this : { "User": "user", "Key": "ABC", "Table": "Table", "Rows": [ { "CODIGO": 1, "NOME": "ABC REPRESENTACOES LTDA", "NOME_FANTASIA": "PEDRO LIMA", "ENDERECO": "RUA SANTOS, 178", "BAIRRO": "", "CIDADE": "SAO PAULO", "UF": "SP", "CEP": "11008999", "TELEFONE": "(11) 99887 1234", "EMAIL": "pedro.lima@email.com", "FUNCAO": "REPRESENTANTE", "CODIGO_SUPERIOR": "", "CNPJ": "", "INSCRICAO_ESTADUAL": "", "NRO_CONTRATO": "8918-A", "NRO_REG_EMPREGADO": "", "DATA_CONTRATACAO": "2018/06/28", "DATA_DESLIGAMENTO": "", "SITUACAO": "ATIVO", "REGIAO": "SP" } ] } And at some point the API called returns an error, that at some point I need to deal with in order to insert the error in our database. This error is expected in the HTTP response. Follows the configuration of the processors: ReplaceText = EvaluateJsonPath = This is Response Before Replace Text = {"RegistrosRecebidos":1,"RegistrosImportados":0,"Erros":["Erro registro 0: The statement has been terminated.\r\nString or binary data would be truncated in table \u0027Ober_HML.dbo.DB_WS_IMP_CLIENTE\u0027, column \u0027NOME_FANTASIA\u0027. Truncated value: \u0027ADLER PELZER PERNAMBUCO IND. E COMERCIO \u0027."]} What I need is to take the value of the "Errors" property and save it in my database, only when trying to do this with EvaluateJsonPath it returns the following error: For this reason I am trying to use ReplaceText but also without success. I don't know if I managed to be clear enough in my doubt.
... View more
